Back to integrations
Microsoft SQL and Snowflake integration
Save yourself the work of writing custom integrations for Microsoft SQL and Snowflake and use n8n instead. Build adaptable and scalable Development, Data & Storage, workflows that work with your technology stack. All within a building experience you will love.
How to connect Microsoft SQL and Snowflake
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.
Build your own Microsoft SQL and Snowflake integration
Create custom Microsoft SQL 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.
Microsoft SQL supported actions
Execute Query
Execute an SQL query
Insert
Insert rows in database
Update
Update rows in database
Delete
Delete rows in database
Snowflake supported actions
Execute Query
Execute an SQL query
Insert
Insert rows in database
Update
Update rows in database
Microsoft SQL and Snowflake integration details
Other integrations with Microsoft SQL
Other integrations with Snowflake
Microsoft SQL and Snowflake integration tutorials
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.
Export data from SQL database to CSV: 3 nifty techniques
Export your SQL data into CSV with 3 nifty techniques: using SQL Server Management Studio, sqlcmd command line utility and n8n automation tool.
FAQs
FAQ
Can Microsoft SQL connect with Snowflake?
Can I use Microsoft SQL’s API with n8n?
Can I use Snowflake’s API with n8n?
Is n8n secure for integrating Microsoft SQL and Snowflake?
How to get started with Microsoft SQL and Snowflake integration in n8n.io?
Need help setting up your Microsoft SQL and Snowflake integration?
Discover our latest community's recommendations and join the discussions about Microsoft SQL and Snowflake integration.
Structure Snowflake Output
Pierre-Louis Bescond
Hi, n8n newbie here :sweat_smile: I have trouble understanding how I can parse the information sent back by the “Snowflake - Execute Query” node. The workflow I’ve built gets an order reference through the chat {{ $fr…
Syntax error when inserting multiple rows using Microsoft SQL node with Azure Dedicated SQL pool
Cathryn17
Describe the problem/error/question When inserting multiple rows (items) into an Azure Dedicated SQL pool (on a regular Azure SQL Server), we receive a syntax error from the DB (“Parse error at line: 1, column: 73: Incor…
The world's most popular workflow automation platform for technical teams including
Why use n8n to integrate Microsoft SQL with Snowflake
Build complex workflows, really fast
