The staging schema contains the tables in Databricks that store master data published from MDM SaaS. The tables store the master data until it is transformed and loaded into the analytical schema.
To publish master data from MDM SaaS to the staging schema in Databricks, run the predefined egress jobs for the record type you manage.
The staging schema in a Databricks catalog includes the following tables for MDM SaaS record types:
MDM SaaS Record Type
Staging Tables
Customer
The staging schema includes the following tables for the customer domain:
- org_address
- org_alternateName
- org_document
- org_email
- org_financial
- org_identifier
- org_indicator
- org_insurance
- org_keyexecutive
- org_phone
- org_customer
- org_segment
- org_socialhandle
- org_status
- org_stockexchange
- org_taxdetails
- org_xref
- person_address
- person_alt_name
- person_citizenship
- person_demographic
- person_document
- person_email
- person_financial
- person_identifier
- person_insurance
- person_lifestyle
- person_loyalty
- person_phone
- person_professional
- person_qualification
- person_customer
- person_segment
- person_socialhandle
- person_specialization
- person_status
- person_taxdetails
- person_xref
Supplier
The staging schema includes the following tables for the supplier domain:
- contact_email
- contact_identifier
- contact_phone
- contact_postal_address
- contact_root
- contact_socialmedia
- contact_status
- contact_xref
- supplier_address
- supplier_alert
- supplier_altname
- supplier_bankdetails
- supplier_contract
- supplier_diversity
- supplier_document
- supplier_email
- supplier_esg_environmental_reason
- supplier_esg_govern_reason
- supplier_esg_rating_sustain_analytics
- supplier_esg_ratingdnb
- supplier_esg_social_reason
- supplier_esg_sustainability_classification
- supplier_executive_member
- supplier_financial
- supplier_identifier
- supplier_insurance
- supplier_phone
- supplier_reference
- supplier_risk_question
- supplier_root
- supplier_segment
- supplier_social_media
- supplier_sourcing_manager
- supplier_stock
- supplier_tax
- supplier_xref
Product
The staging schema includes the following tables for the product domain:
- category_description
- category_keyword
- category_root
- classification
- item_description
- item_keyword
- item_metainfo
- item_highlight
- item_root
- item_sellprice
- item_tags
- item_xref
Product Relationship
The staging schema includes the following tables to store product relationships:
- relation_item_to_category
- relation_category_to_category
- relation_category_to_classification
Location
The staging schema includes the following tables for the location domain: