@databricks @azuredatabricks tips straight to your twitter feed! For Beginners to Advanced users with snippets and examples.
#databricks by @fusionet24
There's a really rich #R package for databricks from databricks-labs. You should give it ago. If you've previously used Sparklyr or SparkR this is a worth while package to pick up for your platform.
I've jumped into a quick overview below https://t.co/kg3I5xlJFi
1/6 ๐ Launching #Decembricks!
24 days of @databricks tips to supercharge your data engineering.
Day 1: The hidden power of IPython events - your ticket to professional-grade notebook engineering ๐
Check this one out seriously! The code is at the bottom
1/4 ๐งต Just published a guide on creating Custom IPython Magics in Databricks!
First, we'll cover the basics:
Line magics (%) vs Cell magics (%%)
Creating custom commands
Registering your magics
๐ก Quick fix: Try 'UNDROP TABLE WITH ID' instead of table name. And if you've got naming conflicts, use 'ALTER TABLE RENAME' first to clear the path for restoration. #TechTips#DatabaseAdmin 3/3
https://t.co/U0n9vugy5g
๐ Getting the INVALID_STATE.RESTORATION_PERIOD_EXPIRED error in #Databricks when trying to undrop tables? Even within the 7-day window? Here's what you need to know...
๐ Pro tip: Use 'SHOW TABLES DROPPED' to get the exact table ID and drop time. Sometimes the issue isn't about timing - it could be naming conflicts or incorrect table references. #DatabricksSQL#DataOps 2/3
Ever fancied using a managed identity for your #Azure#Databricks workspace that already exists and to start using it only requires a few lines of code?
Find out how to use this from your Managed Resource Group https://t.co/5uIYWaHr4E
๐งต Dynamically Loading Unit Tests in Databricks Notebooks ๐
1/ Tired of the hassle of manually maintaining test suites?
Want to keep your tests closer to your code?
Our latest tip dives into dynamically loading unit tests using Python's unittest library. ๐๐งช
3/ We break down the process step by step, from setting up the TestSuite to filtering and loading the discovered tests. ๐ Code samples included! ๐ป
2/2 By defining a window spec once & referencing it by name, you can:
๐นReuse complex definitions
๐นImprove query readability
๐นAvoid errors
Check out the blog for a quick guide with examples! ๐ https://t.co/gzqgbts7fH
#DataWithDatabricks#SparkTips
๐ก#Decembricks Day 2
Use #DeltaLake's custom metadata to:
- Track data quality metrics
- Maintain audit trails
- Document pipeline versions
- Monitor data transformations
Full guide with code examples below ๐
@Databricks#DataEngineering#Databricks