canvas-data-sdk icon indicating copy to clipboard operation
canvas-data-sdk copied to clipboard

Published 20 hours ago • verified publisher icon Harvard-University-iCommons

Adapt column types for Redshift

Open jeremyajohnson opened this issue 6 years ago • 0 comments

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.

jeremyajohnson avatar Mar 21 '18 22:03 jeremyajohnson