Now live: Mode integration with dbt Semantic Layer

With the relaunch of dbt’s Semantic Layer, we’re excited to announce a new way to connect dbt and Mode. The new connector to the dbt Semantic Layer enables data teams to easily build reusable Datasets, leveraging metrics and pre-defined business logic in dbt, and then share those Datasets with business users for code-free visual exploration and analysis. 

While Mode provides data teams ways to define key metrics for their organization in the form of definitions and calculated fields, it can sometimes be difficult to make that business logic easily available for less technical users to interact with the data. Data teams need to define metrics and business logic in one place and have that information flow to business teams in a more consumable format — the integration between Mode’s reusable Datasets and the dbt Semantic Layer makes this workflow a reality. 

Bring more value to your team with dbt and Mode

Mode’s integration with the dbt Semantic Layer gives data teams another tool in their analytics toolbox to quickly provide important data to end users for analysis. This integration: 

1. Reduces the burden on data teams by allowing them to standardize common business logic in the semantic layer rather than having to redefine business logic for every dashboard.

2. Instills trust in your data by ensuring that metrics and business logic are governed in dbt and accessible to end users in Mode. 

How the integration  works

Mode’s connector to the dbt Semantic Layer is available today. The new connector supports Snowflake, Redshift, BigQuery and Databricks. 

To get started, set up a new data source connection to the dbt Semantic Layer. 

Create a new Dataset, select the connection in the Dataset schema browser and run a query to return data for a particular metric. 

Once the Dataset is ready to be shared, add a schedule so it pulls in the freshest data on a cadence and publish it to a Collection. This makes Datasets discoverable for end users to do their own visual exploration, powered by the dbt Semantic Layer.

For more information on how to get started with the dbt Semantic Layer, check out the help documentation.