How to upload CSV to Snowflake: 3 approaches
Snowflake users are often faced with the need to import data in CSV format into Snowflake tables. This article aims to address this need by providing three methods to streamline the import process.
Back to Integrations 
HTTP Request and Snowflake integration
Save yourself the work of writing custom integrations for HTTP Request and Snowflake and use n8n instead. Build adaptable and scalable Development, Core Nodes, and Data & Storage workflows that work with your technology stack. All within a building experience you will love.
How to connect HTTP Request and Snowflake
- Step 1: Create a new workflow
- Step 2: Add and configure nodes
- Step 3: Connect
- Step 4: Customize and extend your integration
- Step 5: Test and activate your workflow
Step 1: Create a new workflow and add the first step
In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.
Step 2: Add and configure HTTP Request and Snowflake nodes
You can find HTTP Request and Snowflake in the nodes panel. Drag them onto your workflow canvas, selecting their actions. Click each node, choose a credential, and authenticate to grant n8n access. Configure HTTP Request and Snowflake nodes one by one: input data on the left, parameters in the middle, and output data on the right.
Step 3: Connect HTTP Request and Snowflake
A connection establishes a link between HTTP Request and Snowflake (or vice versa) to route data through the workflow. Data flows from the output of one node to the input of another. You can have single or multiple connections for each node.
Step 4: Customize and extend your HTTP Request and Snowflake integration
Use n8n's core nodes such as If, Split Out, Merge, and others to transform and manipulate data. Write custom JavaScript or Python in the Code node and run it as a step in your workflow. Connect HTTP Request and Snowflake with any of n8n’s 1000+ integrations, and incorporate advanced AI logic into your workflows.
Step 5: Test and activate your HTTP Request and Snowflake workflow
Save and run the workflow to see if everything works as expected. Based on your configuration, data should flow from HTTP Request to Snowflake or vice versa. Easily debug your workflow: you can check past executions to isolate and fix the mistake. Once you've tested everything, make sure to save your workflow and activate it.
Popular HTTP Request and Snowflake workflows
Import Productboard Notes, Companies and Features into Snowflake
This workflow imports Productboard data into Snowflake, automating data extraction, mapping, and updates for features, companies, and notes. It supports scheduled weekly updates, data cleansing, and Slack notifications summarizing the latest insights.
Features
Fetches data from Productboard (features, companies, notes).
Maps and processes data for Snowflake tables.
Automates table creation, truncation, and updates.
Summarizes new and unprocessed notes.
Sends weekly Slack notifications with key insights.
Setup
Configure Productboard and Snowflake credentials in n8n.
Update Snowflake table schemas to match your setup.
Replace Slack channel ID and dashboard URL in the notification node.
Activate the workflow and set the desired schedule.
Load data into Snowflake
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.
Prerequisites:
A CSV with data
A Snowflake account and credentials
A Snowflake database to upload your CSV to
Nodes:
A HTTP Request node to download the CSV file
A Spreadsheet File node to access the data from the CSV
A Set node to ensure the data from the CSV is mapped to the column names of the Snowflake database
A Snowflake node to insert these new rows into the database.
Build your own HTTP Request and Snowflake integration
Create custom HTTP Request and Snowflake workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
HTTP Request and Snowflake integration details
Other integrations with Snowflake
FAQs
Can HTTP Request connect with Snowflake?
Can I use HTTP Request’s API with n8n?
Can I use Snowflake’s API with n8n?
Is n8n secure for integrating HTTP Request and Snowflake?
How to get started with HTTP Request and Snowflake integration in n8n.io?
Need help setting up your HTTP Request and Snowflake integration?
Discover our latest community's recommendations and join the discussions about HTTP Request and Snowflake integration.
Google Verification Denied
Moiz Contractor
Describe the problem/error/question
Hi, I am getting a - Google hasnt verified this app error. I have Enable the API, the domain is verified on the Cloud Console, the user is added in the search console and the google do…
HTTP request, "impersonate a user" dynamic usage error
theo
Describe the problem/error/question
I a http request node, I use a Google service account API credential type.
I need the “Impersonate a User” field to be dynamic, pulling data from the “email” field in the previous nod…
Why is my code getting executed twice?
Jon
Describe the problem/error/question
I have a simple workflow that retrieves an image from url with http node and prints the json/binary in code. I have a few logs, but I am confused why I see duplicate messages for each …
How to send a single API request with one HTTP node execution, but an array of parameters in it (like emails[all]?)?
Dan Burykin
Hi!
I’m still in the beginning. Now I need to make an API call via HTTP node, and send all static parameters, but with the array of emails parameter (named it wrongly just to show what I need {{ $json.email[all] }}). Wo…
Start a Python script with external libraries - via API or Command Execution?
Tony
Hi!
I have a question: I am making an app that allows a person to scrape some data via a Python library. I have a Python script that needs to be triggered after certain user actions.
What is the best way to:
Send a p…
Looking to integrate HTTP Request and Snowflake in your company?
Over 3000 companies switch to n8n every single week
Why use n8n to integrate HTTP Request with Snowflake
Build complex workflows, really fast
