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....