TEXT column type converts to VARCHAR(256) in Redshift, resulting in failed INSERTS if the data contains more than 256 characters in that column.
To address this issue, I replaced "TEXT" with "VARCHAR(MAX)" in the DDL. Would be nice to have the ability to specify this automatically in the API.
TEXT column type converts to VARCHAR(256) in Redshift, resulting in failed INSERTS if the data contains more than 256 characters in that column.
To address this issue, I replaced "TEXT" with "VARCHAR(MAX)" in the DDL. Would be nice to have the ability to specify this automatically in the API.