How does it identify dimensions?

It scans your model's column types and names to suggest appropriate categorical or time-based dimensions for your confirmation.

Can it help migrate old metrics?

Yes, it includes guidance for migrating older metrics specifications to the current dbt Semantic Layer format.

Which dbt versions are supported?

This skill is optimized for dbt 1.12.0 and above, following the latest semantic layer YAML specification.

Can it handle cross-model metrics?

Absolutely, it supports top-level metrics like ratios and derived metrics that span multiple semantic models.

Does it validate the generated YAML files?

Yes, it performs both dbt parse validation and semantic layer validation using the dbt Cloud CLI or MetricFlow CLI.

dbt Semantic Layer Architect

Name: dbt Semantic Layer Architect
Author: dbt-labs

bydbt-labs

•

Database Management

Simplifies the creation and management of dbt Semantic Layer components including semantic models, metrics, and dimensions.

This skill empowers Claude to act as a domain expert for the dbt Semantic Layer, guiding users through the end-to-end process of defining semantic models, entities, dimensions, and metrics. It leverages MetricFlow to translate complex business logic into standardized YAML configurations, ensuring consistent data definitions across your organization. Whether you are starting from a raw business question or an existing dbt model, this skill provides structured workflows for implementation, validation, and maintenance of the dbt 1.12.0+ metrics specification.

Key Features

01Identification of primary/foreign entities and categorical/time dimensions

02Support for simple, derived, cumulative, ratio, and conversion metrics

03Guidance on migrating older metric specs to the current dbt standard

04Automated generation of semantic model YAML configurations

05Two-stage validation using dbt parse and MetricFlow/dbt SL commands

0613 GitHub stars

Use Cases

01Validating and refining complex cross-model metrics and aggregations

02Exposing existing dbt models to the semantic layer for BI consumption

03Transforming business requirements into tracked metrics like LTV or churn

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dbt-labs/dbt-agent-skills building-dbt-semantic-layer

For use in Claude.ai and ChatGPT

Download Skill