function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Anoolatha Bijjala 6Anoolatha Bijjala 6 

Salesforce and Snowflake integration/connection

Hi, We want to connect snowflake to our salesforce instance to get the data from snowflake to Salesforce. Can anyone please advise on how to do that? Any app exchange product or documentation. I am having hard time to find proper way do it? I contacted salesforce support, but they told me to post in the developer forums as some others might have connected and they can provide more information. Thank you!
VinayVinay (Salesforce Developers) 
Hi,

Hope below links will help you to give more insights.

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.

Thanks,
Vinay Kumar
Kent LichtyKent Lichty
Greetings; 
I would like to join this discussion as well, because my organization wants to do exactly the same thing: Connect to a Snowflake database table from an application within Salesforce and query those records REAL-TIME from that table and then display them in a VisualForce page.  I know that this will reqire some kind of "connector" between the two systems but I have no idea what is the preferred connector.  I totally understand (and have researched) that  commerical products exist (one of which exists in the AppExchange which looks good), but my organization seems convinced that we should be able to write such a connector ourselves, but that sounds quite difficult to me.  The Snowflake documentation page recommends using either a JDBC or ODBC to connect, but from my research Apex cannot support either of those.  It looks like the Einstein Data analytics module of Salesforce contains a Snowflake connector, but I don't think my organization has that module.  Salesforce to Snowflake integration is such a new topic so there is very little information  available. I would truly appreciate any advice about this. Thanks very much. 
Xeniia FrankXeniia Frank
Hi! This article (https://skyvia.com/blog/snowflake-to-salesforce-integration) describes in detail how to connect Salesforce and Snowflake via two methods — Tableau CRM Connector and code-free data integration with Skyvia. The second method has a number of advantages. Skyvia (https://skyvia.com/data-integration/integrate-salesforce-snowflake) supports 80+ native connectors and is a complete ETL, ELT and Reverse ETL tool.