Insert rows
Inserts rows into a Snowflake database from a DataReader or a DataTable.
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 | Data type | Description |
|---|---|---|
| Title | Optional | The name of the action. |
| Connection | Required | The Snowflake connection. |
| Source | Required | Select the source for data (DataReader or DataTable). |
| Destination table | Required | Select or enter the name of the table to insertinto. |
| 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. |
Returns
Int32 The number of rows affected/inserted.