1. Create Data Connections
Connect Azure Data Factory to Salesforce.com
Connect Azure Data Factory to Snowflake
2. Create Data Sources
Create a Snowflake Data Source in Azure Data Factory
Connect to Salesforce Lead and Account Object with Azure ADF
3. Move Data Between Applications
Create a Data Pipeline to Connect Salesforce to Snowflake
Import Data Into Salesforce with Azure Data Factory
4. Publishing and Administration
Publish your ADF Pipeline, Data Sets, and Triggers
Create an ADF Scheduled Trigger
Connect Azure Data Factory to Snowflake
In this example, we will guide you through the process to connect Azure Data Factory to Snowflake using a linked service. This is a one-time setup and configuration step to build all our data pipelines to extract or insert data into Snowflake. To get started with this tutorial, you will require your Snowflake credentials.
By following this step-by-step guide, you’ll be able to establish a connection between your Azure Data Factory and Snowflake , enabling you to efficiently transfer data between the two platforms. So, let’s dive right in and explore the details of how you can create a linked service in Azure Data Factory that connects to Salesforce.com.
Recommendations:
- If you are looking to use this connection in production, you will want to make sure you work with your Snowflake admin to establish a system user to be used specifically for Azure Data Factory. As you extract or load data to and from Snowflake you may require role permissions.
- You will want to consider Setting Up a Snowflake User Network Policy IP Whitelist with Azure Data Factory IPs. We recommend waiting to setup this step until you have tested end to end.
