0 0
Read Time:1 Minute, 38 Second

During the last few posts, we have witnessed how Salesforce-Snowflake integration is done via python. But apart from Python there are many ways to integrate Salesforce with Snowflake like Third Party ETL tool (Informatica, Talend, Datastage etc). AWS provides an out-of-box Amazon AppFlow which is a fully managed integration service that lets you securely transfer data between Software-as-a-Service (SaaS) applications and Cloud Data warehouse. Use Amazon AppFlow to automate your data transfers in just a few minutes. No coding is require.

We will try to implement the below pipeline using AppFlow which will extract data from Salesforce and load into Snowflake.

Appflow Pipeline

Firstly, Create the FLOW in below way: Go to Amazon AppFlow and create the Flow.

AppFlow Screen

Secondly, Select Salesforce as Source and create the connection to connect with Salesforce.

Salesforce Connection
Salesforce Connection

Select Destination as Snowflake and create the Connection:

However, Before creating the Snowflake connection, Create the Table in Snowflake to hold the Account object records.

create or replace table Account_table(NAME VARCHAR(200),AccountNumber VARCHAR(100),Site VARCHAR(100),Rating Varchar(100),Phone number,ShippingAddress Varchar(200),CRID varchar(5))

Flow Configure

Salesforce to SF

Snowflake Connect

Define the Mapping, Salesforce Account Object Field name –>  to Snowflake Table Column Names:

SF to SF Mapping

Now Run the Flow, As per below screenshot Flow is running.

Run Flow
Snowflake result

Finally, we can see, we are able to move the Salesforce object Data to Snowflake in few clicks with no coding require.

Average Rating

5 Star
4 Star
3 Star
2 Star
1 Star

Leave a Reply

Your email address will not be published. Required fields are marked *