Solved! Go to Solution.
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
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?
Good news, I have sorted it out. The solution is to go to Simba Driver setting-> advanced option: Increase the default string column length from 255 to a large number.
It is not an Alteryx problem, but a driver setting problem for my case.