skills.rest
Paldom
PaldomCOMMUNITY
Explore all skills by this author →
GitHub

databricks-metric-views

Define governed business metrics in YAML for Unity Catalog.

11|3|Updated Jun 10, 2025
Search Tags:#yaml#joins#materialization#unity-catalog#dimensions#measures#metric-views
One-click install
npx skills add https://github.com/Paldom/databricks-apps-fastapi-starter --skill databricks-metric-views-paldom
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-metric-views
Source: https://github.com/Paldom/databricks-apps-fastapi-starter/tree/main/.gemini/skills/databricks-metric-views
Command: npx skills add https://github.com/Paldom/databricks-apps-fastapi-starter --skill databricks-metric-views-paldom

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Unity Catalog metric views let teams define, manage, and query governed business metrics in YAML, enabling consistent KPI definitions across dashboards and BI tools.

Core Features & Use Cases

  • Declarative metric definitions using YAML with versioning, sources, dimensions, and measures.
  • Supports joins, window measures (experimental), materialization, and filters for flexible analytics.
  • Use cases include building standardized revenue, user activity, and performance KPIs across multiple teams.

Quick Start

Write a YAML block to declare a metric view and apply it to your Unity Catalog source to begin querying standardized KPIs.

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 YAML for Unity Catalog?▼

You define governed business metrics in YAML by creating declarations with version, source, dimensions, and measures, plus optional joins and materialization, to establish standardized KPIs queryable across dashboards and BI tools.

What is a Unity Catalog metric view and when do I need one?▼

A Unity Catalog metric view is a declarative YAML definition for standardized KPIs. You need one when multiple teams require consistent revenue, user activity, or performance calculations across different dashboards and analytics tools.

Can I use YAML metric definitions with star and snowflake schemas in Unity Catalog?▼

Yes, YAML metric definitions support joins and windowed calculations across both star and snowflake schemas in Unity Catalog, allowing flexible dimensional modeling and reusable analytics for complex data structures.

What's the best way to standardize KPIs across multiple BI dashboards in Databricks?▼

The best way to standardize KPIs is defining reusable metric views in YAML, which supports versioning, dimensions, measures, and materialization to ensure consistent definitions across multiple BI dashboards and Genie.

Does Unity Catalog metric views support materialization and window measures?▼

Yes, Unity Catalog metric views support materialization for performance optimization and experimental window measures, enabling complex time-based and rolling calculations within your declarative YAML metric definitions.

Related Skills

Explore More Data & Analytics Skills→
LaurentPRAT-DBLaurentPRAT-DB

databricks-metric-views

Manage Unity Catalog metric views via declarative YAML specifications.

Community
Advanced
exploreomniexploreomni
30

omni-to-databricks-metric-view

Convert Omni topic metrics into Databricks Metric View YAML definitions for Unity Catalog.

Official
Advanced
ice-droid-99ice-droid-99

databricks-metric-views

Define and manage Databricks Unity Catalog metric views using YAML.

Community
Intermediate
JingyiWngJingyiWng

databricks-metric-views

Define, create, and query governed business metric views in Unity Catalog.

Community
Intermediate