Primary Key for "create new table" option of Output tool

[RyanNewsome]

It would be good to have the ability to select what column to use for Primary key when using the "create new table" output option of the output data tool.

When using the "update: insert if new" output option, you receive the error "Primary Key required for Update" if table does not have primary key.

Workaround is to manually create table with primary key constraint.

[Olav_Amlie]

Having more control over table creation would be great. Further, the ability to select a Primary key column can be extended to database Updates: There are situations where the destination table does not contain a properly defined Primary key, however, one still may want to update rows based on a column not defined as a Primary key. The table may be part of an application where modifying properties is not possible.

[ARich]

Hi All,

Thanks for the feedback. Please continue to upvote if you're interested.

Best,

Alex

[kcastillo0319]

I also would like to see this feature.

[cheerspankaj]

Hi,

Is there any update on this feature ( the output data tool works for oracle DB table, where we can define primary key).

In my case I am looking to write to Hive table and cannot have primary key on it.

Thanks,

Pankaj