Hello, I’m trying to implement an auto-incrementing integer using Redshift. The changelog looks something like this
- column:
name: account_id
type: int
incrementBy: 1
autoIncrement: true
constraints:
primaryKey: true
nullable: false
unique: true
The output is being converted to
CREATE TABLE public.xxx (account_id SERIAL NOT NULL, ...
Is there any secret to keeping this from converting the identity column to serial which is not supported in Redshift using the Redshift extension?