'Column level encryption in Snowflake
I know Snowflake by default encrypts data at rest. But I wanted to know if there is a built-in feature to encrypt a column value and store it in Snowflake tables. Or is it something that I need to code using snowpark and store as a procedure.
Solution 1:[1]
I would recommend that you read up on the Dynamic Data Masking that is available natively in Snowflake, which allows you to encrypt data to specific roles or all roles, as needed. And if there in an external encryption tool via API that you'd like to use, Dynamic Data Masking can leverage that API via an External Function. You shouldn't need Snowpark or a Stored Procedure to accomplish this.
https://docs.snowflake.com/en/user-guide/security-column-ddm.html
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Mike Walton |