Alteryx keep throwing error STRING TRUNCATION error

[komalkk]

Hi - I have been trying to write data onto snowflake and alteryx keeps throwing this error. I tried changing the data type and size of the columns but nothing is working. Can someone please provide insight to troubleshoot this error? Thanks

DataWrap2ODBC::SendBatch: [Snowflake][Support] (40465) String data truncated while performing conversion.

[Reddy4]

Try changing all string fields size to less than 255.

[DataNath]

I believe you’ll need to increase the default string length size in your ODBC/driver settings.

[BrandonB]

To @DataNath's point, you can see the driver setting information here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Writing-to-Snowflake-Truncated-string-...