Create a table, and insert and update data in the table in Snowflake

Create a table and manage data in Snowflake with a simple manual workflow. Effortlessly create, insert, and update records, ensuring efficient data management and streamlined operations.

7/8/2025
6 nodes
Simple
manualsimplesnowflake
Categories:
Manual TriggeredSimple Workflow
Integrations:
Snowflake

Target Audience

This workflow is ideal for data analysts, data engineers, and developers who work with Snowflake and need to automate the process of creating tables and managing data. It is particularly useful for those who prefer manual triggers for testing or ad-hoc data operations.

Problem Solved

This workflow addresses the need for automating the creation of tables and the insertion and updating of data in Snowflake. It simplifies the process of managing data by providing a structured approach to execute SQL commands, thereby saving time and reducing errors in manual data handling.

Workflow Steps

  • Trigger the Workflow: The workflow starts when the user clicks 'execute', initiating the process.
    2. Set Initial Values: A 'Set' node is used to define initial values for the table, including an ID of 1 and a name of 'n8n'.
    3. Create Table: The workflow executes a Snowflake query to create a table named 'docs' with columns 'id' and 'name'.
    4. Insert Data: The workflow uses another Snowflake node to insert the initial values defined earlier into the 'docs' table.
    5. Set Update Values: A second 'Set' node is employed to prepare new values for updating the table, changing the name to 'nodemation' while keeping the ID the same.
    6. Update Data: Finally, the workflow updates the 'name' column in the 'docs' table using the new values set in the previous step.

    • Customization Guide

    Users can customize this workflow by modifying the values in the 'Set' nodes to insert different data into the Snowflake table. Additionally, they can change the SQL queries in the Snowflake nodes to perform other operations, such as altering table structures or executing more complex queries. Users can also adjust the manual trigger to automate the workflow based on specific events or schedules.