Loading Using the Web Interface (Limited)

The Snowflake web interface provides a convenient wizard for loading limited amounts of data into a table from a small set of flat files. Behind the scenes, the wizard uses the PUT and COPY commands to load data; however, the wizard simplifies the data loading process by combining the two phases (staging files and loading data) into a single operation and deleting all staged files after the load completes.

The instructions in this topic pertain to loading both structured data (e.g. CSV) and semi-structured data (e.g. JSON, Avro, ORC, Parquet, or XML).


The wizard is only intended for loading small numbers of files of limited size (up to 50MB). This file size limit is intended to ensure better performance because browser performance varies from computer to computer and between different browser versions. Also, the memory consumption required to encrypt larger files might cause a browser to run out of memory and crash.

For loading larger files or large numbers of files, we recommend using the Snowflake client, SnowSQL. For details, see Bulk Loading from a Local File System Using COPY.

In this Topic:

Step 1: Open the Load Data Wizard

  1. Click on Databases » Tables.
  2. Either:
  • Click on a table row to select it, then click the Load Data button.


  • Click a table name to open the table details page, then click the Load Table button.

The Load Data wizard opens. The wizard will load data into the table you selected.

Step 2: Select a Warehouse

  1. Select a warehouse from the dropdown list.

    The list includes any warehouse on which you have the USAGE privilege. Snowflake will use this warehouse to load data into the table.

    Warehouse screen in Load Data wizard
  2. Click Next.

Step 3: Select Source Files


Remember, the wizard is designed to load small amounts of data. Your individual data files should each be smaller than 50MB in size.

You can choose to load data from files on your local machine or files already staged in an existing Amazon S3 bucket.

Loading from Your Local Machine

  1. Select the Load files from your computer option, and click the Select Files button.

  2. Select one or more local data files, and click the Open button.

    Select local data files in Load Data wizard
  3. Click the Next button.

Loading from an S3 Bucket

  1. Select the Load files from S3 bucket option, and click the plus (+) symbol beside the dropdown list.

  2. Select the Existing Amazon S3 Location option, and click the Next button.

  3. Fill in the fields on the screen. The fields describe your S3 bucket.

    Create S3 (external) stage in Load Data wizard
  4. Click the Finish button.

  5. In the Path field, enter the path to your data files in the S3 bucket.

    Select S3 bucket and path in Load Data wizard
  6. Click the Next button.

Step 4: Select a File Format

The dropdown list allows you to select a named set of options that describes the format of your data files.

Selecting an Existing Named File Format

  1. If an existing file format describes your data files, select it from the list.
  2. Click the Next button.

Creating a New Named File Format

  1. Click the plus (+) symbol beside the dropdown list.

  2. Review the list of default file format options:

    • If the format of your data files matches the default options on the screen, click the Next button.

    • Otherwise, create a named file format:

      1. Fill in the fields on the screen to match the format of your data files. For descriptions of the options, see CREATE FILE FORMAT.

        Create file format in Load Data wizard
      2. Click the Finish button.

      3. Select your named file format from the dropdown list.

        Select file format in Load Data wizard
      4. Click the Next button.

Step 5: Select Load Options

  1. Specify how Snowflake should behave if errors in the data files are encountered.

    Choose load options in Load Data wizard
  2. Click the Load button.

    Snowflake loads the data into your selected table using the warehouse you selected.


    If the warehouse is not currently running, resuming the warehouse could take some time (up to 5 minutes), in addition to the time required for loading.

  3. Click the OK button.