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.

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:

<fieldName>
<projectName>.<datasetName>.<tableName>.<fieldName>

If the Google BigQuery dataset name begins with a number, use the following format to define a filter field in an advanced data filter:

<projectName>.'<datasetName>'.<tableName>.<fieldName>