Alter table to create IDENTITY
I am relatively new to Vertica so pardon if my question seems basic...
I loaded a Vertica table and I am trying to ALTER a column to IDENTITY.
I know you simply cannot turn the IDENTITY on/off in Vertica like SQL server, but my idea is to load the table first and then set the identity. Is this possible? Is this best practice?
Thank you all in advance.