HTTP Request node
Snowflake node

Load data into Snowflake

Published 11 months ago

Created by

n8n-team
n8n Team

Categories

Engineering

Template description

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.

Share Template

Implement complex processes faster with n8n

red icon yellow icon red icon yellow icon