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
Geographic data in the Data Lake is composed of 4 different table views:
Project Space: prj-data-pricing-dev
See how this entity relates to the others in the pricing data model here.
Additional Info & Comments
Below is the overview over the structure of geographic hierarchy.
- Countries are logically divided into below 4 Geographic Zones based on geography, mostly aligning with the location Solvay plant/sites resides.
ASIA PACIFIC
EUROPE
LATIN AMERICA
NORTH AMERICA - Geo Zones are further divided into Mini Zone
- Each Mini Zone will have one or many countries under it
- Each country is further divided into smaller Regions
Data Flow
- Extract Type(Snapshot/Delta): Full data will be extracted from source (SAP-BW) on a daily basis
- Schedule: Jobs will be scheduled to run everyday at <<>>hrs
- Mapping Document:
Tables & Attributes
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 |