New Feature: Column Hashing

Fivetran's column hashing feature allows users to anonymize personally identifiable information while preserving its analytical value, ensuring GDPR compliance. Hashing is a one-way operation that cannot be reversed and can be used to anonymize data such as PII in the warehouse. The feature enables joining across datasets without exposing sensitive data. To set it up, users need to select the columns they want to hash in the connector detail view. Currently, hashing is available for several connectors including Dynamics 365, Marketo, MariaDB, MySQL, NetSuite, Oracle, Postgres, Salesforce, ServiceNow, SQL Server and Zuora. Fivetran adds an extra layer of security by using a unique salt per warehouse to ensure that the data cannot be decoded based on knowledge of the default algorithm.