You can block specific columns from replicating to your destination. Column Blocking lets you avoid sending personally identifiable information (PII) to your destination, and brings you into compliance with GDPR.
NOTE: You cannot block primary key columns.
Column Blocking is available for the following connectors:
- Microsoft Dynamics 365
- NetSuite SuiteAnalytics
- SQL Server
To use this feature, go to the Schema tab on your connector details page and uncheck the columns you would like to omit from syncing.
Does column config prevent data from being stored on Fivetran’s servers?link
We try to retain your data for as little time as possible, especially when that data is PII. After you uncheck a column on the connector details page, the data in that column still passes through our systems. But we immediately filter it out and then store the whole row in an encrypted buffer on the local disk of that instance. That encrypted buffer later gets sorted and de-duplicated and then makes its way to your destination, still encrypted.