Description
Date dimension table
Columns
| Column Name | Type | Description |
|---|---|---|
date_key |
int32
|
Surrogate key integer in the form YYYYMMDD. The value -1 indicates a NULL date |
date |
date32[day]
|
Date in the form of YYYY-MM-DD |
day_of_week |
string
|
Name of the day of the week in the form of Monday, Tuesday, etc. |
day_of_week_short |
string
|
Short, 3 letter, name of the day of the week in the form of Mon, Tue, etc. |
day_of_week_number |
int32
|
Day of the week in integer format, where 1 is the first day of the week (Sunday) and ends on 7 (Saturday) |
day_of_week_number_iso |
int32
|
Day of the week in integer format, where 1 is the first day of the week (Monday) and ends on 7 (Sunday) |
calendar_week_year |
string
|
Calendar week in the form of 'Mar 18 - Mar 24, 2018'; sorted by calendar_year_week_number |
calendar_year_week_number |
int64
|
Sequential week number across years with week starting on Sunday (integer format); A week always counts 7 days and when a week crosses over from December into January, for example, the same week number is used on both sides [useful for sorting calendar_week_year] |
calendar_month_year |
string
|
Month and year as a string in the form of Mar 2018; sorted by calendar_year_month_number |
calendar_year_month_number |
int32
|
Sequential integer month number across years (computed as [calendar_year] * 12 + [calendar_month_number] – 1) [useful for sorting calendar_month_year] |
calendar_month_year_order |
int32
|
Ordered months across years (Aug 2025 becomes 202508) |
calendar_start_of_month |
date32[day]
|
First date of the month in the form of YYYY-MM-DD |
calendar_end_of_month |
date32[day]
|
Last date of the month in the form of YYYY-MM-DD |
calendar_date_previous_year |
date32[day]
|
The same relative day in previous year |
business_id |
string
|
Unique identifier for the business |
calendar_day_of_month_number |
int32
|
Sequential number of the day within the month |
calendar_month_number |
int32
|
Calendar month number, where 1 is January |
calendar_month |
string
|
Calendar month full name name, sorted by calendar_month_number |
calendar_month_short |
string
|
Calendar month name, three letters, sorted by calendar_month_number |
calendar_year |
int32
|
Calendar year number |
calendar_day_of_year_number |
int32
|
Sequential number of the day within the year |
date_short |
string
|
Short date and name of the day of the week |
data_current_as_of_utc |
timestamp[ns]
|
No description provided. |
source_type |
string
|
No description provided. |