dbt Labs Announces the Next Generation of the dbt Semantic Layer, Introduced Alongside New Integration with Tableau
SAN DIEGO, Oct. 17, 2023 /PRNewswire/ – dbt Labs, the pioneer in analytics engineering, has announced the next generation of the dbt Semantic Layer following its acquisition of Transform in February 2023. Unveiled during the keynote at dbt Labs’ Coalesce 2023, the dbt Semantic Layer enables organizations to centrally define business metrics in dbt Cloud and then query them from any integrated analytics tool. This allows organizations to ensure that critical definitions such as “revenue,” “customer count,” or “churn rate” are consistent in every data application.
dbt Labs is also shipping a new integration with Tableau for the dbt Semantic Layer, a game-changing step in the technology’s evolution. With this integration, the thousands of organizations that rely on Tableau’s analytics platform can benefit from business-critical metrics that are consistent, reliable, and reading from a single, verified source of truth. The Semantic Layer also integrates with Google Sheets, Hex, Klipfolio, Lightdash, Mode, and Push.ai with additional integrations planned for the coming months.
“This is an important moment for the dbt Semantic Layer,” said Tristan Handy, founder and CEO of dbt Labs. “First, our customers now have access to the fully integrated best-in-class technology that we acquired in the Transform acquisition. Second, our customers can use the dbt Semantic Layer with two of the most widely used data analysis tools, Tableau and Google Sheets, with additional integrations available right now and more integrations coming soon. With the Semantic Layer, data teams can have confidence that everyone in the business is working from the same, shared definitions.”
Delivering Consistent Metrics at Scale With the new version of the dbt Semantic Layer, it’s now easier than ever for organizations to define and access complex metrics highly efficiently, at scale. The following new features are now generally available as part of the revamped dbt Semantic Layer:
- Dynamic join support: Join any number of tables together to produce metrics on top of an existing database.
- Optimized query plans and SQL generation: Generates joins, filters and aggregations just as an analyst would, with legible and performant SQL.
- Complex metric types: Enables new aggregations and more flexible metric definitions, empowering users to define more metrics critical to measuring their business.
- Expanded data platform support: Supports BigQuery, Databricks, Redshift, and Snowflake, including performance optimizations for each.
“We are thrilled to bring support for the revamped dbt Semantic Layer to Databricks customers,” said Ken Wong, Senior Director of Product Management at Databricks. “Databricks customers have embraced our dbt Cloud adapter to enable analytics engineering at scale. With the support of the new Semantic Layer, they’ll be able to deliver more reliable analytics in the hands of more users while fully leveraging the unified lakehouse architecture.”
Enhanced Integrations To further build on the momentum of newly announced Semantic Layer integrations, dbt Labs has also formally introduced its Semantic Layer Ready Integration Program. The new Semantic Layer Ready designation highlights trusted third party integrations that bring the power of consistent self-serve metric experiences, backed by the dbt Semantic Layer, to new audiences of data consumers. In addition to Tableau, inaugural members include Hex, Klipfolio, Lightdash, Mode, and Push.ai. Additional integrations will be added in future releases.
“We believe that the dbt Semantic Layer will help power the next generation of data analytics, and are happy that our customers will now be able to easily experience the benefits of reliable, consistent metrics – backed by dbt – across the organization,” said Nicolas Brisoux, Senior Director of Product Management at Tableau. “Too often we hear from customers that a major barrier to wider adoption is a lack of trust in data. This is one more step in our mission to solve this.”
The dbt Semantic Layer is now generally available for all users of dbt Cloud. To learn more about the re-launch and these key new integrations, see here.
About dbt Labs Since 2016, dbt Labs has been on a mission to help analysts create and disseminate organizational knowledge. dbt Labs pioneered the practice of analytics engineering, built the primary tool in the analytics engineering toolbox, and has been fortunate enough to see a fantastic community coalesce to help push the boundaries of the analytics engineering workflow. Today there are 30,000 companies using dbt every week, 90,000 dbt Community members, and 3,600 dbt Cloud customers.
Last modified on: Nov 22, 2023