You need to sign in to do that
Don't have an account?
Nagarjuna 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.
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.
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
I recommend reviewing the following links to get started
https://docs.snowflake.com/en/user-guide-getting-started.html
https://automate.io/integration/salesforce/snowflake
https://www.workato.com/integrations/salesforce+snowflake
https://www.xplenty.com/integrations/salesforce/snowflake/
Appexchange:
https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000Ed2QkUAJ
You can find more on appexchange above is just a sample reference.
Read more here (https://skyvia.com/data-integration/integrate-salesforce-snowflake)