Copy Into
Copies data from a staged file into a specified Snowflake database table.
A stage is a location within or outside Snowflake (such as Microsoft Azure Blob storage or Amazon S3) where files are stored before they are loaded into Snowflake. This action retrieves data from the selected stage, applies any specified transformations, and inserts it into the target database table, supporting various file formats (CSV, JSON, Parquet) and customizable field mappings.
Returns
Int32 The number of rows affected/inserted.
Properties
| Name | Data type | Description |
|---|---|---|
| Title | Optional | The title or name of the command. |
| Connection | Required | The Snowflake connection. |
| Stage name | Required | Select an existing Stage name (will be prefixed by @). |
| File name | Required | Select the name of the file to import from. |
| File format settings | Required | Select the file type and optional settings for parsing. |
| Destination table | Required | Select or enter the name of the table to copy into. |
| Transformation/mappings | Optional | Map between file fields and destination table columns. |
| Result variable name | Optional | Name of the result variable containing the number of inserted rows. |
| Description | Optional | Additional notes or comments about the action or configuration. |
File format settings
Options for CSV files
Options for JSON files
Options for Parquet files
Note
- The Stage must exist and can be set up, for example, as Microsoft Azure Blob storage or an Amazon S3 Bucket.
- In order to use Parquet format, configure the transformation settings. See example below.
