skills.rest
keithbinkly
keithbinklyCOMMUNITY
Explore all skills by this author →
GitHub

dbt-semantic-layer-developer

Build dbt semantic models, metrics, and BI tool integrations.

5|1|Updated Nov 15, 2025
Search Tags:#metrics#dbt#entities#semantic layer#dimensions#metricflow#semantic models#BI integration
One-click install
npx skills add https://github.com/keithbinkly/dbt-semantic-layer --skill dbt-semantic-layer-developer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt-semantic-layer-developer
Source: https://github.com/keithbinkly/dbt-semantic-layer/tree/main
Command: npx skills add https://github.com/keithbinkly/dbt-semantic-layer --skill dbt-semantic-layer-developer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires dbt, metricflow, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill provides expert-level assistance with dbt Semantic Layer, MetricFlow, semantic models, metrics, dimensions, entities, measures, and BI tool integrations. It helps users build semantic models, create metrics, debug validation errors, and integrate with BI tools, enabling consistent metrics across all data tools.

Core Features & Use Cases

  • Semantic Model Development: Define and manage semantic models, including entities, dimensions, and measures.
  • Metric Creation: Create various types of metrics (simple, ratio, cumulative, derived, conversion) and manage their configurations.
  • MetricFlow Integration: Configure and utilize MetricFlow for time spine, join logic, grain, and filtering.
  • BI Tool Integration: Integrate with Tableau, Power BI, Looker, Hex, Mode, and other BI tools for data analysis.
  • Verification & Debugging: Validate and debug semantic layer issues, including validation errors and query failures.

Quick Start

Use the skill to define a semantic model for orders, including entities like order_id and customer_id, dimensions like order_date and order_status, and measures like order_total and order_count.

Frequently Asked Questions about dbt-semantic-layer-developer

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

FAQPage Schema
How do I build a dbt semantic model with MetricFlow?▼

To build a dbt semantic model with MetricFlow, you define entities, dimensions, and measures within your dbt project, enabling consistent metrics across your data tools. This process structures your data for MetricFlow queries.

What types of metrics can I create using the dbt Semantic Layer?▼

The dbt Semantic Layer supports creating simple, ratio, cumulative, derived, and conversion metrics. Configuring these metric types within your semantic models allows for flexible and consistent data analysis.

How do I integrate dbt Semantic Layer metrics with BI tools?▼

You integrate dbt Semantic Layer metrics with BI tools like Tableau, Power BI, and Looker to ensure consistent metrics across data analysis platforms. This integration connects your semantic models directly to your BI environment.

How do I debug dbt Semantic Layer validation errors?▼

Debugging dbt Semantic Layer validation errors involves checking your semantic model definitions, verifying entity and dimension configurations, and validating MetricFlow query logic. This process resolves inconsistencies in your metric definitions.

Can I use MetricFlow for time spine and join logic in semantic models?▼

Yes, you can configure and utilize MetricFlow to manage time spine, join logic, grain, and filtering within your dbt semantic models. This ensures accurate temporal aggregations and relationships across your metrics.

Do I need a dbt Semantic Layer setup to define dimensions and measures?▼

Yes, defining dimensions and measures requires a dbt Semantic Layer setup and familiarity with dbt. This environment provides the necessary framework to structure and validate your semantic models.

Related Skills

Explore More Data & Analytics Skills→
shaprisshapris

building-dbt-semantic-layer

Configure dbt Semantic Layer models with YAML specs and validation workflows.

Community
Advanced
lucaslessachaveslucaslessachaves
1

databricks-metric-views

Define governed business metrics in YAML with dimensions and measures.

Community
Advanced
bobmatnycbobmatnyc
3

pydantic

Validate Python data models with Pydantic v2 runtime type checking.

Community
Intermediate
exploreomniexploreomni
30

omni-to-databricks-metric-view

Convert Omni topic metrics into Databricks Metric View YAML definitions for Unity Catalog.

Official
Advanced