skills.rest
ivanshamaev
ivanshamaevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

dbt-starrocks-semantic-layer

Implement dbt Semantic Layer metrics on StarRocks with CLI validation.

14|1|Updated May 5, 2026
Search Tags:#dbt#semantic layer#metricflow#materialized views#starrrocks#kpi governance
One-click install
npx skills add https://github.com/ivanshamaev/de-agent-skills --skill dbt-starrocks-semantic-layer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt-starrocks-semantic-layer
Source: https://github.com/ivanshamaev/de-agent-skills/tree/main/group_skills/starrocks_group_skills/dbt_starrocks_semantic_layer
Command: npx skills add https://github.com/ivanshamaev/de-agent-skills --skill dbt-starrocks-semantic-layer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill solves inconsistent KPI definitions across teams by centralizing metric, dimension, and exposure logic using dbt Semantic Layer (MetricFlow) on top of StarRocks.

Core Features & Use Cases

  • Metric and dimension governance: Define entities, dimensions, and measures once and reuse them for consistent business KPIs.
  • Advanced metric types: Create simple, ratio, derived, and cumulative metrics, plus period-over-period comparisons.
  • BI-ready exposures and saved queries: Document BI dependencies and provide reusable report query patterns.
  • Performance through pre-aggregation: Link semantic models to StarRocks materialized view or Gold aggregate tables for faster queries.

Quick Start

Use the dbt MetricFlow CLI to list metrics and then query a KPI like total_revenue by region and week for a specific date range.

Frequently Asked Questions about dbt-starrocks-semantic-layer

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

FAQPage Schema
How do I standardize business KPIs and metrics using dbt Semantic Layer?▼

Standardize business KPIs using the dbt Semantic Layer by defining entities, dimensions, and measures once in MetricFlow to ensure consistent metric calculations and reuse across BI consumption.

What types of metrics can I create with MetricFlow on StarRocks?▼

MetricFlow on StarRocks supports creating simple, ratio, derived, and cumulative metrics, alongside period-over-period comparisons for standardized analytical workflows.

How do I use StarRocks materialized views to speed up dbt semantic layer queries?▼

Speed up dbt semantic layer queries by linking semantic models to StarRocks materialized views or Gold aggregate tables, enabling performance-oriented querying through pre-aggregated sources.

Can I document BI dependencies and saved query patterns in a dbt semantic layer?▼

Document BI dependencies and reusable query patterns in a dbt semantic layer by defining BI-ready exposures and saved queries for standardized report consumption.

Do I need the dbt MetricFlow CLI to validate StarRocks SQL generation?▼

Yes, you need the dbt MetricFlow CLI to list metrics, execute saved queries, and perform CLI-based validation of the generated StarRocks SQL for your semantic models.

Related Skills

Explore More Data & Analytics Skills→
dbt-labsdbt-labs
653

building-dbt-semantic-layer

Create and modify dbt Semantic Layer components using MetricFlow.

Official
Advanced
nrakownrakow
1

metrics-layer

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

Community
Advanced
xxihxxih
1

clickhouse-io

Optimize ClickHouse MergeTree schemas and aggregation queries for analytics.

Community
Intermediate
Datus-aiDatus-ai
1.5k

gen-metrics

Convert natural language metric descriptions and SQL queries into validated MetricFlow definitions.

Official
Advanced