databricks-metric-views

Define reusable business metrics in Unity Catalog using YAML.

1|1|Updated Oct 1, 2025
One-click install
npx skills add https://github.com/mkgs-databricks-demos/synthea-on-fhir --skill databricks-metric-views-mkgs-databricks-demos
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-metric-views
Source: https://github.com/mkgs-databricks-demos/synthea-on-fhir/tree/main/.cursor/skills/databricks-metric-views
Command: npx skills add https://github.com/mkgs-databricks-demos/synthea-on-fhir --skill databricks-metric-views-mkgs-databricks-demos

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Governance-ready, reusable business metrics in Unity Catalog are hard to standardize across teams and tools; this skill enables defining, storing, and reusing KPI definitions in YAML for consistent reporting.

Core Features & Use Cases

  • Define standardized metrics (revenue, conversions, etc.) and share them across dashboards and queries.
  • Model star or snowflake schemas declaratively in YAML with joins and materialization options.
  • Enable flexible, on-demand metrics querying via MEASURE() in SQL.

Quick Start

Create a metric view by providing a YAML definition that includes source, dimensions, and measures.

Frequently Asked Questions about databricks-metric-views

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

FAQPage Schema
How do I define reusable business metrics in Unity Catalog?

You define reusable business metrics in Unity Catalog by writing a YAML definition that specifies source tables, dimensions, measures, and optional joins to standardize KPIs across dashboards. This approach ensures consistent metric definitions for cross-team reporting.

What is the best way to standardize KPI definitions across multiple dashboards in Databricks?

Standardizing KPI definitions across multiple dashboards in Databricks is best achieved by defining governed metrics in YAML and storing them as metric views in Unity Catalog. This allows teams to share a single source of truth for revenue and conversion metrics.

Can I model star schema joins declaratively in YAML for Databricks metric views?

Yes, you can model star or snowflake schema joins declaratively in YAML for Databricks metric views. The YAML body supports specifying source tables, dimensions, measures, and optional joins to structure your data model.

Do I need Unity Catalog to use governed metrics defined in YAML?

Yes, Unity Catalog is required to use governed metrics defined in YAML. This skill specifically leverages Unity Catalog to store and manage standardized business metrics, ensuring consistent definitions across tools and cross-team dashboards.

How do I query on-demand metrics defined in YAML using SQL?

You query on-demand metrics defined in YAML by using the MEASURE() function in SQL. This allows flexible querying of the standardized business metrics stored as metric views in Unity Catalog.

What is a metric view in Databricks and when do I need one?

A metric view in Databricks is a governance-ready, reusable business metric definition stored in Unity Catalog using YAML. You need one when building standardized KPIs that require consistent metric definitions across multiple tools and cross-team dashboards.