Martin DebusPosted on LinkedIn In Databricks SQL, one of the lesser known functions is Rollup. With Rollup to get multiple levels of aggregation in one step.
This is nice if you need grand and subtotals for each grouping column.
No separate aggregations are needed this way.
View on LinkedInIn Databricks SQL, you can use dynamic parameters with values derived from a query.
Generated Columns in Databricks is a great feature to automatically create surrogate keys and populate columns using generation expressions.
SNOWGLOBE helps teams set up, grow and run Azure Databricks platforms.