Skip to content
Exmergo logoExmergo
All connectors
Snowflake Semantic Views logo

Semantic Layer

Snowflake Semantic Views

Available

Snowflake Semantic Views, kept as YAML files in your repository. dex reads them with no Snowflake connection, authors them as reviewable diffs, and holds them to the warehouse when columns move. Nothing is deployed for you.

View Dex on GitHubBook a Demo

Why connect Snowflake Semantic Views?

Snowflake Semantic Views define your tables, metrics, and relationships inside Snowflake. Dex works on the YAML files you deploy them from: it reads them with no Snowflake connection, authors them as reviewable diffs, and tells you when they fall out of sync with the warehouse.

  • 1Keep Semantic View definitions in your repository, reviewed like code, instead of edited by hand in the console
  • 2Derive a logical table from a declared dbt mart, with its grain as the primary key and a metric per declared aggregation
  • 3Measure the primary keys and relationship arities Snowflake trusts without checking
  • 4Nothing deployed for you: Dex opens no Snowflake connection to author and runs no CREATE SEMANTIC VIEW

Works with Dex

Snowflake Semantic Views connects to the Exmergo products your team already uses.

DexP-1
Exmergo DexExmergoDex
snowflake_semantic_views/

+ .dex/config.yml

+ semantic_views/commerce.yaml

Agent-native analytics engineering on your Snowflake Semantic Views.

Learn about Exmergo Dex

How it works

Connecting Snowflake Semantic Views to

Exmergo DexExmergo DexRepository-first · no deploys
  1. 1

    Point Dex at your Semantic View files

    Install Dex in Claude Code by running /plugin marketplace add exmergo/exmergo-agent-plugins and /plugin install dex@exmergo, then add the extra with pip install 'exmergo-dex-core[semantic-views]'. Set semantic.vendor: snowflake in .dex/config.yml and list your Semantic View YAML files under semantic.snowflake.files.

    Snowflake Semantic Views

    $ /plugin marketplace add exmergo/exmergo-agent-plugins

    $ /plugin install dex@exmergo

    $ pip install 'exmergo-dex-core[semantic-views]'

  2. 2

    Read the catalog before you touch anything

    /dex:explore reads the logical tables, dimensions, facts, metrics, and relationships your files declare, with no Snowflake connection. Every primary key, unique key, and relationship becomes evidence Dex uses when it profiles tables and verifies joins.

    Snowflake Semantic Views

    $ /dex:explore

  3. 3

    Author views as reviewable diffs

    /dex:transform writes and updates your files through semantic snowflake define, and transform apply commits them byte-for-byte. A declared dbt mart derives its logical table: the grain as its primary key, a metric per declared aggregation, and a relationship to each parent.

    Snowflake Semantic Views

    $ /dex:transform

    $ semantic snowflake define

    $ transform apply

  4. 4

    Nothing is deployed for you

    Every file is validated against Dex's port of Snowflake's specification, qualified against a live account. Dex runs no CREATE SEMANTIC VIEW and no grant: you review the YAML and deploy it the way you already do.

  5. 5

    Catch drift automatically

    /dex:maintain holds your Semantic Views to the warehouse: a member reading a column its table lost, a base table that is gone, a sum over text. Snowflake trusts a declared key without checking it, so Dex measures it.

    Snowflake Semantic Views

    $ /dex:maintain