Filter Local Data Synced to Data Pipelines

Exclude unnecessary or sensitive data from syncing to Data Pipelines with data sync filters. Filters run on the source object and speed up data sync by pulling only the data you need into Data Pipelines. If you want to use excluded data in the future, use a recipe filter to limit the dataset data instead of a data sync filter.

1. From the Data Manager's Connections tab, select the connection containing the object to filter.
   If you have many connections, use the search box to find the connection and object.
2. Click the name of the object to filter.
3. Click Data Sync Filter.
4. Enter the filter.
   Always wrap the filter statement in parentheses to avoid SOQL syntax errors.
5. Click Save.

Example Salesforce local object filters use the SOQL WHERE clause expression as described in the SOQL and SOSL Reference. For example, "((FiscalQuarter = 2 OR FiscalQuarter = 3) AND Amount > 1000 AND Amount <= 20000").