Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

What are Cryptographic Functions on Snowflake?

608 viewsSnowflake Functions and Procedures

What are Cryptographic Functions on Snowflake?

Daniel Steinhold Answered question July 31, 2023

In Snowflake, cryptographic functions are a set of built-in functions that enable data encryption, decryption, hashing, and other cryptographic operations. These functions can be used to enhance the security and privacy of data stored in Snowflake.

Here are some common cryptographic functions available in Snowflake:

1. Encryption Functions:
- ENCRYPT: This function encrypts a given input using a specified encryption algorithm and key.
- DECRYPT: It decrypts an encrypted input using the corresponding encryption algorithm and key.
2. Hashing Functions:
- HASH: This function computes a cryptographic hash value for a given input using a specified algorithm, such as SHA-256 or SHA-512.
- HMAC: It computes a Hash-based Message Authentication Code (HMAC) using a specified algorithm and key.
3. Key Management Functions:
- CREATE_KEY: This function generates a new encryption key that can be used with encryption functions.
- ENCRYPT_AES: It encrypts a given input using the Advanced Encryption Standard (AES) algorithm and a specified encryption key.
- DECRYPT_AES: It decrypts an input encrypted with the AES algorithm using the corresponding encryption key.
4. Secure Random Number Generation:
- RANDOM_UUID: This function generates a random universally unique identifier (UUID) value.

These cryptographic functions allow Snowflake users to protect sensitive data by encrypting it before storing it in the database. This helps prevent unauthorized access to the data even if the underlying storage or infrastructure is compromised. Additionally, the hashing functions can be used for data integrity checks and verifying the authenticity of data.

It's important to note that cryptographic functions in Snowflake operate on the server-side, meaning the encryption and decryption operations are performed within the Snowflake infrastructure. This ensures that the data remains secure even during transit and while being processed within Snowflake's distributed architecture.

Daniel Steinhold Answered question July 31, 2023

Maximize Your Data Potential With ITS

Feedback on Q&A