When you try to insert a record to an Amazon Redshift table which has a column with attribute IDENTITY(seed, step), the record is inserted fine, but the value of the first column to be inserted is null instead of the value being passed into the Output Data tool.
View full article