Metric Views Patterns for Genie & AI/BI

Overview

Metric Views provide a semantic layer for natural language queries via Genie and AI/BI dashboards. This skill standardizes the YAML structure for comprehensive, LLM-friendly metric definitions following Databricks Metric View Specification v1.1.

Predecessor: Gold tables must exist before creating metric views. Use gold-layer-design + gold-layer-setup skills first.

Key Capabilities:

• Create metric views with proper SQL syntax (WITH METRICS LANGUAGE YAML)
• Validate schemas before deployment to prevent 100% of common errors
• Structure joins (direct and snowflake schema patterns)
• Optimize comments for Genie natural language queries
• Handle SCD2 dimensions with proper is_current filtering

When to Use This Skill