Enforcing Unique key with a CTAS statement

Theo · May 4, 2020, 6:49pm

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

ben · May 4, 2020, 9:02pm

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.

Topic		Replies	Views
Creating Persistent Data Sets	2	1148	October 23, 2020
Support for Create table as Select (CTAS)	6	4674	May 3, 2018
Unique Identifier on Dremio	2	1485	November 18, 2020
Create table as SELECT does not create table, if result is empty	1	994	March 25, 2022
Primary Key or avoid duplicate records	3	1892	September 11, 2023

Enforcing Unique key with a CTAS statement

Related topics