The driver supports using the COPY command for loading and unloading data from local file systems and cloud platforms, such as Amazon S3, Google Cloud, and Microsoft Azure. The data is moved from staged files to an existing table and vice versa.

Snowflake supports the following stages for loading and unloading of files.

  • User: This stage is used for files that are accessed by a single user and copied into multiple tables.
  • Table: This stage is used for files that are accessed by multiple users and copied into a single table.
  • Internal Named: This stage is used for named database objects that provide flexibility and security during data loading.

The driver supports all the copy options and format type options supported by Snowflake. The process of data loading and unloading depends on your environment. Refer to the following topics in your Snowflake documentation for further details.