Insert rows
Inserts rows into a Snowflake database table from a DataReader or DataTable.
Use this action when you have data already loaded into memory or streaming from another source and need to bulk-insert it into Snowflake. For loading data from a staged file instead, use Copy into.
Example 
This flow retrieves customer data from SQL Server, applies a transformation step, and then inserts the transformed data into a Snowflake table. It returns the number of rows successfully inserted.
Properties
| Name | Required | Description |
|---|---|---|
| Title | No | A display label for this action in the flow editor. |
| Connection | Yes | The Snowflake connection to use. |
| Source | Yes | The data source to insert from — either a DataReader or a DataTable. |
| Destination table | Yes | The Snowflake table to insert rows into. You can select an existing table or enter a name. |
| Result variable name | No | Stores the number of inserted rows for use later in the flow. |
| Description | No | Notes about this action's configuration. |
Returns
Integer Int32 — the number of rows successfully inserted into the destination table.