Output To Insert Table with Serial Primary Key

Stephanus Adisuprijanto shared this question 22 months ago
Answered

Is it possible to output the transformation flows to a table with serial primary key?

Comments (2)

photo
1

Hi Stephanus,

It is possible to set primary keys in the output step when creating new tables, but there is currently no function to make automatically include a serial primary key. You could use something like the R step to create this manually, or code your own step in Java (though the documentation is not currently ready for this).

Alternatively we could put together an auto increment step for this use case, which would be a pretty quick process but would fall more under paid services.

Let me know your thoughts.

Regards,

Nathan

photo
1

I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!


Regards,

Nathan