Data Transformation - Hashing a column value

[JCJnr]

Hi

Currently the option exist to transform a column value by using the "HASH-SHA256" function.

I need to understand what level of Hashing is this? SHA1, SHA2 or SHA3?

If it is not SHA3, when could we expect something like this to be available.?

If not available at all, what are my options?

[Heinvandenheuvel · Accepted solution]

SHA256 is member of the SHA-2 family. See: https://en.wikipedia.org/wiki/SHA-2

IMHO Replicate need not and should not add other hash functions as it wil never be good enough for everyone.

The Replicate documentation does not suggest or claim its main objective is a high security function judging by the wording.  "The function is especially useful for masking sensitive information. In the expression below, for example, the Hash function has been used to obfuscate employees' email addresses."

If this function is not deemed adequate, then you may want to consider integrating your own vetted code with Replicate through a User Defined Function transformation. Those are a bit tricky to configure for a first time, so you may want to engage Professional Services for that.

Hein.