Actions3
Overview
This node integrates with Snowflake, a cloud data platform, to perform database operations. Specifically, the Insert operation allows users to add new rows into a specified table in a Snowflake database. This is useful for scenarios where you want to programmatically insert data from workflows into Snowflake tables, such as logging events, importing records from other systems, or batch uploading data.
For example, you might use this node to insert customer information collected from a form into a Snowflake table named customers, specifying which columns to populate.
Properties
| Name | Meaning |
|---|---|
| Authentication | The method used to authenticate with Snowflake. Options: "Snowflake Password", "Snowflake JWT", "Browser". |
| Table | The name of the Snowflake table where new rows will be inserted. |
| Columns | Comma-separated list of column names that correspond to the properties in the input data to be inserted as new rows. |
Output
The node outputs an array of JSON objects representing the rows that were inserted. Each output item corresponds to one input item and contains the data that was inserted into the table, structured as key-value pairs matching the specified columns.
No binary data output is produced by this operation.
Dependencies
- Requires a valid connection to a Snowflake database.
- Requires appropriate credentials for authentication, which can be provided via password, JWT key pair, or browser-based authentication.
- The node depends on internal helper functions to create and manage the Snowflake connection and execute SQL queries.
Troubleshooting
Common issues:
- Incorrect table name or columns may cause SQL errors.
- Mismatch between the number of columns specified and the properties present in the input data can lead to failed inserts.
- Authentication failures if credentials are invalid or expired.
- Network connectivity issues to the Snowflake service.
Error messages and resolutions:
- SQL syntax error: Verify the table name and column names are correct and exist in the Snowflake schema.
- Authentication error: Check that the provided credentials are correct and have sufficient permissions.
- Connection timeout: Ensure network access to Snowflake is available and firewall rules allow the connection.
- Missing columns in input data: Confirm that the input items contain all properties listed in the Columns field.
Links and References
- Snowflake Documentation
- n8n Documentation on Snowflake Node (general reference)