Loading Data Using SnowSQL

Data loading is performed in two separate steps:

  1. Upload (i.e. stage) one or more data files into either an internal staging location (i.e. within Snowflake) or an external staging location. The method you use for staging the files depends on whether you are using an internal or external location.
  2. Load the contents of the staged file(s) into the target table.

This set of topics describes how to use SnowSQL, the Snowflake command line interface (CLI), to perform these two tasks, as well as describes the configuration tasks associated with loading data. The information in these topics pertains to both structured and semi-structured data.


Before you begin, you may also want to read Data Loading Considerations for best practices, tips, and other guidance. And, for complete examples that take you step-by-step through the data loading process, see any of the provided tutorials:

Configuration tasks (complete as needed):

Data loading tasks (complete for each set of files you load):