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
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.