+ Start a Discussion
Nagarjuna Reddy.PNagarjuna Reddy.P 

integrate salesforce with snowflake

Hi All,

I have a requirement that i need to auto upload data from snowflake to one of the custom object so that i can avoid using data loader for uploading.Is this possible? I'm totally unaware of this module, Could any one please guide me throgh this.

Thank you All.
SwethaSwetha (Salesforce Developers) 
HI Nagarjuna,
I could not find the salesforce official documentation but you can try the below steps to see if this approach works for you.
To create a Snowflake Account 

1. Go to https://trial.snowflake.com/?utm_cta=website-homepage-nav-free-trial
2. You can proceed with creation of a free account (make sure you select AWS as cloud source)
3.I would recommend you to go through the article
https://docs.snowflake.com/en/user-guide/gen-conn-config.html and understand what are tables ,schema, Account, Role,databases 

Configuration and Setup in Einstein Analytics Studio

1. Login to your Einstein Analytics Org. 
2. Go to Setup > Analytics Settings > Enable Data Sync and Connections
3. Open Analytics Studio > Data Manager > Connect > *Click* Connect to Data*
4. Select *Add Connection *and select Snowflake,fill in the Fields.
NOTE - *Additional JDBC URL Parameters*  is optional and can be left. 
5. Click Save and Test (You should see a pop up with success message)
6. Select any Table and click Continue
7. Select the Fields which you want to pull in > Click *Continue*
8.You will see the Preview of the Fields with Data > See if there is anything which needs to be changed. 
9. After correcting any necessary fields / attributes, Click Save 
10. Now, Go to *Connect > *Under the Snowflake connection you just created, you can see a data replication is ready > Using the drop down for the Object > Select *Run Datasync* 
11. Once the Datasync (Job) completes, Come to the same Page and using the same Drop down select Create Recipe 
12. Name the Recipe and Run the Job , You should see a Dataset created with the Name of Recipe. 

Hope this helps you. Please mark this answer as best so that others facing the same issue will find this information useful. Thank you