# Snowflake - Bulk load to table from stage

Load a file from a Snowflake stage into a target table. This action uses the COPY (opens new window) command to load data directly from a stage to a target table. When working with internal stages, you should use this action together with "Bulk load to an internal stage".

This action will execute the load and wait for completion before moving onto the next step. Load time depends on the size of source file, number of columns, additional validation in the target table and network speed (faster if loading data from S3 to an AWS-deployed Snowflake instance). 1 GB CSV file with 30 columns and 3 million rows will take 60 seconds.

The source file can contain data in CSV format, JSON, PARQUET, and other semi-structured file types (opens new window).

# Input fields

Input field Description
Table Select a target table to load data into. Typically, this is a staging table for loading data. Subsequently, rows in this table is merged into your production table.
Stage name

Select an existing stage in Snowflake. If a file is not specified in this stage, all new files will be loaded. If using an external stage, this external stage should contain information about file location, AWS credentials, encryption, and file format details.

Learn how to create an S3 external stage.

File name Specify a list of one or more file names (separated by commas) to be loaded. If left unspecified, all files from the stage will be loaded. Ensure that these files have already been staged in either the Snowflake internal or external. Learn more.
File Format Specify the file format you would like to apply to the data. By default, the Snowflake default format will be applied to the COPY command.

# Output Fields

Output field Description
Source file name Relative path and name of the source file.
Sample Values:
External Stage: s3://bucket-name/parent_folder/file_name.csv
Internal Stage: @stage_name/folder/file_name.csv
Values Description
LOADED All rows successfully loaded.
LOAD FAILED Unsuccessful load. Entire data file was not loaded.
PARTIALLY LOADED Unsuccessful load. Data file was partially loaded. Use First error line to find out exactly where the load failed.
Rows parsed Number of rows read from the source file.
Rows loaded Number of rows successfully loaded from the source file into target table.
Error limit If the number of errors reaches this limit, then abort the load. This is typically 0, meaning that the load will abort on the first error.
Errors seen Number of rows with error in the source file.
First error Error details of the first error in the source file.
First error line Line number of the first row that caused an error.
First error character Position of the first character that caused an error.
First error column name Column name where the first error occurred.

Last updated: 1/29/2024, 3:33:15 PM