Loading data using the web interface¶

Access control privileges¶

Snowsight does not support using database roles to grant privileges on a database, schema, or table. Use an account role to interact with Snowsight. For more information, see types of roles.

Load a file into an existing table¶

1. Sign in to Snowsight.

2. In the navigation menu, select Data » Add Data.

3. On the Add Data page, select Load data into a Table.

   The Load Data into Table dialog appears.

4. In the Load Data into Table dialog, select the database, schema, and table where you want to load data.

5. Select Browse to add a file from your local machine, Drag and drop to upload files, or Add from stage.

   If you select Add from stage, the stage explorer will appear. In the stage explorer, you can navigate into stages and subfolders and select specific folders and files from the stage. If you select Add without selecting any specific files on the stage, the root stage, which includes all the files and folders on the stage, will be added.

   The maximum number of files that can be shown in a stage folder is 250.

6. After adding files, select Next. The table schema dialog appears.

7. In the table schema dialog, do the following:

   • Select a file format from the current database.

   • Select a file type to customize, and then select the relevant settings for your data file.

     Note

     To load Parquet data into a Snowflake-managed Iceberg table, deselect Load as a single variant column?. Snowflake loads Parquet data directly into Iceberg table columns. Only the default LOAD_MODE = FULL_INGEST is supported when you use Snowsight to load Parquet files. For more information, see COPY INTO <table>.

   • (Optional) Select what should happen if an error occurs during loading. By default, no data is loaded from the file.

   • Select one of the Match by column names options to automatically match the source file and the target table. The default option is case insensitive.

     Note that schema detection and visual column mapping does not support XML.

   • Select the Edit Schema tab on the right side of the table schema dialog. You can see any discrepancy between the source file and the target table. Make adjustments as needed.

   • If you select the Table Preview tab, you can preview how the data of the incoming source file will look in the target table.

8. Select Load.

   Snowsight loads your file and displays the number of rows successfully inserted into the table.

Create a table when loading a file¶

You can create a new table when loading a file by taking the following steps.

1. Sign in to Snowsight.

2. In the navigation menu, select Create » Table » From File.

   The Load Data into Table dialog appears.

3. In the Load Data into Table dialog, select or create a database and schema where you want the table to be created.

4. Select Browse to add a file from your local machine, Drag and drop to upload files, or Add from stage.

   If you select Add from stage, the stage explorer will appear. In the stage explorer, you can navigate into stages and subfolders and select specific folders and files from the stage. If you select Add without selecting any specific files on the stage, the root stage, which includes all the files and folders on the stage, will be added.

   Note that the maximum number of files that can be shown in a stage folder is 250.

5. Enter a name for the new table and then select Next.

   Snowsight detects the metadata schema for the file and returns the file format and column definitions identified by the INFER_SCHEMA function.

6. Review the inferred file format, data type, column name, and a sample of column data. Ensure all information is accurate and make updates if needed.

7. Select Load.

   Snowsight loads the file and creates a new table for the file.

Prerequisites for loading data¶

Before you start loading data using Classic Console, do the following:

• Identify the location your data files. You can load data from one of the following:

  • Your local machine.

  • An internal or external stage.

  • A cloud storage location on Amazon S3, Google Cloud Storage, or Microsoft Azure that is not yet added to Snowflake as an external stage.

• Determine the size of your data files. Each file that you load can be up to 250 MB. If you want to load larger files, or large numbers of files, use the Snowflake client, SnowSQL, instead. Refer to Bulk loading from a local file system.

The role that you use to load data must have appropriate privileges:

• To load data, your role must have the USAGE privilege on the database and the schema that contain the table that you load data into.

• To create a stage when you load data, your role must have the CREATE STAGE privilege on the database schema.

• To create a file format when you load data, your role must have the CREATE FILE FORMAT privilege on the database schema.

Start loading data¶

To start loading a file into a specific table, do the following:

1. Select Databases .

2. Select a specific database and schema.

3. Select the Tables tab.

4. Locate the table into which you want to load data.

5. Start loading data into a specific table by doing one of the following:

   • Select a table row, then select Load Data.

   • Select a table name to open the table details page, then select Load Table.

   The Load Data wizard opens.

6. Select a warehouse to use to load data into the table. The drop-down includes any warehouse on which you have the USAGE privilege.

7. Select Next.

Select the data to load¶

Depending on where you choose to load data from, follow the relevant steps. If you want to load data from multiple locations, use the Load Data wizard multiple times.

To load data from your computer:

1. Select the Load files from your computer option, and select Select Files to browse to the files that you want to load.

2. Select one or more local data files and select Open.

3. Select Next.

To load data from an existing stage:

1. Select the Load files from external stage option.

2. Select an existing stage from the Stage dropdown list.

3. (Optional) Specify a path to the files in the stage.

4. Select Next.

To create a stage, for example to load data from external cloud storage:

1. Select the Load files from external stage option.

2. Select the + next to the Stage dropdown list.

3. Select the supported cloud storage service where your files are located.

4. Select Next.

5. Complete the fields to describe your stage. For more information, refer to CREATE STAGE.

6. Select Finish.

   Your new stage is automatically selected from the Stage dropdown list.

7. (Optional) Specify a path to the files in the stage.

8. Select Next.

Finish loading data¶

After you select the files to load, finish loading data into your table.

To finish loading data, do the following:

1. Select an existing named file format from the dropdown list, or create one.

   To create a file format:

   1. Select the + next to the dropdown list.

   2. Fill in the fields to match the format of your data files. For descriptions of the options, refer to CREATE FILE FORMAT.

   3. Select Finish.

   Your new named file format is automatically selected from the dropdown list.

2. Determine how you want to handle errors that occur when the data is loaded:

   • If you want data loading to stop if an error occurs, select Load.

   • If you want errors to be handled in a different way:

     1. Select Next.

     2. Select the option that describes how you want to handle errors. For details about the options, refer to the ON_ERROR section of COPY INTO <table>.

     3. Select Load.

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

3. Select OK to close the Load Data wizard.