Time dimension for Day granularity
| Column Name | Type | Length | Nullable | Unicode | Description |
|---|---|---|---|---|---|
| begin_ts | timestamp | N/A | false | Timestamp indicating the beginning range of this time period | |
| day_id | bigint | N/A | false | Surrogate primary key Primary key. | |
| day_of_month | int | N/A | false | The day of the year | |
| end_ts | timestamp | N/A | false | Timestamp indicating the end range of this time period | |
| month_of_year | int | N/A | false | The mont of the year | |
| week_of_year | int | N/A | false | The week of the year | |
| year | int | N/A | false | The year |