• Read
  • Discuss

Another option for loading data into Snowflake is the data loading wizard in the Snowflake Web Interface.

You can easily load a small amount of data into Snowflake using the Web UI by selecting the table you wish to load and then clicking the LOAD button.

The traditional web interface offers a handy wizard for loading small quantities of data from a handful of flat files into a table. In reality, the wizard loads data using the PUT and COPY commands. However, the wizard streamlines the data loading procedure by combining the two steps (staging files and loading data) into a single operation and deleting all staged files after the load completes. 

The wizard is intended to load just a few files with a minimal amount of data. It is recommended to choose other options for huge amounts of data.

Step 1: Opening the Load Data Wizard

  1. Click on Databases .
  2. Click on the link for a specific database to view the objects stored in the database.
  3. Click on the Tables tab.
  4. 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: Selecting 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.

  1. Click Next.

Step 3: Selecting Source Files

You can choose to load data from files on your local machine or files already staged in an existing cloud storage location on Snowflake, Amazon S3, Google Cloud Storage, or Microsoft Azure.

Loading From Your Local Machine

  • Select the Load files from your computer option, and click the Select Files button.
  • Select one or more local data files, and click the Open button.
  • Click the Next button.

Loading from Cloud Storage

Choosing an Existing Stage

  1. Select an existing named stage from the Stage dropdown list.
  2. Click the Next button.

Creating a New Stage

Complete the steps in this section once per storage location.

  1. Click the plus (+) symbol beside the Stage dropdown list.
  2. Select the location where your files are located: Snowflake or any one of the supported cloud storage services, and click the Next button.
  3. Complete the fields that describe your cloud storage location. For more information, see CREATE STAGE.
  4. Click the Finish button.
  5. Select your new named stage from the Stage dropdown list.
  6. Click the Next button.

Step 4: Selecting a File Format

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

Choosing an Existing Named File Format

  1. Select an existing named file format from the dropdown list.
  2. Click the Next button.

Creating a New Named File Format

  1. Click the plus (+) symbol beside the dropdown list.
  2. Fill in the fields on the screen to match the format of your data files. 
  3. Click the Finish button.
  4. Select your new named file format from the dropdown list.
  5. Click the Next button.

Step 5: Selecting Load Options

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

  1. Click the Load button.
  2. Snowflake loads the data into your selected table using the warehouse you selected.
  3. Click the OK button. The load data wizard closes.

Leave a Reply

Leave a Reply

Scroll to Top