Snowflake Data Management: Create, Insert, and Update Records - n8n Workflow

Data Engineers and Analysts who manage ETL/ELT pipelines involving Snowflake.
Users needing reliable n8n templates for testing schema changes and data synchronization.
Technical professionals seeking practical examples of advanced database operations within an n8n workflow.
Developers looking to automate data warehouse tasks using a powerful n8n node integration.

This robust n8n workflow provides a complete demonstration of transactional data manipulation within a Snowflake data warehouse environment. It addresses the common challenge of needing to execute diverse database commands—from DDL (Data Definition Language) like CREATE TABLE via custom queries to DML (Data Manipulation Language) like INSERT and UPDATE—all within one seamless automation flow. This n8n template is crucial for organizations that need automated, repeatable procedures for managing their core data structures, showcasing the full capabilities of the dedicated Snowflake n8n node.

This automation is initiated by a manual n8n trigger and progresses through several data preparation and execution steps:

1. Start and Creation: The n8n workflow begins with the 'On clicking 'execute'' n8n trigger. The first Snowflake n8n node immediately executes a raw SQL query (CREATE TABLE docs (id INT, name STRING);) to establish the required schema.


2. Initial Data Setup: A Set n8n node prepares the initial record data, defining id as 1 and name as 'n8n'.


3. Insertion: The second Snowflake n8n node utilizes the insert operation, taking the data from the previous Set node and committing it to the newly created docs table.


4. Update Data Setup: A subsequent Set n8n node prepares the data for the update action, changing the name value to 'nodemation' (keeping id as 1 to target the correct record).


5. Record Update: The final Snowflake n8n node performs an update operation on the docs table, specifically targeting the name column using the incoming data, thereby updating the previously inserted 'n8n' record to 'nodemation'. This structured approach ensures every step of the n8n workflow is traceable and reliable.

To use this n8n template, follow these steps:

1. Import: Copy the provided JSON code and import it into your n8n instance via the 'Workflows' section.


2. Credentials: The n8n workflow requires Snowflake credentials. Click on any of the Snowflake n8n node instances (e.g., 'Snowflake') and configure the 'Snowflake n8n Credentials'. You will need your Snowflake account details (account name, warehouse, database, schema, and credentials).


3. Customization: Review the query in the first 'Snowflake' n8n node if you require a different table name or schema.


4. Execution: Since this n8n workflow uses a manual n8n trigger, click 'Execute Workflow' or the 'On clicking 'execute'' node to run the complete sequence of database operations.

On clicking 'execute' (manualTrigger): Functions as the starting n8n trigger for the entire n8n workflow, allowing manual testing.
Snowflake (Create Table): Function: Executes the custom SQL query CREATE TABLE docs (id INT, name STRING); to define the database schema.
Set: Function: Prepares the initial item for insertion, setting the fields id (1) and name ('n8n'). This structured data preparation is vital before hitting the insertion n8n node.
Snowflake1 (Insert Data): Function: Inserts the prepared data into the docs table using the built-in insert operation, mapping the incoming data fields to the defined columns.
Set1: Function: Prepares the data payload required for the update operation, setting the updated values (name: nodemation).
Snowflake2 (Update Data): Function: Performs the final database operation, updating the name column in the docs table based on the input data. The n8n node is configured to use the update operation.