Create a Data Pipeline to Connect Salesforce to Snowflake | Scribe

    Create a Data Pipeline to Connect Salesforce to Snowflake

    • Ryan Goodman |
    • 0 step |
    • 5 minutes
    • AzureAzure
    • SnowflakeSnowflake
    • GitHubGitHub
    Navigate to Azure Data Factory
    Click "..." button next to Pipelines.
    Click "New pipeline"
    Click the Name field.
    Type "SFDC_CRM"
    Go to the Activities section and expand "Move & transform"
    Click "Copy data" and drag onto the canvas.
    Click on the "Name" field.
    Type "MLead"
    Name the Copy object with the Salesforce object you are copying from Salesforce to Snowflake.
    Click "Source" tab.
    Click the "Source dataset" dropdown.
    Select and Click "Lead".
    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 Table.
    Click "Sink"
    Click this Sink dataset dropdown.
    Type "lead"
    Click on the Snowflake Leads table. In this scenario we named it "SNOW_Lead"
    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