I have a business requirement to create a way for users to search and view results from an external database (Snowflake) in Salesforce. I have created a simple visualforce page and need to send a query to Snowflake searching for a match on the searchString captured in my page using one of their JDBC/ODBC drivers on click of 'Search' button.

I think I have to create a webservice and expose the REST API however I am unsure how to use the appropriate Snowflake driver.

Can someone please help me with this?

  • I think you need to contact Snowflake support to get proper information – Santanu Boral Jul 26 '18 at 10:29
  • I have discussed this with Snowflake and they have referred me to their Driver documentation as they have said I need to use one of their drivers in order to gain access and take care of sessions etc however this is not getting me very far. I am not sure how to use/reference the driver in a class. – Hannah Jul 26 '18 at 10:33
  • What you will need is an API from Snowflake so that you can connect from Salesforce (your VF page). JDBC/ODBC driver is mostly used for fat clients and this will be of no help in your case as they need to be downloaded on local machine and then utilized accordingly (its a jar file necessarily here). As far as I can lookup, seems they do have the REST API support but its case to case basis, refer to this link, so you should definitely reach out to them. – Jayant Das Jul 26 '18 at 18:34
  • Thanks Jayant, I have discussed the use of the API with Snowflake however due to all the requirements for spinning up a session, logging in and teardown along with the the actual query they advise not to use it and this is why it is a case by case basis. With this in mind, I will see if I can satisfy business requirements without connecting to Snowflake. – Hannah Jul 30 '18 at 7:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.