databricks-metric-views

What problem does it solve?

This Skill enables the definition, creation, querying, and management of standardized, governed business metrics within Unity Catalog using a declarative YAML syntax, ensuring consistency across teams and tools.

Core Features & Use Cases

• Define Reusable Metrics: Create business KPIs like revenue, order counts, and conversion rates that can be consistently used across dashboards, Genie, and SQL.
• Complex Aggregations & Window Measures: Supports ratios, distinct counts, filtered measures, and advanced window calculations like moving averages and running totals.
• Star/Snowflake Schema Modeling: Declaratively define joins for modeling dimensional data models directly within metric definitions.
• Use Case: Define a "Total Revenue" metric once in YAML, and then use it across multiple BI dashboards and natural language queries, ensuring everyone is using the same, accurate definition.

Quick Start

Use the databricks-metric-views skill to create a metric view for orders data.