Enforcing Unique key with a CTAS statement

Hi,

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.

Theo

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