Skip to main content

Model generation

Models are automatically generated after a database connection is added. Each model is divided into two layers:

  • The schema model that stays in sync with raw database tables and views, and
  • The model extension, where user-defined, virtualized data models live in Omni. Think fields, joins, and additional metadata such as formats, descriptions, and so on.

These layers make up the model you see in the model IDE in Combined mode.

Schema Model​

The schema model is intended to serve as a baseline version of the database schema, for simple point and click query, and some inferred key relationships. The schema model is not viewable or editable for users. To refresh the schema, click Model > Refresh schema inside the given schema model:

Note: When deleting or ignoring schema fields, they will still be editable in SQL queries by users who have permissions to use SQL.

Model extension​

The model extension is the core user-curated data model in Omni. Fields, joins, and other metadata extend / supplement the schema model.

In addition to entirely new fields and relationships, schema fields can be extended with new metadata - formatting, labels, or deleted by "ignoring" them. Refer to the next section for more information.

Combined mode​

By default, the IDE displays the model in Combined mode. In this mode, the layers of the model are combined to create a comprehensive view. Changing the mode to Model will display only the model extension.

Changes made while in Combined mode will be included in the model extension - that is, visible when you toggle the mode to Model.

To delete a field from the schema model, delete it while in Combined mode. When you toggle into Model mode, the field will be marked as ignored.

Conversely, in Model mode, you can delete an "ignored" field to resurface it from the schema model.