Can Fivetran Conditionally Hash PII Data?

Question

Can Fivetran apply hashing to personally identifiable information (PII) only when certain conditions are met, such as when the data originates from a specific source type?

Environment

All connectors

Answer

We support column hashing using SHA-256, but we don't provide a built-in way to apply hashing conditionally based on a join with another table. For more information, see our Data Blocking and Column Hashing documentation.

However, you can achieve this by doing the following:

1. Load both the PII data and the source type table into your destination.
2. Use SQL to create a transformation that joins the PII data table with the source type table and applies hashing only when necessary. For example, you can use a CASE statement to hash values based on specific conditions, such as the source type.
3. Schedule this transformation to run after Fivetran syncs new data.