On LinkedIn
SQL
Databricks SQL features and functions that make everyday queries shorter and clearer.
13 posts
SQL Dynamic Parameters
In Databricks SQL, you can use dynamic parameters with values derived from a query.
Generated Columns
Generated Columns in Databricks is a great feature to automatically create surrogate keys and populate columns using generation expressions.
The Lakehouse Path: SQL Warehouse Query Caching
Most data engineers know about Databricks query caching, but few understand how it actually works under the hood.
Databricks SQL Lead Lag Function
The lead and lag window functions in Databricks SQL are strong when analyzing sequences.
Serverless SQL Warehouse Query Cache
I played around a little with the Databricks Serverless SQL Warehouse and this is what I found out about caching: - The same query once submitted as upper case and repeated as lower case comes from cache.
Using IDENTIFIER clause in Databricks SQL
A dynamic way to use catalog, schema, and table names in Databricks SQL scripts.
Let's talk about your lakehouse.
Thirty minutes, no slides. Bring the question that keeps coming back.