Actions3
Update
AI-generatedOverview
This node allows users to update rows in a Snowflake database table. It is designed for scenarios where you need to modify existing records based on a specific key column, such as updating user information, product details, or any other data stored in Snowflake tables.
Typical use cases include:
- Updating customer records by their unique ID.
- Modifying inventory quantities or descriptions in a product catalog.
- Changing status flags or timestamps in transactional data.
For example, if you have a table users with columns id, name, and email, you can update the name and email of users by specifying id as the update key and providing new values for those columns.
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 the update operation will be performed. |
| Update Key | The column name that determines which rows to update (usually a unique identifier like "id"). |
| Columns | Comma-separated list of columns to update in the specified table. |
Output
The node outputs an array of JSON objects representing the updated rows. Each output item corresponds to one input item and contains the updated column values as JSON fields.
No binary data is produced by this node.
Dependencies
- Requires a valid connection to a Snowflake database.
- Needs appropriate credentials depending on the selected authentication method (password, JWT key pair, or browser-based).
- The node uses internal helper functions to manage connections and execute SQL queries.
Troubleshooting
- Connection issues: Ensure that the provided credentials are correct and have sufficient permissions to perform update operations on the target table.
- Invalid table or column names: Verify that the table and column names exist in the Snowflake database and are spelled correctly.
- Update key missing from columns: The update key must be included in the columns list; otherwise, the node automatically adds it. If omitted, updates may fail or affect unintended rows.
- SQL errors: Errors during query execution usually indicate syntax problems or permission issues. Review the error message and check the SQL statement generated by the node.
- Authentication failures: Confirm that the chosen authentication method matches the credential type configured in n8n and that all required fields are filled.