dbt Semantic Layer
MetricFlow-powered semantic layer integrated into the dbt ecosystem for governed metrics.
- MCP
- CLI
- 2
- Skills
About dbt Semantic Layer
MetricFlow-powered semantic layer integrated into the dbt ecosystem for governed metrics. Explore how dbt Semantic Layer integrates with the agentic data stack ecosystem and supports autonomous data operations.
Key Features
- Centralized metric definitions in YAML on top of existing dbt models
- MetricFlow-powered SQL generation optimized per data platform
- Complex metric types: ratio, expression, cumulative, and derived metrics
- Dynamic multi-hop join resolution based on entity keys and semantic model relationships
- Result caching and declarative caching for performance optimization
- Consistent metric access across all downstream tools organization-wide
- Export capabilities to write queries directly to the data platform on a schedule
- Robust access control and permissions for secure metric distribution
External Links
dbt MCP Server DocumentationOfficial docs on the dbt MCP server with 60+ tools across 8 toolset categoriesSemantic Layer GraphQL APIGraphQL API for querying metrics and dimensions from the dbt Semantic LayerSemantic Layer JDBC APIJDBC driver (ArrowFlight SQL) for querying Semantic Layer metrics programmaticallyIntroducing the dbt MCP ServerAnnouncement post explaining how the MCP server brings structured data to AI workflowsPartner Integration GuideBest practices for integrating with the dbt Semantic Layer
← Back to Semantic Layer