{"id":"172","name":"Create a table, and insert and update data in the table in Snowflake","nodes":[{"name":"On clicking 'execute'","type":"n8n-nodes-base.manualTrigger","position":[250,300],"parameters":{},"typeVersion":1,"id":"5a1fbad9-ef25-4bbc-ad88-0e132590cc18","notes":"This manualTrigger node performs automated tasks as part of the workflow."},{"name":"Set","type":"n8n-nodes-base.set","position":[650,300],"parameters":{"values":{"number":[{"name":"id","value":1}],"string":[{"name":"name","value":"n8n"}]},"options":{},"keepOnlySet":true},"typeVersion":1,"id":"cac8336c-2f51-478f-9737-6b470ff88939","notes":"This set node performs automated tasks as part of the workflow."},{"name":"Snowflake","type":"n8n-nodes-base.snowflake","position":[450,300],"parameters":{"query":"CREATE TABLE docs (id INT, name STRING);","operation":"executeQuery"},"credentials":{"snowflake":"Snowflake n8n Credentials"},"typeVersion":1,"id":"382ede54-30dd-4a89-be28-0ec7c40dfa40","notes":"This snowflake node performs automated tasks as part of the workflow."},{"name":"Snowflake1","type":"n8n-nodes-base.snowflake","position":[850,300],"parameters":{"table":"docs","columns":"id, name"},"credentials":{"snowflake":"Snowflake n8n Credentials"},"typeVersion":1,"id":"1fa84be2-9f9d-497e-b882-f2764b531cb0","notes":"This snowflake node performs automated tasks as part of the workflow."},{"name":"Set1","type":"n8n-nodes-base.set","position":[1050,300],"parameters":{"values":{"number":[{"name":"id","value":1}],"string":[{"name":"name","value":"nodemation"}]},"options":{},"keepOnlySet":true},"typeVersion":1,"id":"c8a58c18-97ba-48a4-bfe9-808e1a88391a","notes":"This set node performs automated tasks as part of the workflow."},{"name":"Snowflake2","type":"n8n-nodes-base.snowflake","position":[1250,300],"parameters":{"table":"={{$node[\"Snowflake1\"].parameter[\"table\"]}}","columns":"name","operation":"update"},"credentials":{"snowflake":"Snowflake n8n Credentials"},"typeVersion":1,"id":"d74f9238-f9bf-46ff-88af-2090ec3ff8db","notes":"This snowflake node performs automated tasks as part of the workflow."},{"id":"error-1e5971c8","name":"Error Handler","type":"n8n-nodes-base.stopAndError","typeVersion":1,"position":[1000,400],"parameters":{"message":"Workflow execution error","options":{}}}],"active":false,"settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"connections":{},"description":"Automated workflow: Create a table, and insert and update data in the table in Snowflake. This workflow processes data and performs automated tasks.","meta":{"instanceId":"workflow-d2a0b752","versionId":"1.0.0","createdAt":"2025-09-29T07:07:48.712616","updatedAt":"2025-09-29T07:07:48.712625","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"notes":"Excellent quality workflow: Create a table, and insert and update data in the table in Snowflake. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}