skills.rest
juandaniel190
juandaniel190COMMUNITY
Explore all skills by this author →
GitHub

building-dbt-semantic-layer

Create and modify dbt Semantic Layer metrics and semantic models.

1|Updated Jan 17, 2026
Search Tags:#metrics#data modeling#yaml#dbt#semantic layer#metricflow
One-click install
npx skills add https://github.com/juandaniel190/personal-projects --skill building-dbt-semantic-layer-juandaniel190
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: building-dbt-semantic-layer
Source: https://github.com/juandaniel190/personal-projects/tree/main/.cursor/skills/building-dbt-semantic-layer
Command: npx skills add https://github.com/juandaniel190/personal-projects --skill building-dbt-semantic-layer-juandaniel190

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the creation and modification of dbt Semantic Layer components, ensuring accurate and consistent business metric definitions.

Core Features & Use Cases

  • Define Semantic Models: Configure metadata for dbt models to map them to business concepts.
  • Create Metrics: Define business calculations (simple, derived, cumulative, ratio, conversion) on top of semantic models.
  • Use Case: You need to define a new metric for 'Customer Lifetime Value' based on your customers and orders dbt models. This Skill will guide you through defining the necessary entities, dimensions, and the metric itself, ensuring it's correctly configured according to the latest or legacy dbt Semantic Layer specifications.

Quick Start

Use the building-dbt-semantic-layer skill to define a new metric for total revenue based on the 'orders' model.

Frequently Asked Questions about building-dbt-semantic-layer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I define metrics in dbt Semantic Layer YAML?▼

To define metrics in the dbt Semantic Layer, you configure semantic models with entities and dimensions, then create metric types like simple, derived, cumulative, ratio, or conversion using MetricFlow YAML syntax.

What is a semantic model in dbt and how does MetricFlow use it?▼

A semantic model in dbt maps your transformed data to business concepts by defining metadata, entities, and dimensions. MetricFlow uses this mapping to consistently calculate and query metrics across your data stack.

How do I create cumulative and ratio metrics in dbt MetricFlow?▼

Creating cumulative and ratio metrics in dbt MetricFlow involves specifying the metric type in your YAML configuration, defining the necessary aggregation parameters, and mapping them to the correct dimensions and entities in your semantic models.

Does the dbt Semantic Layer support SCD Type II dimensions and time spines?▼

Yes, the dbt Semantic Layer supports SCD Type II dimensions and time spines. You can configure specific semantic model parameters in your YAML to handle slowly changing dimensions and temporal aggregations correctly.

Can I validate legacy and latest dbt Semantic Layer YAML specifications?▼

Yes, you can validate both legacy and latest dbt Semantic Layer YAML specifications. The configuration process includes validation steps to ensure your semantic models, entities, and metric definitions comply with the targeted specification version.

Related Skills

Explore More Data & Analytics Skills→
miptah21miptah21
2

migrating-sql-to-dbt

Convert legacy SQL into layered dbt models with build validation.

Community
Intermediate
nrakownrakow
1

metrics-layer

Define semantic models and metrics for dbt Semantic Layer, MetricFlow, and Cube.

Community
Advanced
borgheiborghei
467

analytics-engineer

Model data and build dbt pipelines from staging to marts.

Community
Advanced
lucaslessachaveslucaslessachaves
1

databricks-metric-views

Define governed business metrics in YAML with dimensions and measures.

Community
Advanced