Description
Time dimension table
Columns
| Column Name | Type | Description |
|---|---|---|
time_key |
int32
|
Surrogate key corresponding to the second of the day. The value -1 indicates a NULL timestamp |
time |
string
|
24 Hour format time HH:mm:ss |
hour |
string
|
24 Hour format hour of the day HH:00:00 |
hour_int |
int32
|
24 Hour format integer hour of the day 0-23 |
half_hour |
string
|
24 Hour format quarter hour of the day HH:30:00 |
quarter_hour |
string
|
24 Hour format quarter hour of the day HH:15:00 |
business_id |
string
|
Unique identifier for the business |
data_current_as_of_utc |
timestamp[ns]
|
No description provided. |
source_type |
string
|
No description provided. |