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.
This data is available in the Data Ocean as of Q3 2023.
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 |