Skip to main content
Applies a filter to all rows in a query using filter syntax. This parameter is functionally identical to always_where_sql, but uses filter syntax instead of SQL.
When a new always_where_filter is defined, it will apply to all existing queries built from that topic as well as any queries created in the future.
This parameter is useful for removing invalid data from the topic, such as deleted records or internal testing. When defined, a filter will be inserted into the WHERE clause of the generated SQL block of all queries in the topic. Users with the Querier role can’t change this filter and it will be visible only in the underlying SQL of any queries. This filter is additive to any filters specified in the workbook. For optional filter conditions, use default_filters.

​
Syntax

always_where_filters:
  <field_name>:
    <filter_operator>: <value>

​
Properties

​
always_where_filters
object
required
A map of field names to filter conditions that are applied to all queries in the topic using filter syntax.

​
Examples

always_where_filters:
  users.state:
    is: California