Hashing

Use hashing functions to hash string values in SQL queries using established hashing algorithms.

• digest
• md5
• sha224
• sha256
• sha384
• sha512

digest

Computes the binary hash of an expression using the specified algorithm.

digest(expression, algorithm)

Arguments

• expression: String expression to operate on. Can be a constant, column, or function, and any combination of operators.

• algorithm: String expression specifying algorithm to use. Must be one of the following:

  • md5
  • sha224
  • sha256
  • sha384
  • sha512
  • blake2s
  • blake2b
  • blake3

{{< expand-wrapper >}} {{% expand "View digest query example" %}}

The following example uses the NOAA Bay Area weather sample data.

SELECT DISTINCT
  location,
  digest(location, 'sha256') AS location_digest
FROM weather

{{% /expand %}} {{< /expand-wrapper >}}

md5

Computes an MD5 128-bit checksum for a string expression.

md5(expression)

Arguments

• expression: String expression to operate on. Can be a constant, column, or function, and any combination of operators.

{{< expand-wrapper >}} {{% expand "View md5 query example" %}}

The following example uses the NOAA Bay Area weather sample data.

SELECT DISTINCT
  location,
  md5(location) AS location_md5
FROM weather

{{% /expand %}} {{< /expand-wrapper >}}

sha224

Computes the SHA-224 hash of a binary string.

sha224(expression)

Arguments

• expression: String expression to operate on. Can be a constant, column, or function, and any combination of operators.

{{< expand-wrapper >}} {{% expand "View sha224 query example" %}}

The following example uses the NOAA Bay Area weather sample data.

SELECT DISTINCT
  location,
  sha224(location) AS location_sha224
FROM weather

{{% /expand %}} {{< /expand-wrapper >}}

sha256

Computes the SHA-256 hash of a binary string.

sha256(expression)

Arguments

• expression: String expression to operate on. Can be a constant, column, or function, and any combination of operators.

{{< expand-wrapper >}} {{% expand "View sha256 query example" %}}

The following example uses the NOAA Bay Area weather sample data.

SELECT DISTINCT
  location,
  sha256(location) AS location_sha256
FROM weather

{{% /expand %}} {{< /expand-wrapper >}}

sha384

Computes the SHA-384 hash of a binary string.

sha384(expression)

Arguments

• expression: String expression to operate on. Can be a constant, column, or function, and any combination of operators.

{{< expand-wrapper >}} {{% expand "View sha384 query example" %}}

The following example uses the NOAA Bay Area weather sample data.

SELECT DISTINCT
  location,
  sha384(location) AS location_sha384
FROM weather

{{% /expand %}} {{< /expand-wrapper >}}

sha512

Computes the SHA-512 hash of a binary string.

sha512(expression)

Arguments

• expression: String expression to operate on. Can be a constant, column, or function, and any combination of operators.

{{< expand-wrapper >}} {{% expand "View sha512 query example" %}}

The following example uses the NOAA Bay Area weather sample data.

SELECT DISTINCT
  location,
  sha512(location) AS location_sha512
FROM weather

{{% /expand %}} {{< /expand-wrapper >}}