Boolean filter
Filter records based on a boolean field.Enum filter

Enum filter and preview
Null filter

Null filter configuration and preview
String filter

String filter configuration and preview
Threshold filter

Threshold filter configuration and preview
1Specifies the ‘allowed region’. For example,
Greater than or equal to 5 specifies that all values strictly less than five will be filtered.
SQL filter

SQL Filter configuration with preview
- Writing a valid SQL
WHEREstatement into the text box, but omitting the word “WHERE” - Use Generate SQL to leverage AI agents to compose the SQL query for you
Writing the SQL query
The SQL filter requires a validWHERE statement, but the word “where” is not included. As you type your query into the prompt, Validio will suggest operators and field names based on the schema in your data.

Suggestions when writing the SQL query
Generating the SQL query
When you select Generate SQL, you can leverage AI agents to compose the SQL query for you.
Describe your filtering requirements and select an LLM credential to generate the SQL query
- Enter your prompt: Describe the filtering conditions, for example
- Sales that’s not in category socks or underwear and quantity is more than 10. Exclude France
- Preview the query results and
- Click Accept to save the SQL query
- Click Reject to try again
SQL filter recipes
The following are recipes for common SQL filters. Each recipe is written in a generic syntax or in syntax specific for Google BigQuery or Snowflake, when required. You can use these recipes as a starting point when writing SQL filters for other data sources, such as Amazon Redshift or Amazon Athena.Filter operators
For example,some_column matches a filter with several operators.
SQL
Exists in set
For example,some_column match either of the values 'some_value' or 'some_other_value'.
SQL
Missing values
For example,some_column is null or matches a value that represents a missing value.
SQL
Semi-structured data
For example,some_array contains at least one element with value 2.
SQL (BigQuery)
SQL (Snowflake)
String pattern
For example,some_column does not contain a valid URL.
SQL (BigQuery)
SQL (Snowflake)