Quick Start: Schemas

Key Points: Schemas

  • Schemas can be set on staging databases and data warehouses as well as data sources and individual tables. You can use schemas to e.g. restrict access to tables that report designers do not need, thereby making reporting off of the data warehouse easier.
  • Table level settings take precedence over data source settings which in turn take precedence over data warehouse settings.


Key Steps: Schemas

Add a Database Schema to a Data Warehouse

  1. Open Database Schemas from a data warehouse and Add Database Schema
  2. Provide a name and create the schema
  3. Once created, you can adjust the Schema Behavior








Configure Schemas for Tables

  1. Open the Table Schemas tab under Table Settings.
  2. Adjust your table schemas as desired or add a new schema





For more detailed instructions, please see the following lesson and review Database Schemas.


Understanding Schemas

Database Schemas allow you to apply a certain schema to a table or a group of tables. You can use schemas to e.g. restrict access to tables that report designers do not need, thereby making reporting off of the data warehouse easier.

Schemas can be set on staging databases and data warehouses as well as data sources and individual tables. The schema settings are applied as follows: Table level settings take precedence over data source settings which in turn take precedence over business unit/data warehouse settings.

You have the following Schema Behavior options:

  • None: The schema will be applied to the tables you manually assign it to.
  • Main default schema: The schema will be applied to all tables and views in the region (data warehouse or staging).
  • Main Raw default schema: The schema will be applied to all Raw (_R postfix) tables in the region (data warehouse or staging).
  • Main Transfer default schema: The schema will be applied to all Transfer (_T postfix) views in the region (data warehouse or staging).
  • Main Valid default schema: The schema will be applied to all Valid (_V postfix) tables and views in the region (data warehouse or staging).
  • Main Error/Warning default schema: The schema will be applied to all Link and Message (_L and _M postfix) tables in the region (data warehouse or staging).


For more detailed information, please see Database Schemas.