SQL
ReleaseWorth evaluating
time_bucket adds fixed-width timestamp buckets in SQL
From Databricks release notes (AWS)
Databricks SQL now has the time_bucket function, which returns the start of the fixed-width interval that contains a timestamp. Use it instead of date_trunc when the bucket width or bucket origin is not a calendar unit.
Learners writing time-based SQL aggregations now have a function for custom bucket widths and origins.
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