Available integrations

There are a number of data applications that seamlessly integrate with the dbt Semantic Layer, powered by MetricFlow, from business intelligence tools to notebooks, spreadsheets, data catalogs, and more. These integrations allow you to query and unlock valuable insights from your data ecosystem.

Use the dbt Semantic Layer APIs to simplify metric queries, optimize your development workflow, and reduce coding. This approach also ensures data governance and consistency for data consumers.

The following tools integrate with the dbt Semantic Layer:

Tableau

Learn how to connect to Tableau for querying metrics and collaborating with your team.

Google Sheets

Discover how to connect to Google Sheets for querying metrics and collaborating with your team.

Microsoft Excel

Connect to Microsoft Excel to query metrics and collaborate with your team. Available for Excel Desktop or Excel Online.

Hex

Check out how to connect, analyze metrics, collaborate, and discover more data possibilities.

Klipfolio PowerMetrics

Learn how to connect to a streamlined metrics catalog and deliver metric-centric analytics to business users.

Lightdash

Check out how to connect, query, and consume reliable dbt metrics in real time

Mode

Discover how to connect, access, and get trustworthy metrics and insights.

Push.ai

Explore how to connect and use metrics to power reports and insights that drive change.

Steep

Connect Steep to the dbt Semantic Layer for centralized, scalable analytics.

Before you connect to these tools, you'll need to first set up the dbt Semantic Layer and generate a service token to create Semantic Layer Only and Metadata Only permissions.

Custom integration

• Exports enable custom integration with additional tools that don't natively connect with the dbt Semantic Layer, such as PowerBI.
• Consume metrics and develop custom integrations using different languages and tools, supported through JDBC, ADBC, and GraphQL APIs, and Python SDK library. For more info, check out our examples on GitHub.
• Connect to any tool that supports SQL queries. These tools must meet one of the two criteria:
  • Offers a generic JDBC driver option (such as DataGrip) or
  • Is compatible Arrow Flight SQL JDBC driver version 12.0.0 or higher.

Related docs

• dbt Semantic Layer APIs to learn how to integrate and query your metrics in downstream tools.
• dbt Semantic Layer cookbook recipes
• dbt Semantic Layer API query syntax
• Hex dbt Semantic Layer cells to set up SQL cells in Hex.
• Resolve 'Failed APN' error when connecting to the dbt Semantic Layer.
• dbt Semantic Layer on-demand course
• dbt Semantic Layer FAQs