How to get more from your dbt models and metrics with ThoughtSpot

If you haven’t heard of dbt, you’re missing out on one of the hottest technologies in data. dbt has been adopted by more than 15,000 organizations looking for a SQL-friendly workflow to transform the data inside their cloud data platform.

With such an avid and growing community of analytics engineers using dbt to transform data within Snowflake, Databricks and other leading cloud data platforms, we knew there was an opportunity for ThoughtSpot to help a broader community derive insights with self-service analytics on dbt data models.

Last year, we launched a direct dbt integration through our updated Data Workspace, which leverages ThoughtSpot Modeling Language (TML) to convert dbt models to search-ready worksheets in ThoughtSpot.

And today, we are taking the next big step.

If you are at Coalesce, you just heard that dbt Labs is putting its Semantic Layer into public preview. I am pleased to share that ThoughtSpot is an official Semantic Layer Launch Partner. This newly developed integration makes it possible for solutions like ThoughtSpot to directly connect to and query metrics defined in dbt, where organizations can centrally define, govern, and version control their most critical business logic. 

Activate your dbt models

A model only has value if it is explored by the business. With ThoughtSpot, you can expose your dbt models to business users for analytics at scale with the power and ease of search.

ThoughtSpot is an official Semantic Layer Launch Partner of dbt, making it the analytics standard for integration with dbt’s semantic and metrics layer.

dbt is the de facto standard for data modeling in the modern data stack, and ThoughtSpot is the experience layer that delivers safe, reliable self-service Live Analytics to anyone across the business. We expect this integration will deliver a wealth of value to the thousands of organizations who already use dbt as well as the joint customers we work with every day.

Put data into the hands of business users

We know data practitioners feel an acute need for a “single source of truth” when it comes to tracking business metrics such as revenue, churn rate, and count of active customers. Because they are already modeling their data in dbt to ship it to teams around their organizations, dbt is an ideal solution for defining and building these metrics.

However, databases typically require users to have SQL skills if they want to access that data and develop insights. With ThoughtSpot, that access and insight generation is as simple as dropping a term into a search bar and pressing “Go.”

Curious how others are using metrics in dbt? Read how dbt Labs uses metrics to track internal OKRs. You can also test the ThoughtSpot and dbt integration today by signing up for a free 14-day trial of ThoughtSpot.