databricks-metric-views

Define governed business metrics in Unity Catalog using declarative YAML syntax. This approach standardizes KPIs like revenue or conversion rates, ensuring they are consistently reused across BI dashboards, SQL, and Genie.

Yes, Unity Catalog supports complex aggregations and window measures for KPIs. You can declaratively define ratios, distinct counts, filtered measures, and advanced calculations like moving averages and running totals.

Yes, you can model star and snowflake schemas when defining business metrics. The skill allows you to declaratively define joins for dimensional data modeling directly within your YAML metric definitions.

Yes, creating governed metric views requires Databricks Runtime 17.2 or higher. You also need SQL warehouse access to define, query, and manage your standardized business metrics in Unity Catalog.

The best way to define reusable KPIs is using declarative YAML to create metric views in Unity Catalog. By defining a metric once, you ensure everyone uses the same accurate definition across multiple BI dashboards and Genie queries.