Creating a hashdiff using SHA1 on azure synapse pipeline

Question

Hello,

We use the datavault methodology and I need to create a hashdiff, the issue is that it is too many columns and it is giving me an error on the sql code when I try to use the copy on the pipeline.

Is there a way another way to create the hashdiff? on ssis I use c#

thanks

Answer 1

Hello @Astrid Malanka ,
Thanks for the ask and welcome to Microsoft Q&A .

I am assuming that the ask here is how to use hashing in Analytics . The copy activity may be not the correct activity , if you use data flow , then you can use the CRC32/SHAI/SHA2

Please read about this more . [https://learn.microsoft.com/en-us/azure/data-factory/data-flow-expression-functions#expression-functions-list

Thanks
Himanshu