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.


Hi @mgct, what about the undocumented md5 function ?

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


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