03 Jun 2019 | Announcement

New Feature: Column Hashing

Ciara Rafferty
Ciara Rafferty
New Feature: Column Hashing
Column hashing allows you to anonymize personally identifiable information while preserving its analytical value, keeping you GDPR-compliant.

With the Fivetran column blocking feature, you can block specific columns from replicating to your warehouse. Now, with our column hashing feature (in beta), you can join across data sets without introducing sensitive data into your data warehouse.

What Is Column Hashing?

Hashing is a one-way operation, unlike encryption, which involves both encryption and decryption. Once data is hashed, it cannot be returned to its previous state. As a result, you can use column hashing to anonymize warehouse data, such as personally identifiable information (PII), and bring your organization into compliance with GDPR.

Anonymizing data is also helpful from an analytical perspective. Because the hashed result is the same across data sources, you can still join on key fields, such as email addresses, without the risk of exposing PII.

How Do I Set It Up?

It’s as simple as going into the connector detail view in your dashboard and selecting the columns you want to hash. Currently, hashing is available for the following connectors: Dynamics 365, Marketo, MariaDB, MySQL, NetSuite, Oracle, Postgres, Salesforce, ServiceNow, SQL Server and Zuora.

Screenshot

The next time your data syncs, Fivetran will ingest your data, hash it, and write the hashed data to your warehouse. 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 Fivetran algorithm.

We hope this feature enables you to conduct even stronger analyses of your data. If you have any questions or wish to beta test our column hashing feature, feel free to reach out to our sales team.

Are You A Data Expert?

Start a free trial today.

Discover the smartest solution for data-driven results.
We have detecting that you are using an adblocking plugin in your browser. We don't show ads, but we rely on advertising services, so it might restrict you from completing important functions or seeing important content. Please make sure you whitelist our website in your adblocking plugin.
Fivetran uses cookies to enhance your user experience and improve the quality of our website. Unless you disable cookies, you consent to the placement and use of cookies as described in our Privacy Policy by continuing to use this website.
Adblock Detection