Snowflake – Load Local CSV File as Table into a SF Database

Data loading overview

Step 1

Upload (i.e. stage) one or more data files to a Snowflake stage (named internal stage or table/user stage) using theΒ PUTΒ command.

Step 2

Use the COPY INTO <table> command to load the contents of the staged file(s) into a Snowflake database table.

Regardless of the stage you use, this step requires a running virtual warehouse that is also the current (i.e. in use) warehouse for the session. The warehouse provides the compute resources to perform the actual insertion of rows into the table.

Leave a Reply