Basic Info  

Customer data in the Data Lake is composed of 4 different table views:

  1. DIM_geo_zone
  2. DIM_region
  3. DIM_country
  4. DIM_mini_zone

Project Space: prj-data-pricing-dev
See how this entity relates to the others in the pricing data model here.

Tables & Attributes:

View ID: prj-data-pricing-dev.DataOcean.V_DIM_geo_zone

fullnamemodetypedescription
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 

fullnamemodetypedescription
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 

fullnamemodetypedescription
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

fullnamemodetypedescription
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

Other Info & Comments  

-