MDM Extension for Google BigQuery > MDM Extension for Google BigQuery assets > Data Definition Language (DDL) scripts
  

Data Definition Language (DDL) scripts

Use DDL scripts to create Google BigQuery staging schema, Google BigQuery analytical schema, and sample Views.
You can use the scripts to create the Google BigQuery staging schema for MDM SaaS customer, supplier, product, and location master data. You can also use the scripts to create enhanced analytical schema for Store, Customer, and Supplier analytics.
MDM Extension for Google BigQuery also includes sample Views. Views are logical tables defined using SQL queries. When you run the SQL query in Google Cloud Console, you can use the Views to visualize data in the Google BigQuery analytical schema.