HASHBYTES in Azure Data Factory

Question

So we found this strange use case where result of function HASHBYTES with MD5 gives different output in COPY Data vs. ADF DataFlow using (MD5 function).

So Copy Data uses (allows) to leverage HASHBYTES(MD5, ), but Azure Data factory (ADF) DataFlow does not allow to use funciton HASHBYTES, instead it has MD5 function in Dynamic function list in Datflow, but output from both Copy Data and DataFlow from ADF is different.

Any thoughts ?

Regards, Viral

Answer 1

As per the Documentation and ADF expressions, there is no HASHBYTES function in ADF expressions or in copy activity. You can see the same here.

You can use hash functions only in ADF dataflow by using the functions like MD5 and SHA1.

So, use dataflow to achieve your requirement.