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

Metric View Parameters

Enhance metric views with dynamic parameters for flexible querying.

What it does

Metric views can now include parameters that allow users to pass values at query time, enabling a single metric view definition to serve multiple query variants. Parameters can be used in various SQL expressions, including filters and joins, and can have default values for convenience. This reduces the need for multiple metric view definitions, streamlining maintenance and enhancing usability.

Why it matters

This update significantly improves productivity by reducing duplication in metric view definitions, allowing data teams to manage fewer artifacts while still providing flexibility in querying. It also enhances the ability to adapt metrics to varying business scenarios without additional overhead, ultimately leading to better decision-making and faster insights.

Key capabilities
Dynamic Parameterization
Define parameters in metric views to customize queries at runtime.
Default Values
Set default values for parameters, simplifying queries for users who do not specify them.
Low-Code Editor Support
Easily add parameters using the Catalog Explorer low-code editor.
Flexible Querying
Query metric views using parameters by name or position, enhancing usability.
Prerequisites
Compute resource must meet minimum version requirements for metric views.
Recommended use cases
Dynamic reporting based on user-selected date ranges.Customizing metrics for different discount rates in sales analysis.Adapting metrics for various geographical regions without creating separate views.
Limitations · remember
!Materialization is not supported for metric views that define parameters.
Architecture
Catalog Explorer → Metric View Definition → SQL Query Execution
Get started
1
Add Parameter
In the low-code editor, click 'Add parameter' and enter the parameter details.
2
Define Default Value
Specify a default value and data type for the parameter.
3
Save Parameter
Click 'Save' to finalize the parameter definition.
4
Query with Parameters
Call the metric view as a table-valued function, passing parameters as needed.
5
View Parameter Definitions
Check the YAML definition to see the parameters defined for the metric view.
Key takeaway
The introduction of parameters in metric views allows for more efficient and flexible data querying, reducing maintenance overhead and enhancing user experience.
2026-06-26-metric-view-parameters-are-now-in-public-preview Generated by the Databricks Updates Agent · browse all updates