I am trying to insert a dataframe into a table in snowflake database, using DBI:: dbAppendTable() via R studio. The number of rows in datafarme are 5000. I get above error only when I am loading all 5000 rows altogether. The query fails after inserting 1024 rows in the table. It doesn't fail if I load using a loop for batches of size say 100. My string size also doesn't go beyond VARCHAR column size. I have never seen this error with snowflake. Hoping if someone has any insight on this.