Skip to content
SPECIFICTION
Get listed

dbt Semantic Layer

getdbt.com

From $0.09/mo Free plan WebAPIBrowser extension
Visit getdbt.com
Spec score 9.2 #2 of 28 in Semantic Layer Software

What it is

The dbt Semantic Layer centralizes metric definitions on dbt models and handles joins so downstream tools and applications can use metrics consistently. MetricFlow generates SQL at query time from semantic model and metric configurations. Teams define those models and metrics in YAML as version-controlled, lineage-aware code. MetricFlow can optimize joins, rewrite queries to reduce compute and latency, and cache repeated queries. The product offers an API, the dbt MCP Server and integrations for BI tools, notebooks, spreadsheets, embedded analytics and AI systems. GraphQL and JDBC APIs and a Python SDK provide ways to query metrics and dimensions; Claude and ChatGPT can connect to governed metrics through the MCP server. Documented warehouse platforms include Snowflake, BigQuery, Databricks and Redshift. Defining and querying metrics requires a dbt Starter or Enterprise-tier account, and single-tenant accounts need account-representative setup and enablement. Starter includes 5,000 queried metrics per month; Enterprise and Enterprise+ each include 20,000. Starter costs $100 a month per user. The free Developer plan does not list the Semantic Layer.

Spec sheet

What it does
The Semantic Layer centralizes metric definitions in dbt and generates queries with joins for downstream tools.Read 15 Oct 2026 · docs.getdbt.com
Purpose
The Semantic Layer centralizes metric definitions on dbt models and automatically handles data joins for consistent use across downstream tools and applications.Read 3 Oct 2026 · docs.getdbt.com
Intended users
The product is presented for data teams seeking governed, consistent metrics for analytics, embedded applications, and AI use cases.Read 3 Oct 2026 · getdbt.com
Integrations
The product page says the Semantic Layer offers an API, the dbt MCP Server, and dozens of out-of-the-box integrations for BI, notebooks, spreadsheets, embedded analytics, and AI systems.Read 3 Oct 2026 · getdbt.com
Support
The pricing page lists 24x5 support for Starter and priority support with SLAs for Enterprise.Read 3 Oct 2026 · getdbt.com
Headquarters
Oakland, California, United StatesRead 28 Sep 2026 · getdbt.com
Founded
2016Read 28 Sep 2026 · getdbt.com
Access controls
The Semantic Layer applies access permissions and respects policies attached to the underlying warehouse credentials.Read 15 Oct 2026 · docs.getdbt.com
Access requirement
Defining and querying Semantic Layer metrics requires a dbt Starter or Enterprise-tier account; single-tenant accounts need setup and enablement from their account representative.Read 3 Oct 2026 · docs.getdbt.com
AI access
AI tools including Claude and ChatGPT can connect to governed metrics through the dbt MCP server.Read 3 Oct 2026 · docs.getdbt.com
AI connectivity
Claude and ChatGPT can access governed metrics through the dbt MCP Server.Read 15 Oct 2026 · docs.getdbt.com
APIs
The Semantic Layer provides GraphQL and JDBC APIs and a Python SDK for querying metrics and dimensions.Read 3 Oct 2026 · docs.getdbt.com
Authentication
API access uses personal or service-account tokens, with service tokens linked to warehouse credentials.Read 15 Oct 2026 · docs.getdbt.com
Caching
MetricFlow can rewrite queries and use caching to reduce latency, compute, and repeated warehouse work.Read 15 Oct 2026 · getdbt.com
Company founding and headquarters
LinkedIn lists dbt Labs as founded in 2016 and headquartered in Philadelphia, Pennsylvania.Read 15 Oct 2026 · linkedin.com
Company size
LinkedIn lists dbt Labs as privately held with 501–1,000 employees.Read 15 Oct 2026 · linkedin.com
Deployment requirement
Production metric deployment currently works through a deployment environment, while development-environment support is marked as coming later.Read 15 Oct 2026 · docs.getdbt.com
Documentation depth
Documentation covers semantic models, entities, dimensions, metrics, CLI commands, manifests, deployment, credentials, tokens, and integrations.Read 15 Oct 2026 · docs.getdbt.com
Downstream destinations
dbt lists integrations including Google Sheets, Hex, Mode, Preset, Sigma, Tableau, ThoughtSpot, Census, Hightouch, and Lightdash.Read 15 Oct 2026 · getdbt.com
Governed definitions
Metrics are version-controlled and lineage-aware because teams define them as YAML in dbt projects.Read 15 Oct 2026 · getdbt.com
GraphQL API
The Semantic Layer exposes GraphQL for querying metrics and dimensions.Read 15 Oct 2026 · docs.getdbt.com
JDBC API
A JDBC driver supports metric and dimension queries plus standard metadata operations.Read 15 Oct 2026 · docs.getdbt.com
Licence
The dbt Semantic Layer service and APIs are proprietary cloud software; MetricFlow and dbt-semantic-interfaces are Apache 2.0 licensed.Read 15 Oct 2026 · docs.getdbt.com
Limit: connectors
A reviewer says the relatively new product needs more connector development.Read 15 Oct 2026 · capterra.com.au
Limit: error handling and alerts
A reviewer requests easier error handling, more scheduling options, and more customizable alerts.Read 15 Oct 2026 · capterra.com.au
Limit: pricing uncertainty
A reviewer worries that costs could rise substantially as usage grows.Read 15 Oct 2026 · capterra.com.au
Limit: upstream ETL
A reviewer says dbt assumes information is already in the database, requiring separate ETL work for other sources.Read 15 Oct 2026 · capterra.com.au
Local components
MetricFlow and dbt semantic interfaces are available locally under Apache 2.0, but the service layer and Semantic Layer APIs are proprietary cloud components.Read 15 Oct 2026 · docs.getdbt.com
Merger criticism
Analysts quoted by TechTarget warned that preserving dbt’s open-source community trust and avoiding complex consumption pricing would be difficult after the merger.Read 15 Oct 2026 · techtarget.com
Metric engine
MetricFlow powers the Semantic Layer and generates SQL queries from semantic model and metric configurations at query time.Read 3 Oct 2026 · getdbt.com
MetricFlow engine
MetricFlow converts YAML semantic models and metrics into SQL at query time and optimizes joins and execution.Read 15 Oct 2026 · getdbt.com
Metrics as code
Teams define semantic models and metrics in YAML as version-controlled, lineage-aware code.Read 3 Oct 2026 · getdbt.com
Notable news: merger
TechTarget reported that Fivetran and dbt Labs completed an all-stock merger on June 1, 2026; George Fraser became CEO and Tristan Handy president.Read 15 Oct 2026 · techtarget.com
Praise: usability
Capterra reviewers repeatedly praise the easy interface, quick setup, SQL-based workflow, and user-friendly data modeling.Read 15 Oct 2026 · capterra.com.au
Praise: warehouse connectivity
Capterra reviewers praise connecting to multiple data warehouses and managing projects collaboratively.Read 15 Oct 2026 · capterra.com.au
Praise: workflow automation
Reviewers highlight job scheduling, cloud IDE capabilities, organized models, testing, and reduced reliance on data engineering.Read 15 Oct 2026 · capterra.com.au
Python SDK
A Python SDK is provided for programmatic interaction with the Semantic Layer.Read 15 Oct 2026 · docs.getdbt.com
Query performance
MetricFlow rewrites queries to reduce compute and latency, optimizes joins, and uses caching to reduce repeated queries.Read 3 Oct 2026 · getdbt.com
Rating on Capterra
4.8 out of 5 from 4 reviews.Read 15 Oct 2026 · capterra.com.au
Rating on SourceForge
5.0 out of 5 from 4 reviews.Read 15 Oct 2026 · sourceforge.net
Security and compliance
The dbt Labs Trust Center lists SOC 2 Type II, ISO 27001:2022, ISO 27017, ISO 27018, ISO 42001, GDPR, and CCPA badges.Read 3 Oct 2026 · trust.getdbt.com
Security certifications
dbt Labs reports ISO 42001, ISO 27001, ISO 27701, ISO 27017, ISO 27018, and SOC 2 Type II coverage.Read 15 Oct 2026 · getdbt.com
Supported warehouses
The quickstart lists Snowflake, BigQuery, Databricks, Redshift, Postgres, and Trino as supported data platforms.Read 15 Oct 2026 · docs.getdbt.com
Unsupported platform
The quickstart says Microsoft Fabric is not supported by the Semantic Layer.Read 15 Oct 2026 · docs.getdbt.com
Usage limits
Starter includes 5,000 queried metrics per month, while Enterprise and Enterprise+ each include 20,000 queried metrics per month.Read 3 Oct 2026 · getdbt.com
Warehouse support
The Semantic Layer documentation identifies Snowflake, BigQuery, Databricks, and Redshift as supported data platforms.Read 3 Oct 2026 · getdbt.com

Plans and prices

Developer Free 1 developer seat · 3,000 successful models/month · 1 project Read 15 Oct 2026 · getdbt.com
dbt State add-on $0.09 a month pay-as-you-go per DATT 30-day free trial · Daily Active Target Tables billing Read 15 Oct 2026 · getdbt.com
Starter $100 a month per user/month 5 developer seats · 15,000 successful models/month · 5,000 queried metrics/month · 1 project · Semantic Layer and API access Read 15 Oct 2026 · getdbt.com
Enterprise Priced on request Custom seats · 100,000 successful models/month · 20,000 queried metrics/month · 30 projects · caching · SSO/RBAC/SCIM Read 15 Oct 2026 · getdbt.com
Enterprise+ Priced on request Custom seats · 100,000 successful models/month · 20,000 queried metrics/month · unlimited projects · PrivateLink · IP restrictions · hybrid projects Read 15 Oct 2026 · getdbt.com

Every dbt Semantic Layer plan and price →

Strong points and limits

Strong points

  • Metric definitions are version-controlled YAML with lineage awareness.
  • MetricFlow can optimize joins and cache repeated queries.
  • GraphQL, JDBC and Python SDK support metric queries.
  • Integrations cover BI, notebooks, spreadsheets, embedded analytics and AI.

Limits

  • The free Developer plan does not list the Semantic Layer.
  • Metric definition and querying require a Starter or Enterprise account.
  • Starter includes 5,000 queried metrics per month.
  • Single-tenant accounts require setup and enablement.

Who it suits

The Semantic Layer suits data teams that need governed metrics for analytics, embedded applications or AI use cases. It requires a Starter or Enterprise-tier dbt account to define and query metrics.

dbt Semantic Layer in depth

Read the full write-up

dbt Semantic Layer gives data teams one place to define metrics on dbt models and serve them through APIs and integrations. It is most compelling for teams building analytics, embedded applications or AI features around shared, governed measures. The trade-off is that access starts with a paid dbt tier, and Starter has a monthly metric-query cap.

Overview

The product puts metric definitions and join handling behind a common layer, so downstream consumers can use consistent measures rather than reimplementing them in each tool. That is a practical fit when several teams or applications rely on the same definitions; it is less attractive if you want a semantic layer independent of dbt accounts and workflows.

Key features

Teams define semantic models and metrics in YAML as version-controlled, lineage-aware code. MetricFlow turns those configurations into SQL at query time and handles joins. This makes metric logic easier to govern centrally, while requiring teams to maintain the definitions as code.

MetricFlow rewrites queries to reduce compute and latency, optimizes joins and caches repeated queries. These are sensible measures for avoiding unnecessary work, though the benefit will depend on each workload. GraphQL and JDBC APIs, plus a Python SDK, let clients query metrics and dimensions. The API, dbt MCP Server and out-of-the-box integrations serve BI, notebooks, spreadsheets, embedded analytics and AI systems; Claude and ChatGPT can connect to governed metrics through MCP.

Snowflake, BigQuery, Databricks and Redshift are supported data platforms. The cloud product is accessible through API and web platforms. dbt Labs lists SOC 2 Type II, ISO 27001:2022, ISO 27017, ISO 27018, ISO 42001, GDPR and CCPA credentials. Starter includes 24x5 support; Enterprise has priority support with SLAs.

Pricing

The Developer plan is free. It allows 1 developer seat, 3,000 successful models per month and 1 project, but does not include Semantic Layer access. It is useful for development, not for teams seeking this product’s metric features.

Starter costs $100 a month, billed per user/month. It includes 5 developer seats, 15,000 successful models per month, 5,000 queried metrics per month and 1 project, along with Semantic Layer access. The per-user charge and relatively small metric allowance make it best suited to a small deployment with predictable demand. Free plan and free trial options are offered, but the free plan does not include the layer.

Enterprise and Enterprise+ use custom pricing and each include 100,000 successful models and 20,000 queried metrics per month, with custom developer seat counts. Enterprise includes 30 projects; Enterprise+ includes unlimited projects. These tiers fit organizations needing more project capacity or higher allowances than Starter, though their custom pricing requires a quote.

Defining and querying metrics requires Starter or Enterprise-tier access. Single-tenant accounts also need setup and enablement from an account representative, an important consideration for organizations with that deployment arrangement.

Platforms

dbt Semantic Layer is cloud-deployed and supports API and web access. Its documented warehouse support covers Snowflake, BigQuery, Databricks and Redshift.

Who it's for

Choose it when a data team needs governed metrics reused across analytics, embedded products and AI, and is prepared to work within dbt’s account tiers and project structure. Teams wanting a free Semantic Layer tier, or a tool that does not require a dbt Starter or Enterprise account, should look elsewhere.

Pros and cons

Pro: YAML definitions are version-controlled and lineage-aware, supporting shared ownership of metric logic.

Pro: Join handling, APIs and integrations let multiple kinds of consumers use common metrics.

Pro: MetricFlow’s query rewrites, join optimization and caching target lower compute and latency.

Con: The free Developer plan excludes Semantic Layer access, so even a small team must pay for Starter.

Con: Starter is limited to 5,000 queried metrics per month and one project; teams exceeding those limits need a higher tier.

Con: Enterprise pricing is custom, making costs less straightforward to assess against a fixed per-user plan.

Alternatives

For a broader comparison, browse Semantic Layer Software, Database Documentation Tools and Data Transformation Tools.

Starburst Enterprise Context Layer is worth comparing if its free plan, which supports up to 3 clusters for ad hoc queries, better matches your starting needs. Kyvos is another option, with a paid plan billed at $0.41 per core hour on its cloud marketplace. For a free forever sandbox, Sema offers 1 connector, 1 user and 100 chat queries per month, with limits on saved reports and delivery features.

Cube may suit teams wanting a free forever starting tier with up to 5 workbooks and 1,000 daily requests. Kyligence is a paid alternative with a free trial. Looker may appeal to organizations seeking a paid product with a Standard plan that includes one production instance, 10 Standard Users and 2 Developer Users.

Rill Metrics SQL is a paid alternative with a $20 / seat / month Starter plan for up to 20 seats and 3 projects, though embedded analytics are previews only and compute is billed separately. Malloy is a free option for readers comparing products across API, extension, desktop and web platforms.

Verdict

dbt Semantic Layer is a strong choice for dbt-based data teams that need governed metric definitions reused across tools, applications and AI. Its central advantage is combining shared metric logic with query and join handling; the main reason to look elsewhere is the paid access requirement and Starter’s monthly query and project limits.

Verdict

The dbt Semantic Layer puts metric definitions and join handling behind a set of APIs and integrations. Access depends on a Starter or Enterprise account, and Starter costs $100 a month per user.

Where Specifiction places it

Alternatives to dbt Semantic LayerAll alternatives →