← All updates Databricks Update One-Pager Navy version
databricks Platform · Updated Apr 30, 2026

agg SQL function as a synonym for measure

The new agg aggregate function is a synonym for measure.

Update Open docs ↗release note ↗
What it does

The new agg aggregate function is a synonym for measure. Use agg(measure column) as a shorter alternative when querying measures in a metric view. Metric views are the core implementation of Unity Catalog business semantics in Unity Catalog.

Why it matters

+ Agent metadata in metric views + Add synonyms, display names, and formatting rules to improve AI agent accuracy and display consistent formats across tools.

Key capabilities
Create a metric view
Create a metric view
Define metric views using SQL
Define metric views using SQL DDL or the Catalog Explorer UI, with built-in YAML validation.
Query metric views
Query metric views
Query metric views from SQL
Query metric views from SQL editors, notebooks, dashboards, Genie Agents, and alerts.
Architecture
Databricks Platform → Platform
In short

The new agg aggregate function is a synonym for measure. Use agg(measure column) as a shorter alternative when querying measures in a metric view.

Read the full documentation ↗
Key takeaway
The new agg aggregate function is a synonym for measure.
2026-04-30-agg-sql-function-as-a-synonym-for-measure Generated by the Databricks Updates Agent · browse all updates