Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

dbt Semantic Layer

getdbt.com

  • Free plan
  • Web
  • Browser extension
  • API
7.8 Club score Visit getdbt.com

What dbt Semantic Layer 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 from semantic model and metric configurations when a query runs. Teams define models and metrics in YAML as version-controlled, lineage-aware code. MetricFlow can rewrite queries to reduce compute and latency, optimize joins and cache repeated queries. The product offers an API, the dbt MCP Server and integrations for BI, notebooks, spreadsheets, embedded analytics and AI systems. GraphQL and JDBC APIs, along with a Python SDK, let users query metrics and dimensions; AI tools including Claude and ChatGPT can connect to governed metrics through the MCP server. Supported data platforms are Snowflake, BigQuery, Databricks and Redshift. Defining and querying metrics requires a dbt Starter or Enterprise-tier account, and single-tenant accounts need setup and enablement from an account representative. Starter includes 5,000 queried metrics per month at $100 per user/month. Enterprise and Enterprise+ each include 20,000 queried metrics per month; their prices are custom. The free Developer plan does not list the Semantic Layer.

Who it suits

The Semantic Layer is presented for data teams seeking governed metrics for analytics, embedded applications and AI use cases. Teams need a Starter or Enterprise-tier dbt account to define and query metrics.

Good to know, and what to watch

  • Centralizes metrics on dbt models for downstream use.
  • Defines metrics in version-controlled YAML.
  • Offers GraphQL and JDBC APIs and a Python SDK.
  • Supports Snowflake, BigQuery, Databricks and Redshift.
  • Starter includes 5,000 queried metrics per month.
  • The free Developer plan does not include the Semantic Layer.
  • Metric definition and queries require Starter or Enterprise.
  • Single-tenant accounts need representative setup and enablement.
  • Starter includes 5,000 queried metrics per month.

Enterprise

—

Enterprise+

—

Developer

Free

dbt State add-on

$0.09/mo

Free plan

Getting started

  1. Visit the dbt Semantic Layer product page.
  2. Select a dbt Starter or Enterprise-tier account.
  3. For a single-tenant account, arrange setup and enablement through your account representative.
  4. Define semantic models and metrics in YAML.
  5. Query metrics through the APIs, Python SDK, MCP Server, or listed integrations.

Limits to check

Starter includes 5,000 queried metrics per month. Enterprise and Enterprise+ each include 20,000; the free Developer plan does not include the Semantic Layer.

The Club's review

Overview

dbt Semantic Layer is a cloud service for defining shared metrics on dbt models and querying them across data tools. It is a strong fit for data teams that already use dbt and want governed definitions to serve analytics, applications, or AI. The main trade-off is that access requires a qualifying dbt account, with monthly query limits to plan around.

Key features

Teams define semantic models and metrics in YAML as version-controlled, lineage-aware code. MetricFlow translates those configurations into SQL when a query runs and handles joins, so downstream users can work from common metric definitions rather than recreate logic across tools. That consistency matters most when several teams or products rely on the same measures; it is less compelling for organizations that do not want their metrics workflow tied to dbt.

MetricFlow also rewrites queries to target lower compute and latency, optimizes joins, and caches repeated queries. These are useful workload optimizations, though their impact will depend on how a team queries its warehouse. GraphQL and JDBC APIs and a Python SDK provide ways to query metrics and dimensions. An API, the dbt MCP Server, and dozens of integrations connect the layer to BI, notebooks, spreadsheets, embedded analytics, and AI systems. Claude and ChatGPT can access governed metrics through MCP, a practical option for teams extending existing metric controls to AI tools.

Supported warehouses include Snowflake, BigQuery, Databricks, and Redshift. The service is cloud-deployed, with API and web platforms. The dbt Labs Trust Center lists SOC 2 Type II, ISO 27001:2022, ISO 27017, ISO 27018, ISO 42001, GDPR, and CCPA credentials and badges.

Pricing

The Developer plan is free and includes 1 developer seat, 3,000 successful models per month, and 1 project, but it does not include Semantic Layer. That makes it useful for a small dbt project, not for teams evaluating the metric service itself. A free trial is available.

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, 1 project, and dbt Semantic Layer. The five-seat allowance and modest project count suit a smaller team with a contained workload, but query consumption needs monitoring. Starter includes 24x5 support.

Enterprise and Enterprise+ have custom pricing and include custom developer seat counts, 100,000 successful models per month, and 20,000 queried metrics per month. Enterprise supports 30 projects; Enterprise+ supports unlimited projects. Both raise the metric allowance substantially over Starter, while Enterprise+ is the fit for teams that need more project capacity. Enterprise includes priority support with SLAs.

Defining and querying Semantic Layer metrics requires a dbt Starter or Enterprise-tier account. Single-tenant accounts also need setup and enablement from their account representative, so teams should confirm eligibility and onboarding before depending on the service.

Platforms

dbt Semantic Layer runs in the cloud and is available through API and web. Its documented warehouse support covers Snowflake, BigQuery, Databricks, and Redshift.

Who it's for

Choose it if your data team uses dbt and needs governed metrics shared across BI, notebooks, spreadsheets, embedded applications, or AI. Its version-controlled definitions, lineage, and query APIs make a coherent foundation for multiple consumers. It is a weaker fit for teams seeking a standalone semantic layer without a dbt account, or for projects where the included monthly metric allowance is too restrictive.

Pros and cons

Pros

  • YAML-based, version-controlled metrics with lineage help teams maintain shared definitions.
  • MetricFlow handles SQL generation and joins, reducing the need for each downstream tool to reproduce metric logic.
  • GraphQL, JDBC, Python, integrations, and MCP access serve a broad mix of analytics and AI consumers.
  • Starter and higher tiers have explicit monthly queried-metric allowances, and Enterprise plans expand model and project capacity.

Cons

  • The free Developer plan excludes Semantic Layer, so using the core product starts at $100 a month per user on Starter.
  • Starter is limited to 5,000 queried metrics per month and one project, which can constrain wider rollouts.
  • Single-tenant customers need account-representative setup and enablement before use.
  • Enterprise and Enterprise+ require custom pricing, making their costs harder to compare upfront.

Alternatives

Semantic Layer Software and Data Transformation Tools collections are useful starting points for comparing broader categories; Database Documentation Tools covers a neighboring need.

Sema is worth considering for a freemium alternative with a free Sandbox capped at one connector, one user, 100 chat queries per month, and five saved reports; it has no scheduled delivery, alerts, or signals in that plan.

Starburst Enterprise Context Layer offers a free tier for up to three clusters with standard ad hoc execution, so it may suit teams looking for a no-cost cluster-based starting point.

Synmetrix is an open-source, self-hosted option if avoiding paid plans or usage limits is the priority.

Cube has a free tier capped at five workbooks, 1,000 daily requests, and one day of query history, making it a candidate for a limited initial workload.

Kyligence is a paid alternative with a free trial.

Kyvos is a paid alternative with a free trial and a cloud marketplace plan priced at $0.41 a month, billed at $0.41 per core hour for the time period used.

Strata offers a free plan with one developer, 25 users, and two data sources per project, which may suit teams prioritizing a larger free user allowance.

Definite has a free plan for two users, two connectors, 1 GB storage, five credits per month, and daily sync, a useful option for a small, tightly bounded start.

Verdict

dbt Semantic Layer is the right choice for dbt-based data teams that need a governed metric layer across analytics, applications, and AI, especially when version-controlled definitions and multiple query interfaces matter. Its central advantage is reusing consistent metric logic across consumers; look elsewhere if you need a standalone tool, a free Semantic Layer, or more room than Starter's 5,000 monthly queried metrics and one project.

The verdict

The dbt Semantic Layer gives teams a shared way to define and query metrics across listed tools and platforms. Confirm account eligibility and monthly query limits before relying on it for a workload.

Questions people ask

Is the dbt Semantic Layer available on a free plan?

The free Developer plan does not list the Semantic Layer. Defining and querying its metrics requires a Starter or Enterprise-tier account.

What does Starter cost?

Starter costs $100 a month, billed per user/month, and includes 5,000 queried metrics monthly.

What usage limits apply to Enterprise?

Enterprise and Enterprise+ each include 20,000 queried metrics per month.

Which data platforms are supported?

The documentation identifies Snowflake, BigQuery, Databricks, and Redshift.

How can tools access metrics?

Access options include GraphQL and JDBC APIs, a Python SDK, and the dbt MCP Server. The product also describes integrations for BI, notebooks, spreadsheets, embedded analytics, and AI systems.

Can AI tools use the Semantic Layer?

AI tools including Claude and ChatGPT can connect to governed metrics through the dbt MCP Server.

What the maker publishes

Access controls
The Semantic Layer applies access permissions and respects policies attached to the underlying warehouse credentials. source
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. source
AI access
AI tools including Claude and ChatGPT can connect to governed metrics through the dbt MCP server. source
AI connectivity
Claude and ChatGPT can access governed metrics through the dbt MCP Server. source
APIs
The Semantic Layer provides GraphQL and JDBC APIs and a Python SDK for querying metrics and dimensions. source
Authentication
API access uses personal or service-account tokens, with service tokens linked to warehouse credentials. source
Caching
MetricFlow can rewrite queries and use caching to reduce latency, compute, and repeated warehouse work. source
Company founding and headquarters
LinkedIn lists dbt Labs as founded in 2016 and headquartered in Philadelphia, Pennsylvania. source
Company size
LinkedIn lists dbt Labs as privately held with 501–1,000 employees. source
Deployment requirement
Production metric deployment currently works through a deployment environment, while development-environment support is marked as coming later. source
Documentation depth
Documentation covers semantic models, entities, dimensions, metrics, CLI commands, manifests, deployment, credentials, tokens, and integrations. source
Downstream destinations
dbt lists integrations including Google Sheets, Hex, Mode, Preset, Sigma, Tableau, ThoughtSpot, Census, Hightouch, and Lightdash. source
Founded
2016 source
Governed definitions
Metrics are version-controlled and lineage-aware because teams define them as YAML in dbt projects. source
GraphQL API
The Semantic Layer exposes GraphQL for querying metrics and dimensions. source
Headquarters
Oakland, California, United States source
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. source
Intended users
The product is presented for data teams seeking governed, consistent metrics for analytics, embedded applications, and AI use cases. source
JDBC API
A JDBC driver supports metric and dimension queries plus standard metadata operations. source
Licence
The dbt Semantic Layer service and APIs are proprietary cloud software; MetricFlow and dbt-semantic-interfaces are Apache 2.0 licensed. source
Limit: connectors
A reviewer says the relatively new product needs more connector development. source
Limit: error handling and alerts
A reviewer requests easier error handling, more scheduling options, and more customizable alerts. source
Limit: pricing uncertainty
A reviewer worries that costs could rise substantially as usage grows. source
Limit: upstream ETL
A reviewer says dbt assumes information is already in the database, requiring separate ETL work for other sources. source

Checked against the maker's pages on 15 Oct 2026.