# Create table and insert with update in Snowflake via n8n
This automation template enables quick initialization of database schema and data management in Snowflake without writing SQL manually. Designed for professionals working with ETL processes, test datasets, or warehouse setup.
## Who it´s for
- Data engineers setting up Snowflake data structures
- Analysts automating test data loading
- Developers integrating no-code ETL workflows
## What the automation does
- Triggered manually on demand
- Creates a `docs` table in Snowflake with `id` and `name` columns
- Inserts initial record: `id=1`, `name=´n8n´`
- Updates `name` field to `´nodemation´` for `id=1`
- Demonstrates a complete cycle of basic CRUD operations
## What´s included
- Ready-to-use n8n workflow
- Trigger and action sequence logic
- Integrations with Snowflake via SQL nodes
- Basic text instructions for launch and adaptation
## Requirements for setup
- n8n account (cloud or self-hosted)
- Snowflake account with database access and permissions for table creation and DML operations
- Credentials to connect n8n to Snowflake (login, password, endpoint)
## Benefits and outcomes
- Eliminates need for manual SQL scripting
- Reduces time for test table preparation
- Serves as a template for advanced ETL automations
- Ensures reproducibility of schema initialization
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet