Skip to main content
Omni imports each Snowflake semantic view as a topic, with the semantic view’s field definitions, relationships, and AI instructions. You keep your semantic definitions in one place — Snowflake — and explore and visualize them in Omni. Changes to a semantic view in Snowflake reach Omni on the next schema refresh.

​
What you can do with Snowflake semantic views in Omni

Sync semantic views to Omni

Run a schema refresh to import semantic views as topics, and see what each part of a definition becomes in Omni.

Query a semantic view topic

Find the imported topics and explore them in workbooks.

Push Omni topics to Snowflake

Convert a topic you built in Omni into a Snowflake semantic view definition.

​
Requirements

To use this integration, you’ll need:
  • Semantic views created in your Snowflake account
  • Organization Admin or Connection Admin permissions on the Snowflake connection in Omni. This is required to modify the connection’s settings.
  • An existing Snowflake connection in Omni

​
Setup

Follow these steps to import the semantic views on a Snowflake connection as Omni topics.
1

Grant database permissions

  1. Confirm that the Omni user role has the permissions outlined in step 1 of the Snowflake setup guide. This must include read access to the schemas, tables, and views that back your semantic views.
  2. Grant the Omni user role read access to your semantic views. Semantic views are their own object type in Snowflake, so grants on tables and views don’t cover them:
    Snowflake semantic view user grants
2

Include the schema in your connection

In your Omni connection settings, make sure the schema containing your semantic views is included:
  1. Navigate to Settings > Connections and click your Snowflake connection.
  2. Verify that the schema is listed in the Include Other Databases or default database configuration.
3

Enable the semantic view setting

In your Omni connection settings, scroll to the bottom of the page and enable the Enable DW Semantic View Integration setting. This makes semantic views available in workbooks and the model IDE.
4

Update the connection and refresh the schema

  1. Click Update and Test Connection to save your connection settings and verify the connection.
  2. Run a schema refresh on the model associated with this connection.
After the schema refresh completes, your semantic views appear in the model as topics.

​
Limitations

Some parts of a semantic view definition don’t import, and some import in a fixed way. See Snowflake semantic view limitations before you rely on a topic.

​
Next steps