Hi all, How to load the data into red shift tables with identity column. I am getting below error. Exception in component tRedshiftOutput_1 org.postgresql.util.PSQLException: ERROR: cannot set an identity column to a value Thanks, Raja.
Identity columns are typically columns which should not be written by the insert statement instead the value will be taken from an implicit sequence by the database it self. You should remove this column from the schema and let the database fill this column.