OSError(28, 'No space left on device') error in Snowflake while loading big file

Question

I am getting error OSError(28, 'No space left on device') while copying 15 GB zip file into snowflake AWS, via snowsql. Can someone help me to understand this error and how to avoid it.

enter image description here

My VM has multiple disk, except root all other mapped drive have minimum 210 GB of storage available. Tried to set export TEMPDIR=/backups2 but that didn't worked. Any suggestions

Answer 1

There is a limit to the file size you can use with the PUT command. The recommendation is to split the file into small data files ranging in size from roughly 100 to 250 MB compressed and upload them in parallel.

Check the document here: https://docs.snowflake.com/en/sql-reference/sql/put.html