Martin DebusPosted on LinkedIn After ROLLUP for Databricks SQL last week, today comes GROUPING SETS.
As the documentation notes, ROLLUP is just syntactic sugar for a specific GROUPING SETS expression.
GROUPING SETS allow for fine granular control over aggregation levels of GROUP BY columns.
This is perfect for multi-dimensional analysis without redundant queries.
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.