Query filters

Preview

This feature is in Public Preview. Contact your Databricks representative to request access.

A query filter lets you interactively reduce the amount of data shown in a visualization, similar to query parameter but with a few key differences. A query filter limits data after it has been loaded into your browser. This makes filters ideal for smaller datasets and environments where query executions are time-consuming, rate-limited, or costly.

To focus on a specific value, alias your column to `<columnName>::filter` . Here’s an example:

SELECT action AS `action::filter`, COUNT(0) AS "actions count"
FROM events
GROUP BY action

If you need a multi-select filter, alias your column to <columnName>::multi-filter.

SELECT action AS `action::multi-filter`, COUNT (0) AS "actions count"
FROM events
GROUP BY action

You can also use query filters on dashboards. By default, the filter widget appears beside each visualization where the filter has been added to the query. To link together the filter widgets into a dashboard-level query filter see Dashboard filters.

Limitations

Query filters aren’t suitable for especially large data sets or query results with hundreds or thousands of distinct field values. Depending on your computer and browser configuration, excessive data can deteriorate the user experience.