Data Object Definition
Geographic data shows the grouping of countries into a hierarchy of regions and zones, for purpose of aggregating sales data for analytics and reporting.
Data Model
Customer data in the Data Lake is composed of 4 different table views:
- DIM_geo_zone
- DIM_region
- DIM_country
- DIM_mini_zone
Project Space: prj-data-pricing-dev
See how this entity relates to the others in the pricing data model here.
Additional Info & Comments
Tables & Attributes
View ID: prj-data-pricing-dev.DataOcean.V_DIM_geo_zone
| fullname | type | description |
|---|---|---|
| geo_zone_key | STRING | |
| geo_zone_id | STRING | |
| geo_zone_name | STRING | |
| meta_source_system | STRING | |
| inserted_date | TIMESTAMP | |
| updated_date | TIMESTAMP | |
| delete_flag | BOOLEAN |
View ID: prj-data-pricing-dev.DataOcean.V_DIM_region
| fullname | type | description |
|---|---|---|
| region_key | STRING | |
| region_id | STRING | |
| region_name | STRING | |
| country_key | STRING | |
| country_id | STRING | |
| country_name | STRING | |
| meta_source_system | STRING | |
| inserted_date | TIMESTAMP | |
| updated_date | TIMESTAMP | |
| delete_flag | BOOLEAN |
View ID: prj-data-pricing-dev.DataOcean.V_DIM_country
| fullname | type | description |
|---|---|---|
| country_key | STRING | |
| country_id | STRING | |
| country_name | STRING | |
| meta_source_system | STRING | |
| inserted_date | TIMESTAMP | |
| updated_date | TIMESTAMP | |
| delete_flag | BOOLEAN |
View ID: prj-data-pricing-dev.DataOcean.V_DIM_mini_zone
| fullname | type | description |
|---|---|---|
| mini_zone_key | STRING | |
| mini_zone_id | STRING | |
| mini_zone_name | STRING | |
| meta_source_system | STRING | |
| inserted_date | TIMESTAMP | |
| updated_date | TIMESTAMP | |
| delete_flag | BOOLEAN |
This data is available as of Q3 2023.