Calendar grid with a rolling range of highlighted days next to a clock face

Calendar and Time Dimensions for Databricks in Plain SQL

Nearly every data warehouse needs a calendar dimension, and some need a time dimension too. Time at the Lakehouse provides a set of SQL files that builds both dimensions in Databricks, documented for humans and AI agents. Each dimension is a single set-based query, with no recursive CTEs, loops, or UDFs. That makes them easy to read, easy to change, and fast to run. Background I published the predecessor in early 2022 while at BlueGranite, as the calendar-dimension-spark repository and a companion post, Generate a Calendar Dimension in Spark....

November 20, 2026 · Chris Koester