Loading Data from Microsoft Azure Using COPY

If you already have a Microsoft Azure account and use Azure containers for storing and managing your data files, you can make use of your existing containers and folder paths for loading data into Snowflake.

Note

Snowflake currently supports loading from/unloading to Blob storage only.

Loading from block, append, and page blobs is supported. Unloaded files are created as block blobs. For information about these blob types, see the Azure documentation on blob types.

This set of topics describes how to use the COPY command to load data from an Azure container into tables.

Data loading overview

As illustrated in the diagram above, loading data from an Azure container is performed in two, separate steps:

  1. Upload (i.e. stage) one or more data files into an Azure container using the upload interfaces/utilities provided by Microsoft.

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

    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.

Note

The instructions in this set of topics assume you have read Preparing to Load Data and have created a named file format, if desired.

Tip

Before you begin, you may also want to read Data Loading Considerations for best practices, tips, and other guidance.

Configuration tasks (complete as needed):

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