databricks-metric-views

Define, create, and query governed business metrics in Unity Catalog using YAML.

31|18|Updated Apr 4, 2026
One-click install
npx skills add https://github.com/ThomazRossito/data-agents --skill databricks-metric-views-thomazrossito
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-metric-views
Source: https://github.com/ThomazRossito/data-agents/tree/main/skills/databricks/databricks-metric-views
Command: npx skills add https://github.com/ThomazRossito/data-agents --skill databricks-metric-views-thomazrossito

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Organizations struggle with inconsistent KPI definitions and redundant metric calculations across Databricks and Fabric, leading to duplicated effort and unreliable reporting.

Core Features & Use Cases

  • YAML‑driven metric view definition: Write reusable business metrics in a declarative format, separating dimensions and measures.
  • MCP tool integration: Create, alter, query, and grant access to metric views programmatically via Python.
  • Advanced modeling: Support for joins, window measures, and materialized views for high‑performance analytics.
  • Use case: A data analyst can define a unified revenue KPI once and reuse it in dashboards, Genie queries, and alerts across the enterprise.

Quick Start

Create a metric view named orders_metrics on catalog.schema.orders with month and status dimensions and total revenue and order count 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 governed business metrics in Databricks Unity Catalog using YAML?

YAML-driven metric view definition lets you declaratively separate dimensions and measures to standardize KPIs across Databricks and Fabric, eliminating inconsistent metric calculations and redundant effort in reporting.

Can I manage Databricks metric views programmatically using Python MCP tools?

MCP tools support Python-based management to create, alter, query, and grant access to metric views programmatically. This enables automated governance and lifecycle management for business metrics in Unity Catalog.

Does Databricks metric view creation require a specific runtime version?

Yes, governed metric views require Databricks Runtime 17.2 or higher and SQL warehouse permissions. This environment setup is necessary to define and query the YAML-driven metrics in Unity Catalog.

What is the best way to standardize KPIs across Databricks and Microsoft Fabric?

Defining unified metrics once in YAML and reusing them in dashboards, Genie queries, and alerts ensures reliable enterprise reporting across Databricks and Microsoft Fabric without duplicated effort or inconsistent KPI definitions.

Do Databricks metric views support advanced modeling like joins and window measures?

Yes, metric views support advanced modeling including joins, window measures, and materialized views. These features enable high-performance analytics for complex business metric calculations within Unity Catalog.

Why should I use YAML to manage metric views in Unity Catalog?

Using YAML to manage metric views in Unity Catalog solves the problem of inconsistent KPI definitions and redundant metric calculations across teams, providing a declarative format to standardize revenue metrics and order analytics reliably.