Enforcing Unique key with a CTAS statement


I am creating tables using the latest CTAS functionality. Is there a way to enforce a unique key constraint when creating the table? Thanks in advance.


Hello @Theo,

Dremio does not have any functionality to produce GUIDs or IDs unique to the scope of a dataset. In your CTAS-based dataset, you would want to refer some column in the source datasets that you are selecting from to provide the uniqueness.

1 Like