Go to the Activities section and expand "Move & transform"

Click "Copy data" and drag onto the canvas.

Name the Copy object with the Salesforce object you are copying from Salesforce to Snowflake.

By default ADF will select the entire leads table. Lets explore the "Query" option. Click on "Query"

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"

Click on the Snowflake Leads table. In this scenario we named it "SNOW_Lead"

During migration and in some cases when data volume is low, truncating and re-loading data will ensure your data mirrors Salesforce.

Type "TRUNCATE TABLE" and the fully qualified table name / path.

You should test this SQL in Snowflake to ensure your syntax is correct.

Example: TRUNCATE TABLE GG_DEVELOPMENT_OPPS.SFDC."Lead"

Click "Import schemas". This will query [Salesforce.com](http://Salesforce.com) and your Snowflake table and download both schemas. It will use the field names of both systems and match exact matches. 

If your source query has columns that do not match the Sink, it will present an error for you to manually locate the matching field name. Field names from a source can only be used once. Select the field that mismatches.

Click "Enable staging". This feature is required to copy data into Snowflake.

You will need a blob storage container confiured specifically for ADF that uses SAS

Select the ADF Blob that you have created for Azure Data Factory

Click folder that you will use to stage data "adf-stage". Data staged in this folder are temporary files that are deleted after you run your data pipeline.

Click "This text is displayed if your browser does not support the Canvas HTML element."

This text is displayed if your browser does not support the Canvas HTML element.

Click "Debug" to test the data pipeline and move data from Salesforce into Snowflake

Click the refresh icon to see the progress / status.

"In progress" means the pipeline is waiting to run.

Clicking on the glasses icon will display a dialogue so you can see the number of rows moving from Source to Destination. Click here.

Click "Close" after you review the progress.

Click here. The status will either show "Succeeded" or failed with an error message.

While in debug the copy node will also show the status icon.

For illustrative purposes we have added a second copy node for the "Account" object. To run copy commands in sequency, you can click on the icon for success , failure, or completion and drag it to connect the next node in sequence.

Now when you run or debug the Lead copy node will run and on success initiate the Account copy node.

To test each node one by one, you can click on the "Debug Until" which will run up until the node you have selected.

Create a Data Pipeline to Connect Salesforce to Snowflake