Unique Identifier on Dremio

We need to create a unique identifier for each entry, we currently use newid() on our SQL Server.

Since Dremio does not support this, can you please give us an alternate solution that is supported by Dremio.

Thanks

Hi @mgct, what about the undocumented md5 function ?

SELECT MD5('something_to_hash') ==> 1bc29b36f623ba82aaf6724fd3b16718

@mgct

Have you tried External query feature in 4.8? Should support newid() in the query