Adding to this we are connecting to a AWS redshift DB, the issue seems to be when the CSV import tries to import a VARCHAR. ie. using a very basic file that contains

VAR
1

it loads, but if it contains

VAR
far

it doesn't and produces the error mention by Kathryn

Cheers

Barry

Hi Kathryn & Barry,

This could be a known issue (175209) that was fixed in the October build of YF 7.1, so if you upgrade to the latest patch then hopefully the issue will be resolved.

And if for some reason you can�t immediately upgrade then for a workaround what you can do is to reconfigure your Redshift data source to use the PostgreSQL driver instead of the Redshift one then you should be able to import the CSV file into your Redshift data source.

By the way, the issue is caused by a LIMIT being appended to the query sent to the database rather than the database�s meta-data MAXROW being used

Please let us know how this goes.

regards,
Dave