Writing to Snowflake | Truncated string fields | String data truncated

Hey there,

I'm currently trying to write some data into Snowflake from Alteryx

I have both Strings and Double data

However when writing in-DB I have the following error message on the Data Stream-In Tool:

"DataWrap2ODBC::SendBatch: [Snowflake][Support] String data truncated while performing conversion.

I am writing to a table that I Overwrite at each run.

I tried to deselect all the string fields, and everything worked perfectly. Data is written into Snowflake as it should be.

I then Auto fielded the colums to reduce the size. I can now write a string field, size 10 into Snowflake.

However, the second shortest string field I have, size 20, seems to trigger the error.

In Snowflake, I can see that the table created has created this field as a VARCHAR(20) but the table is empty

Has anyone any ideas on how to workaround this?

Thanks

Output

In Database

In-Database

Accepted answers

JeremyGonzva

Increasing the size by 1 after the autofield worked.

Example: If autofield set the size to 20, I set it to 21 with a select tool just after

I still have no idea on why this error occured but I don't have it anymore and everything is fine on Snowflake

All comments

JeremyGonzva

Increasing the size by 1 after the autofield worked.

Example: If autofield set the size to 20, I set it to 21 with a select tool just after

I still have no idea on why this error occured but I don't have it anymore and everything is fine on Snowflake

steven4320555

I encountered the same error message when working with Hive database, however, changing string length did not help.

As @JeremyGonzva Alteryx only through out the error when the string that to be streamed in to hive database exceeds certain threadhold (which is not too big, as theoretically, string in hive can be 2GB).

So my question is: is this a bug of Alteryx?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703