The analytical schema is a repository for master and transactional data in Google BigQuery. Use the analytical schema to gain insights into the data.
When you run Cloud Data Integration taskflows, the Cloud Data Integration assets transform and publish master data from the Google BigQuery staging store into Google BigQuery dimension and fact tables.
The analytical schema 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 target dimension and fact tables.
The following image shows the tables of the Google BigQuery analytical schema and their relationships:
