powered by DBT semantic layer

Governed, explorable metrics

Mode’s integration with dbt's Semantic Layer is now available for qualified customers! Your most important company metrics, automatically available for teams throughout your business for confident data exploration and self-serve reporting.

Enter your e-mail for your instructions on how to get set up in dbt, connect to Mode and start your code-free analysis.

Learn how to get started

See it in action

Creating and maintaining accurate metric definitions is challenging because our business logic lives in so many places, from queries to one-off docs. Now, we can define those metrics in one place, in the dbt Semantic Layer, and have that data easily and consistently accessible to our business teams in Mode.

Trish Pham

How it works

Our architectural approach to the integration leverages the dbt Proxy server and Helix, our own in-memory data engine in situationally-dependent ways. For changes that require getting new data or re-running a metric, Mode relies only on the logic built in dbt, using Helix simply as a proxy. This means we don’t perform any additional manipulation of the data within Mode, preventing common mistakes like aggregating aggregates, or summing distinct values.

For changes that don’t require new data, such as changing a chart from a bar to a line, we do rely on Helix. This prevents unnecessary hits to the data warehouse, and provides access to Mode’s powerful visualization system.

The result? The guardrails of dbt and the power of Mode’s visualizations for trusted analysis for everyone, every time.

Mode means the right answer, every time

Explore using only the configurations in dbt.

Trust an architectural approach that prevents aggregating aggregates & other common mistakes.

Avoid multiple round trips to the database when possible.

Extend analysis using the same trusted metrics in SQL.

Hit the ground running

Step 1

Collaborate with your business teams to understand their most critical metrics. Check out advice and get our template on best practices for collaboration.

Step 2

Define them in dbt. Get started here, or join the Slack community to get your questions answered.

Step 3

Once you’ve got a metric or set of metrics defined, use our Getting Started Guide to connect Mode to dbt and Snowflake.

Step 4

Immediately browse metrics, conduct visual analysis and build reports using data that’s accurate, 100% of the time.

Resources

Particle pattern

Data teams move faster in Mode