ALTR and Matillion Data Sheet
Written by:
No items found.

How ALTR and Matillion Enable Secure Data Migration to Snowflake

Download eBook

Get started for Free
Learn More

Matillion and ALTR have partnered to enable you to easily migrate sensitive data to Snowflake and operate on that data while keeping it protected. Here’s an example setup to illustrate how the integration works. If any sensitive data migrated to Snowflake needs to be transformed -- cleansed, standardized, etc. -- it can be detokenized, viewed and transformed in Matillion by an authorized user and tokenized again with ALTR.

Initial Setup

Before migrating data to Snowflake, ALTR sets access permissions for the sensitive columns that Matillion will be loading. This ensures that no role other than the Matillion role has access to data as it’s being tokenized. Additionally,ALTR sets a read rate limit of 0 reads allowed on sensitive columns, limiting Matillion’s role to write-only capabilities and setting up an alert if the role ever tries to read sensitive data. Lastly, ALTR does not set up detokenization of sensitive data at this time. Once tokenized, no one can see raw data in the clear.

ETL & Tokenization

Using Matillion, data is loaded into a staging database in Snowflake as usual, with one change: Matillion is configured to call ALTR when sensitive columns are loaded so ALTR can tokenize the data.As data is loaded into Snowflake, ALTR tokenizes the data in real-time. Once loaded and tokenized, data can be copied into production databases to be operated on.


ALTR uses deterministic tokenization, which means tokens can be operated on without needing to be detokenized.This means your users can analyze and join tables based on tokenized columns without ever needing to see the underlying data. If a user or role does need access to the detokenized sensitive data, ALTR can allow locked down access which includes auditing of every access and rate limiting of reads to prevent data theft or accidental exposure.


This process is simple and effective, so you don’t need to spend a ton of time implementing and maintaining it. WithALTR and Matillion, you can safely and easily migrate your sensitive data to Snowflake and operate on that data at cloud scale.

No items found.
No items found.

Related Resources