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 Data Synchronization 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:
- •Integer
- •Float
- •String
- •Timestamp
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.
Note: Google BigQuery Connector does not support the $LastRunDate variable under advanced data filters.