Syntax¶

SHA1(<msg>)SHA1_HEX(<msg>)

Arguments¶

msg

A string expression, the message to be hashed.

Returns¶

The data type of the returned value is VARCHAR.

Usage notes¶

• The SHA1 family of functions is provided primarily for backwards compatibility with other systems.For more secure encryption, Snowflake recommends using the SHA2 family of functions.

• Do not use this function to encrypt a message that you need to decrypt. This function has no corresponding decryption function.(The length of the output is independent of the length of the input. The output does not necessarily have enough bits to holdall of the information from the input, so it is not possible to write a function that can decrypt all possible valid inputs.)

  This function is intended for other purposes, such as calculating a checksum to detect data corruption.

  If you need to encrypt and decrypt data, use the following functions:

  • ENCRYPT andDECRYPT

  • ENCRYPT_RAW andDECRYPT_RAW

Examples¶

SELECTsha1('Snowflake');------------------------------------------+SHA1('SNOWFLAKE')             |------------------------------------------+fda76b0bcc1e87cf259b1d1e3271d76f590fb5dd |------------------------------------------+

The data type of the output is string (VARCHAR) and can be stored in aVARCHAR column:

Create and fill a table:

CREATETABLEsha_table(vVARCHAR,v_as_sha1VARCHAR,v_as_sha1_hexVARCHAR,v_as_sha1_binaryBINARY,v_as_sha2VARCHAR,v_as_sha2_hexVARCHAR,v_as_sha2_binaryBINARY);INSERTINTOsha_table(v)VALUES('AbCd0');UPDATEsha_tableSETv_as_sha1=SHA1(v),v_as_sha1_hex=SHA1_HEX(v),v_as_sha1_binary=SHA1_BINARY(v),v_as_sha2=SHA2(v),v_as_sha2_hex=SHA2_HEX(v),v_as_sha2_binary=SHA2_BINARY(v);

Copy

Here are the query and output:

SELECTv,v_as_sha1,v_as_sha1_hexFROMsha_tableORDERBYv;+-------+------------------------------------------+------------------------------------------+| V     | V_AS_SHA1                                | V_AS_SHA1_HEX                            ||-------+------------------------------------------+------------------------------------------|| AbCd0 | 9ddb991863d53b35a52c490db256207c776ab8d8 | 9ddb991863d53b35a52c490db256207c776ab8d8 |+-------+------------------------------------------+------------------------------------------+

Copy