Data Verticals
Utility
Utility models to aid analyses.
Numbers Utility Table
| Table | Description |
|---|---|
common.utility.numbers | Utility table containing sequential numbers from 0 to 1 billion. For use in analytical queries and data generation. |
Unique Key:
number| Column Name | Description |
|---|---|
number | The sequential number (primary key) |
number_hex | The hexadecimal representation of the number |
Timestamp Utility Tables
| Table Name | Description |
|---|---|
common.utility.dates | Date dimension table containing dates from January 1, 1970 to December 31, 2500, with various date-related attributes for time-based analysis and reporting. |
common.utility.hours | Hourly dimension table containing dates from January 1, 1970 to December 31, 2500, with various time-related attributes for detailed time-based analysis. |
Unique Key:
hour_timestamp| Column Name | Description |
|---|---|
hour_timestamp | The timestamp representing the start of the hour (primary key) |
date | The calendar date for this hour |
hour_of_day | The hour within the day (0-23) |
am_pm | Indicator for AM or PM |
hour_display | Human-readable hour format (e.g., ‘2 PM’, ‘10 AM’) |
day_part | Part of day (Morning, Afternoon, Evening, Night) |
is_business_hour | Boolean flag indicating if the hour falls within typical business hours (9 AM - 5 PM) |
previous_hour | The timestamp of the previous hour |
next_hour | The timestamp of the next hour |
day_of_week | The day of the week (0=Sunday, 6=Saturday) |
day_name | The name of the day of the week (Monday, Tuesday, etc.) |
month | The month of the year (1-12) |
year | The year component of the timestamp |
quarter | The quarter of the year (1-4) |