Add a Schema to a Database or Catalog

You can add schemas to the physical layer's databases or catalogs to mirror how the data source is organized.

You can't rearrange the catalog and schema groupings that you add. For example, if you added a schema and tables directly into a database, then you can't later create a catalog and move them to the catalog.

See Add a Catalog to a Database.

You can use a variable to dynamically populate the schema's name. See Use a Variable to Dynamically Name a Catalog or Schema.

1. On the Home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Physical Layer.
4. Click Create and then click Create Schema.
5. In Create Schema, locate the Name field and type a schema name.
6. In Location, click the menu and specify which database or catalog to add the schema to.
7. Click OK.