tdcrypto /

Filename Size Date modified Message
836 B
1.4 KB
4.2 KB
6.5 KB
248 B
254 B
253 B
4.9 KB
6.6 KB
5.0 KB
10.4 KB
92 B
1.9 KB


Teradata cryptographic UDFs. Currently BLAKE2 is being used as the underlying cryptographic function.


You'll need CREATE FUNCTION privilege on database or the user that'll own the UDFs. You'll also need ALTER FUNCTION privilege if you want to alter the UDFs execution mode from protected to not protected.

  • Switch to the repo directory.
  • Set appropriate default database if UDFs need to be owned by a specific User or Database.
  • If UDFs will be run in PROTECTED execution mode, edit CryptoHash.sql file and comment out the ALTER FUNCTION statements.
  • Run CryptoHash.sql file.


Note: The UDF parameter must be be either VARCHAR or VARBYTE.

SELECT InfoKey, InfoData, CryptoHash(InfoData) AS HashedData