md5 or sha1 in beast mode

Gijs

Does beast-mode support functions like md5 or any alternative?

Gijs

We need some unguessable verification-key, for deeplinking back to our plaform.

We did that by concat some fields and md5 it, but that does not work in beast mode.

 

the MYSQL dataflow will take too long to run on each dataset update. 

 

im now looking into storing a random verification-key in our db and include that in the ETL,

 

but im open for suggestion might you have it!

Jamie

Hi,

 

I don't believe either of those fuctions are valid in the beastmode syntax.

You can however use both MD5 and SHA1 in a MySQL Dataflow.

 

Additionally, it is possible to encrypt data when importing via workbench - if this was your goal.

https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Encrypting%2C_Decrypting%2C_and_Hashing_Workbench_5_Data

 

Thanks,

Jamie.

jaeW_at_Onyx

What would you use it for?

Gijs

We need some unguessable verification-key, for deeplinking back to our plaform.

We did that by concat some fields and md5 it, but that does not work in beast mode.

 

the MYSQL dataflow will take too long to run on each dataset update. 

 

im now looking into storing a random verification-key in our db and include that in the ETL,

 

but im open for suggestion might you have it!

jaeW_at_Onyx

can you concat / process the data as you push it into Domo?  I.e. apply the MD5 processing during ingestion instead of trying to display in Analyzer / in ETL?

Gijs

Thanks for your suggestion! we gonna store it with our own data-store and ship it with the ETL.