loadsnowflake-cloud-data-platformloaddata

Why does my Snowflake Table load keep failing?


Just created a trial Snowflake account, created a simple (17 column) table.

Tried to import csv into it.

Every time I try I get a 'Staging error': "There was an error while trying to stage "[filename]". Reason: Maximum file size exceeded."

True, the main file I want is 4GB, but I keep cutting it down to smaller sizes (last one is 72mb) and still get the same error.

Yes, of course I could make the file even smaller, but already missing the point of using the system! If I can't load my data, what's the point of the db..?

I'm sure there is something simple and obvious I'm missing, but I don't know what that is.

Thanks in advance for any help.


Solution

  • You forgot to mention which loading method you're trying to use. Looking at what you're saying I suspect you're trying to import the file via the web interface, and that's only intended for small files (up to 50mb). If you want to import a bigger file (or multiple files) you should go with bulk load using COPY (this can have different scenarios depending on the cloud you use):

    https://docs.snowflake.net/manuals/user-guide/data-load-bulk.html