The analytical schema is a repository for master and transactional data in Snowflake. Use the analytical schema to gain insights into the data.
When you run Cloud Data Integration taskflows, Cloud Data Integration transforms and publishes master data from the Snowflake staging tables into the dimension and fact tables of the analytical schema in Snowflake.
The analytical schema named INFARETAIL_SNOWFLAKE_ANALYTICS includes the following dimension and fact tables:
•tbl_address_dim
•tbl_calendar_dim
•tbl_customer_dim
•tbl_email_dim
•tbl_esg_score_dnb_dim
•tbl_esg_score_dnb_environmental_reason_dim
•tbl_esg_score_dnb_governance_reason_dim
•tbl_esg_score_dnb_social_reason_dim
•tbl_item_dim
•tbl_location_dim
•tbl_phone_dim
•tbl_supplier_dim
•tbl_sales_txn_fact
•tbl_supplier_order_txn_fact
Based on your use case, you can create or edit the dimension and fact tables.
The following image shows the dimension tables of the Snowflake analytical schema and their relationships with the Sales fact table:
Note: Some tables contain more fields than shown in the diagram. For details, refer to the analytical schema in Snowflake.
The following image shows the dimension tables of the Snowflake analytical schema and their relationships with the Supplier Order fact table:
Note: Some tables contain more fields than shown in the diagram. For details, refer to the analytical schema in Snowflake.
