Loading Data Using the Web Interface (Limited)

The Snowflake web interface includes a convenient wizard for loading limited amounts of data into a table from a small set of flat files. 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 both structured and semi-structured data.

Important

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. Browser performance may vary from computer to computer and between different browser versions. The memory consumption required to encrypt larger files can cause a browser to run out of memory and crash.

For loading larger files or large numbers of files, we recommend using one of the Snowflake clients (e.g. SnowSQL). For details, see Loading Data Using SnowSQL.

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.

    or

  • 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

Important

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.

    Note

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

  3. Click the OK button.