MDM Extension for Google BigQuery > MDM SaaS and Google BigQuery integration > Data flow to publish master data to Google BigQuery
  

Data flow to publish master data to Google BigQuery

Use egress jobs and Cloud Data Integration assets to publish master data from MDM SaaS to Google BigQuery staging store. The extension then uses data transformation and taskflows to populate data into the Google BigQuery dimension and fact tables.
The following image shows the flow of data from MDM SaaS to Google BigQuery:
The extension uses an egress job and Cloud Data Integration taskflows to write data into Google BigQuery staging store. Cloud Data Integration taskflows transform and populate data into the Google BigQuery dimension tables.
When you run MDM SaaS egress jobs for the MDM SaaS domain, Cloud Data Integration assets export MDM SaaS master data, such as customer, product, location, and supplier master data, into Google BigQuery staging store.
When you run Cloud Data Integration taskflows, Cloud Data Integration transforms and publishes master data from the Google BigQuery staging store into Google BigQuery dimension and fact tables.
Based on your MDM SaaS domain, the master data is placed in the Google BigQuery dimension and fact tables.
You can use the sample Views to view analytical reports from the Google BigQuery analytical schema.