I have a process flow that queries a SQL db and can generate a data set that will be written to another SQL db. I'd like to add a primary key or at the very least, a unique index, such that when my SQL table is loaded, it will reference the pk.
Is this possible? If so, can it be done in Query Builder or do I have to add that syntax in proc sql?