HomepageData + AI Summit 2022 Logo
Watch on demand

Protecting Personally Identifiable Information (PII)/PHI Data in Data Lake via Column Level Encryption

On Demand


  • Session


  • Hybrid


  • Industry and Business Use Cases


  • Finanzdienstleistungen


  • Intermediate


  • Moscone South | Upper Mezzanine | 159


  • 35 min
Download session slides


Data breach is a concern for any data collection company including Northwestern mutual. Every measure is taken to avoid the identity theft and fraud for our customers; however they are still not sufficient if the security around it is not updated periodically. A multiple layer of encryption is the most common approach utilized to avoid breaches however unauthorized internal access to this sensitive data still poses a threat
This presentation will walk you following steps:
- Design to build encryption at column level
- How to protect PII data that is used as key for joins
- Ability for authorized users to decrypt data at run time
- Ability to rotate the encryption keys if needed
At Northwestern Mutual, a combination of Fernet, AES encryption libraries, user-defined functions (UDFs), and Databricks secrets, were utilized to develop a process to encrypt PII information. Access was only provided to those with a business need to decrypt it, this helps avoids the internal threat. This is also done without data duplication or metadata (view/tables) duplication.
Our goal is to help you understand on how you can build a secure data lake for your organization which can eliminate threats of data breach internally and externally.
Associated blog: https://databricks.com/blog/2020/11/20/enforcing-column-level-encryption-and-avoiding-data-duplication-with-pii.html

Session Speakers

Keyuri Shah

Lead Engineer

Northwesternmutual Insurance

Chandiprasad Chintalapati

Senior Software Engineer

Northwestern Mutual

Das Beste des Data+AI Summits anzeigen

Watch on demand