9.1 Dashboard Parameters & Interactive Filtering

Databricks Certified Data Analyst Associate Exam

Track your progress as you read

Finished sections get a check mark.

1 Platform Overview & Unity Catalog Foundations

1.1 Databricks Architecture & Compute Concepts 1.2 Databricks Marketplace & Data Sharing Basics 1.3 Unity Catalog Namespace & Object Hierarchy 1.4 Governed Asset Discovery & System Tables

2 Managing & Cleaning Governed Data

2.1 Dataset Discovery & Asset Tagging 2.2 Lineage Inspection & Data Traceability 2.3 SQL Data Cleaning & Transformation Techniques

3 Data Ingestion & Import Patterns

3.1 Workspace Uploads & Cloud File Ingestion 3.2 Incremental File Ingestion with Auto Loader 3.3 Ingesting Data via Delta Sharing & External Connections

4 Databricks SQL Warehouses & Core Querying

4.1 Databricks SQL Interface & SQL Assistant 4.2 SQL Warehouses Sizing & Management 4.3 Table Creation & Data Modification in Databricks SQL

5 Advanced SQL Authoring & Time Travel

5.1 Advanced Aggregations, Window Functions & Analytics 5.2 Complex Joins, CTEs & Set Operations 5.3 Views, Materialized Views & Delta Time Travel

6 Query Performance Analysis & Photon Engine

6.1 Photon Engine Architecture & Acceleration 6.2 Query History & Execution Profile Inspection 6.3 Delta Lake Audit History & Commit Logs

7 Liquid Clustering, Caching & Performance Troubleshooting

7.1 Caching Hierarchy in Databricks SQL 7.2 Data Layout Optimization: Liquid Clustering vs Partitioning & Z-Ordering 7.3 Troubleshooting Slow & Failing Queries

8 AI/BI Dashboards & Visualization Design

8.1 AI/BI Dashboards Overview & Canvas Layout 8.2 Chart Types & Visualization Selection 8.3 Notebook & SQL Editor Visualizations

9 Dashboard Interactivity, Publishing & Alerts

9.1 Dashboard Parameters & Interactive Filtering 9.2 Publishing, Sharing & Access Control 9.3 Scheduled Refresh, Email Subscriptions & Alerts

10 Developing & Maintaining AI/BI Genie Spaces

10.1 AI/BI Genie Architecture & Space Setup 10.2 Curation via Instructions, Descriptions & Sample Questions 10.3 Trusted Assets & Parameterized Functions 10.4 Monitoring, Benchmarks, Feedback & Maintenance

11 Data Modeling & Medallion Architecture

11.1 Dimensional Modeling Fundamentals 11.2 Medallion Architecture for Analytics 11.3 Constraint Enforcement & Relationships in Unity Catalog

12 Securing Data & Unity Catalog Governance

12.1 Unity Catalog Privilege Model & Grants 12.2 Ownership, Inheritance & Access Control Patterns 12.3 Fine-Grained Security: Row Filters & Column Masks

9.1 Dashboard Parameters & Interactive Filtering

Key Takeaways Explain This Topic AI

Databricks AI/BI Dashboards support canvas parameters (Text, Date/Date Range, Dropdown, Number) that link directly to SQL queries using :parameter_name syntax.

Static widget parameters operate at the widget level, whereas global parameters bind across multiple dataset queries using unified dataset field matching as of the 2024 AI/BI engine update.

Cross-filtering enables interactive point-and-click slicing across visual components without requiring explicit parameter syntax in underlying SQL datasets.

Parameter values in published AI/BI dashboards default to saved state values but persist user selections within individual user sessions without mutating the published default.

Dynamic dropdown parameters can be backed by dedicated SQL queries limited to 100,000 distinct values to ensure fast widget loading performance.

Last updated: July 2026

Databricks AI/BI Dashboards (built on Lakeview technology) represent a major evolution in how data teams build interactive data applications on the Databricks Data Intelligence Platform. Unlike legacy Redash or Databricks SQL dashboards, AI/BI Dashboards use a decoupled runtime architecture where visual components interact seamlessly with underlying Databricks SQL Warehouses. A central capability enabling rich user interaction is parameterization—allowing consumers to dynamically slice, dice, and filter dataset results without writing SQL code or requesting custom dashboard builds from data analysts.

Parameter Architecture & SQL Syntax

In Databricks AI/BI Dashboards, parameters are named variables declared within a dataset's SQL query using colon syntax ( :parameter_name ). When a dashboard viewer selects a value from a filter widget on the canvas, the AI/BI engine substitutes that value into the designated parameter placeholder prior to sending the query to the active SQL Warehouse for execution.

Declaring Parameters in SQL Datasets

Parameters can be placed in any valid SQL clause, including WHERE , HAVING , CASE statements, and join conditions. The following SQL dataset query illustrates single-value text parameters, date range parameters, and numeric threshold parameters: SELECT

o.order_id,
o.customer_id,
c.customer_segment,
o.order_date,
o.shipping_region,
o.total_amount,
o.discount_amount
FROM main.sales_gold.fact_orders o
JOIN main.sales_gold.dim_customers c
ON o.customer_id = c.customer_id
WHERE o.order_date BETWEEN :start_date AND :end_date
AND (:region = 'All' OR o.shipping_region = :region)
AND o.total_amount >= :min_order_value;

When authoring this query in the AI/BI Dashboard SQL editor, Databricks automatically parses :start_date , :end_date , :region , and :min_order_value . The developer can then map these dataset parameters to canvas filter controls.

Canvas Filter Types & Binding Mechanics

AI/BI Dashboards support four primary parameter widget types on the visual canvas:

Text Inputs : Single-line text boxes for entering exact strings or wildcard search terms.

Number Inputs : Numeric fields for threshold filtering, percentiles, or top-N limits.

Date and Date Range Pickers : Calendar widgets allowing selection of specific dates, relative ranges (e.g., "Last 30 Days"), or custom start/end date pairs.

Dropdown Selectors : Single-select or multi-select dropdown menus displaying lists of predefined or dynamically generated values.

Global vs. Local Parameter Binding

A critical advantage of AI/BI Dashboards is multi-dataset parameter binding. A single canvas control—such as a Date Range picker—can be bound to :start_date and :end_date parameters across ten distinct dataset queries powering different widgets on the same canvas. When the user updates the date range picker, all ten queries execute concurrently with the updated date boundary values.

Field Filters vs. Parameter Filters

Databricks AI/BI Dashboards offer two distinct modes for canvas filtering: Field Filters and Parameter Filters . Understanding the operational differences between these two approaches is essential for both developer efficiency and query performance.

Feature Field Filters SQL Parameter Filters
Declaration Method Canvas-level binding to a dataset column Explicit :param_name in SQL dataset query

SQL Modification Automatically injects WHERE clause into dataset query Injects user selection directly into declared placeholder

Flexibility Limited to standard equality/range filtering on columns Supports complex logic, subqueries, CASE expressions, and dynamic joins

Multi-Dataset Use Matches columns by name across datasets automatically Manually bound to specific parameter names across datasets

Default Handling Displays "All" or unconstrained values by default Requires fallback logic in SQL (e.g., :region = 'All' )

Cross-Filtering & Canvas Interactions

In addition to explicit parameter widgets, AI/BI Dashboards feature native cross-filtering . When cross-filtering is enabled on a canvas widget (such as a bar chart displaying revenue by region), clicking on a specific bar (e.g., "EMEA") automatically applies an interactive filter across all other charts on the dashboard that share the same underlying dataset or join key.

Cross-Filtering Execution Dynamics

Client-Side Slicing : If the underlying dataset is already loaded in memory, cross-filtering applies instantly in the browser without issuing a new SQL Warehouse query.

Server-Side Re-execution : If the cross-filtered selection requires data outside the loaded result set, the AI/BI engine issues a targeted subquery to the SQL Warehouse.

Combined Filtering : Cross-filter selections operate as an AND condition alongside active canvas parameter widgets.

Developers can enable or disable cross-filtering independently on each visual widget via the widget setting panel. Disabling cross-filtering is recommended for reference charts (such as overall target benchmark lines) that should remain fixed regardless of user interactions elsewhere on the canvas.

Dynamic Dropdowns & Performance Best Practices

Dropdown filter parameters can be populated statically (a hardcoded list of values) or dynamically (driven by a SQL query). Dynamic dropdowns ensure filter options reflect current database states, such as displaying only regions that currently have active orders in the database.

Dynamic Dropdown Query Guidelines

To ensure dynamic dropdowns do not introduce performance bottlenecks:

Keep Queries Light : Dynamic dropdown queries should query small dimension tables or materialized views rather than scanning large fact tables.

Cardinality Ceilings : Databricks limits dynamic dropdown queries to 100,000 distinct values . Attempting to load high-cardinality fields (such as individual UUIDs or transaction timestamps) will cause truncation and degrade filter widget responsiveness.

Use Explicit Caching : Dynamic dropdown queries benefit significantly from SQL Warehouse result caching. -- Optimal dynamic dropdown query targeting a small dimension table

SELECT DISTINCT region_name
FROM main.sales_gold.dim_region
WHERE is_active = true
ORDER BY region_name;
URL Parameter Passing

Published AI/BI Dashboards support URL query parameters. This allows analysts to pre-filter dashboards when sharing links via email or embedding them in external tools. URL parameter syntax follows the format ?p_parameter_name=value . For example: https://<databricks-instance>/dashboards/v2/db-12345?p_region=EMEA&p_min_order_value=1000 . Passing parameters via URL immediately applies the specified values upon page load, bypassing saved dashboard defaults for that session.