All products

Convert an Omni topic to a Snowflake view with AI

Map an Omni topic's source tables, joins and metrics into a Snowflake semantic view definition. Review fields that need a fixed assumption before creating it.

Convert an Omni topic to a Snowflake view with AI when a team needs the same business definition in both places. A distinct order count can go wrong if one join adds an extra row per item. The model's relationships matter just as much as the name given to the metric.

The omni-to-snowflake-semantic-view skill reads the selected topic and its views, then maps what the destination can represent. It identifies physical tables, dimensions, measures and relationships. A calculation that depends on a value chosen at runtime may need an agreed static expression before it can move.

What it does

  • Map physical source tables to the target definition
  • Trace nested joins back to their parents
  • Carry over the aggregation behind a metric
  • Identify filter parameters without a direct equivalent
  • Review generated SQL before creating a semantic view

Install and use

  1. Install the skill and use an authorised Omni CLI profile. Executing the definition requires a configured Snowflake connection and privileges for the chosen database and schema.
  2. Ask, “Prepare a semantic view for the orders topic. Show me the joins and unresolved date filters. Return the definition for review before creating anything.”
  3. Check the mapping with whoever owns the metric. Test representative values in an appropriate environment before granting others access.

FAQ

Source

Made by Omni Analytics, Inc. Original skill: omni-to-snowflake-semantic-view, published on GitHub under the Apache-2.0 licence.

View on GitHub