Load data into Snowflake
Ready for 3.0What this workflow does
This workflow has 5 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Snowflake. It also calls n8niostorageaccount.blob.core.windows.net over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- HTTP Request: calls n8niostorageaccount.blob.core.windows.net
- Spreadsheet File: reads or writes a spreadsheet file (legacy node)
- Set (Edit Fields (Set)): sets or maps fields
- Snowflake: uses Snowflake
Services it uses
HTTP calls to: n8niostorageaccount.blob.core.windows.net
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
- Still check Spreadsheet File (Spreadsheet File): Convert to File / Extract from File.
Nodes used (5)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Spreadsheet File
n8n-nodes-base.spreadsheetFile - Edit Fields (Set)
n8n-nodes-base.set - Snowflake
n8n-nodes-base.snowflake
From the author
This workflow automatically downloads a CSV from the web, and parses it in a format that n8n can access. It then ensures that the data from the CSV is matched to the names of the columns in the database, and inserts this data as new rows in Snowflake.…