Create a Data Pipeline to Connect Salesforce to Snowflake | Scribe
This guide was created with Scribe in 5 minutes. Sign in and create your own!
Create a Data Pipeline to Connect Salesforce to Snowflake
Ryan Goodman |
0 step |
5 minutes
Azure
Snowflake
GitHub
Navigate to Azure Data Factory
Click "..." button next to Pipelines.
Zoom Saved
Click "New pipeline"
Zoom Saved
Click the Name field.
Zoom Saved
Type "SFDC_CRM"
Go to the Activities section and expand "Move & transform"
Zoom Saved
Click "Copy data" and drag onto the canvas.
Zoom Saved
Click on the "Name" field.
Zoom Saved
Type "MLead"
Name the Copy object with the Salesforce object you are copying from Salesforce to Snowflake.
Zoom Saved
Click "Source" tab.
Zoom Saved
Click the "Source dataset" dropdown.
Zoom Saved
Select and Click "Lead".
Zoom Saved
By default ADF will select the entire leads table. Lets explore the "Query" option. Click on "Query"
Zoom Saved
As you can see with this SOQL query, we can select only columns we want or limit rows for testing and validation. For this lab, we will re-select "Table"
Zoom Saved
Click Table.
Zoom Saved
Click "Sink"
Zoom Saved
Click this Sink dataset dropdown.
Zoom Saved
Type "lead"
Click on the Snowflake Leads table. In this scenario we named it "SNOW_Lead"
Zoom Saved
Want to make guides like this in seconds? Yes, it's really that fast.
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe
Have something to say?Create an account to leave messages for the author to see!
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key