Retrieve Data from Snowflake using ServiceNow JDBC

[Immanuel Raj]

Hi Experts,

Need advice on how to get snowflake data to ServiceNow using JDBC connectivity. I was going through this link (https://docs.snowflake.com/en/user-guide/jdbc-using.html) but couldn't find anything relevant. Could someone suggest a different approach to integrate ?

 Refer this Link:https://community.servicenow.com/community?id=community_article&sys_id=4f1dc0aadb3670d0457ae6be13961...

[Santosh70]

@Immanuel Raj ,

Hi Immanuel,

Many thanks. let me try with details you have provided.

could you pls help in the exact jar file you had downloaded from the above screenshot you have provided.

I guess we have to download only the jar file which is having the size of 27MB? or do we have to download all the jar files? Please confirm.

also, in the data source record, do we need to provide the server name & Table name/sql statement?

Thanks again.

[Immanuel Raj]

Hi Santosh,

Only the JAR file is required Please find the below link to download the latest file and have attached screenshot highlighted the file to download.

Link: https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/3.13.6/

For DataSource "Server" name is not required.

If you're selecting the dropdown "Query" field as "Specific SQL" then SQL statement is required. Incase selecting dropdown as "All rows from table" then mention the SNOWFLAKE table name to retrieve the data.

[Hemanesh]

Hi Immanuel Raj,

i have tried with both jar files of 3.13.0 and 3.13.6 for mid server, but still it says "no suitable jdbc jar file error message" when i click on "test load 20 records". am i missing any other configurations?

Thanks,

Hemanesh

[Bharathi Nunna]

Hi All,

Is there any other methods apart from JDBC Connection to integrate with Snowflake. We do not want to use MID Server as per the JDBC Solution. Kindly suggest if there are any methods to read data from snowflake to servicenow.

[Immanuel Raj]

Hi Bharathi,

You can use REST API as well to retrieve data. But it can be only used through snowPipe please refer to the below link as snowflake documentation.

Link: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html