Google BigQuery Connectors > Part II: Data Integration with Google BigQuery V2 Connector > Mappings and mapping tasks with Google BigQuery V2 Connector > Data filters
  

Data filters

You can create simple or advanced data filters. You can also create a set of data filters for each object included in a mapping task. Each set of data filters act independently of the other sets.
You can create simple or advanced data filters for the following data types:
Note: When you create simple or advanced data filters for columns of Numeric data type, you must ensure that you use a Google BigQuery V2 connection in hybrid connection mode.
You can only configure simple filters in elastic mappings.

Simple data filters

You can create one or more simple data filters. When you create multiple simple data filters, the associated task creates an AND operator between the filters and loads rows that apply to all simple data filters.

Advanced data filters

You can create an advanced data filter to create complex expressions that use AND, OR, or nested conditions. The expression that you enter becomes the WHERE clause in the query used to retrieve records from the source.
Use the following formats to define a filter field in an advanced data filter:
Note: If the Google BigQuery dataset name begins with a number, use one of the following formats to define a filter field in an advanced data filter: