SQL
ReleaseWorth evaluating
counter_diff is now available for SQL window calculations
From Databricks release notes (AWS)
Databricks added the counter_diff window function for time-series counter data. It calculates differences between consecutive cumulative counter values and handles counter resets, and is available in Databricks SQL and Databricks Runtime 19 and above.
Learners using SQL window functions now have a built-in function for cumulative counters that can reset.
What to re-read
More from SQL
- ReleaseDocument Intelligence REST APIs for parse, extract and classify reach GA
- PreviewPredictive AI Functions enter Beta: forecasting, anomalies and predictions in SQL
- Releaseai_parse_document now returns chart values as structured JSON
- ReleaseStandard ai_extract moves to a faster model checkpoint