Apply a hashing algorithm

This page explains how to apply a hashing algorithm to column values when you prepare data in the Wrangler workspace of the Cloud Data Fusion Studio.

In Wrangler, you can apply a hashing algorithm, such as SHA, to a column of values. The result is a unique, fixed-length string called the hash value or message digest.

When you apply the hash directive to a string column, Wrangler replaces the content of the column with the message digest. No new columns are created when you apply the hash directive.

You can choose to encode the message digest. If you encode the message digest, Wrangler encodes the values in the column as hex with left-padding zeros.

Cloud Data Fusion supports he following hashing algorithms in the Wrangler workspace:

  • BLAKE2B-160
  • BLAKE2B-256
  • BLAKE2B-384
  • BLAKE2B-512
  • GOST3411
  • GOST3411-2012-256
  • GOST3411-2012-512
  • KECCAK-224
  • KECCAK-256
  • KECCAK-288
  • KECCAK-384
  • KECCAK-512
  • MD2
  • MD4
  • MD5
  • RIPEMD128
  • RIPEMD160
  • RIPEMD256
  • RIPEMD320
  • SHA
  • SHA-1
  • SHA-224
  • SHA-256
  • SHA-384
  • SHA-512
  • SHA-512/224
  • SHA-512/256
  • SHA3-224
  • SHA3-256
  • SHA3-384
  • SHA3-512
  • Skein-1024-1024
  • Skein-1024-384
  • Skein-1024-512
  • Skein-256-128
  • Skein-256-160
  • Skein-256-224
  • Skein-256-256
  • Skein-512-128
  • Skein-512-160
  • Skein-512-224
  • Skein-512-256
  • Skein-512-384
  • Skein-512-512
  • SM3
  • Tiger
  • WHIRLPOOL

What's next