How to add interactive filters to an embedded SQL dashboard?

Draxlr makes it easy to add interactive filters to embedded SQL dashboards. From the Embed Settings panel, you can configure which filters are visible to end users, choose operators, and set default values.

For each dashboard filter, you can:

• Set visibility — choose whether the filter is visible or hidden in the embed.
• Set default values — pre-fill filter values so the dashboard loads with the right data.
• Choose operators — use options such as BETWEEN for date ranges or IN for picking several values.

Filters let customers explore their own data. For multi-tenant SaaS apps, use Draxlr's row-level security: your backend sends the customer's RLS group and attribute values with the embed token, and Draxlr limits every query to that customer's rows. Whatever filter values a customer picks, they only ever filter within their own data.

Row-level security is one of three common isolation patterns. Our comparison of row, schema and database isolation models explains how each approach keeps customer data separate.