Snowflake Semantic Views

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.

← All connectors

Semantic layer
Note:
Repository-first · no deploys

View Dex on GitHub Read the docs

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.

What you get

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

In your repositoryDex

Agent-native analytics engineering on your Snowflake Semantic Views.

.dex/config.yml
semantic_views/commerce.yaml

How it works

Explore, transform, maintain: the Dex loop on Snowflake Semantic Views.

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
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
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
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
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