MDM Extension for Databricks > MDM SaaS and Databricks integration > Analytical schema

Analytical schema

The analytical schema contains the dimension tables in Databricks that store transformed master data. Use the analytical schema to analyze and gain insights into the master data.

When you run Data Integration taskflows, Data Integration transforms and loads master data from the Databricks staging tables into the dimension tables of the analytical schema in Databricks.

The analytical schema is optimized for Databricks SQL. Unity Catalog, the Databricks governance layer for data and AI assets, manages the analytical schema.

The analytical schema in a Databricks catalog includes the following dimension 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

Based on your use case, you can create or edit the dimension tables.

Note:

The extension package doesn't include transaction tables. To analyze sales and supplier orders, you must create the create the Sales Fact and Supplier Order Fact transaction tables.

The following image shows the dimension tables of the Databricks analytical schema and their relationships with the Sales Fact table: The Sales Fact table joins directly to the Item, Calendar, Customer, Phone, and Location dimension tables. The Customer dimension table also links to the Phone, Email, and Address dimension tables, and the Location dimension table links to the Address dimension table.

The Sales Fact table joins directly to the Item, Calendar, Customer, Phone, and Location dimension tables. The Customer dimension table also links to the Phone, Email, and Address dimension tables, and the Location dimension table links to the Address dimension table.

Note:

Some tables contain more fields than shown in the diagram. For the complete list, see the analytical schema in Databricks.

The following image shows the dimension tables of the Databricks analytical schema and their relationships with the Supplier Order Fact table:

The Supplier Order Fact table joins directly to the Item, Calendar, Customer, and Location dimension tables. The Customer dimension table links to the ESG Score DnB, Email, Address, and Phone dimensions tables, and the Location dimension table links to the Address, Email, and Phone dimension tables. The ESG Score DnB dimension table further links to the ESG Score DnB Governance Reason, ESG Score DnB Social Reason, and ESG Score DnB Environmental Reason dimension tabless.

Note:

Some tables contain more fields than shown in the diagram. For the complete list, see the analytical schema in Databricks.