Create Mosaic Schema

Starting in Strategy (August 2026), creating a Mosaic schema is available out-of-the-box.

Starting in Strategy (July 2026), you can use a preview feature to create Mosaic schema in Mosaic Studio to use auto modeling to create Mosaic schema objects.

Use schemas as a logical and physical definition of warehouse data elements, physical characteristics, and relationships, derived from the logical data model. The Mosaic schema refers to an internal map that Strategy uses to keep track of attribute relationships, fact levels, table sizes, and so on within a project.

Preview features are early versions of features and are not to be used in a production environment as the core behavior remain subject to change between preview and GA. By selecting to expose preview features, you can access these features and use them as you would any other functionality. This preview is for experimentation and feedback.

Prerequisites

To create a Mosaic schema, you must have the Architect privilege.

Recommendations

If you are using Strategy (July 2026) or testing out creating a Mosaic schema, Strategy recommends:

Create a new project specifically for Mosaic schema testing.
Avoid using the feature on existing or production projects.
Use only test or non-critical data.

Create a Mosaic Schema

Open Strategy Library.
Choose Create New > Mosaic Model.
Choose a Project.
Click OK.
Choose an existing source from the Sources grid or click Add Database.

For more information on adding data from a database, see Import Data from a Database.

Databases are the only supported source for Mosaic schema and external models are not supported.
Expand the Query Mode drop-down list in the top-right of the window and choose Live.
Click Proceed.
Map your Mosaic model to the Mosaic schema.
Click Hierarchy in the top left and view your mapped objects.
Create and edit attributes, as needed.

You can not edit attributes or attribute forms that are mapped to the Mosaic schema.
Expand the drop-down list next to Save and choose Save To Mosaic Schema.
If your schema includes unmapped objects (for example, attributes, metrics, and advanced metrics), they will be converted to standalone objects in the Mosaic schema. Review the objects and click OK.

All security filters created in the model will be removed. You can create project-level security filters.

Relationships between attributes that are both mapped int he Mosaic model will be removed.
Expand the drop-down list next to Save and choose Save and Update Schema to confirm the final schema update process.

If you do not click Save and Update Schema, saved objects can not be consumed in the project.
After you click Save to Mosaic Schema and Save and Update Schema, you will lock the current schema at the project level. If the schema is already locked, you may receive an error. In that case, follow the steps below to unlock the schema:
1. In Workstation, click Schema in the Navigation pane.
2. Right-click your project and click Unlock Schema.

Save a Mosaic Model to Mosaic Schema

You can also convert an existing Mosaic model to a Mosaic schema.

After saving, the Mosaic model is converted to a Mosaic schema. This action can not be undone.

Edit an existing Mosaic model with the following requirements:
- The model must use Live query mode.
- The model must not have Mosaic model links.
- The model must not be referenced by other Mosaic models from Mosaic model links.
Expand the drop-down list next to Save and choose Save To Mosaic Schema.
If your schema includes unmapped objects (for example, attributes, metrics, and advanced metrics), they will be converted to standalone objects in the Mosaic schema. Review the objects and click OK.
Expand the drop-down list next to Save and choose Save and Update Schema to confirm the final schema update process.

If you do not click Save and Update Schema, saved objects can not be consumed in the project.

Merge Attributes in a Mosaic Schema

Edit a Mosaic schema and click Model in the top-left.
Click the Tables tab and click Merge Attributes in the top-right.
Expand the Mosaic Object drop-down list and choose an object in the current Mosaic schema.
Expand the Mosaic Schema drop-down list and choose the attribute you want to merge with.
Click Apply.
Expand the drop-down list next to Save and choose Save and Update Schema to confirm the final schema update process.

The mapped attribute merges to the existing attribute in the schema.
Click Hierarchy in the top left and toggle on Show related Mosaic schema hierarchy to view the Mosaic schema hierarchy for your newly merged attribute.

View Merge Attributes in Workstation

Open Workstation.
In the Navigation pane, click Objects and locate the attribute.
Right-click the attribute and choose Edit.
At the bottom of the attribute editor, click the Mosaic Models tab and view the merged attribute.