REST API for Snowflake and servicenow

[amar7]

Hi Community ,

we have requirement that we have to load the record in servicenow cmdb_ci from snowflake , but we are not sure which connection would be best , we have referred some article they says Snowflake doesn't recommend JDBC, some says rest Api is slow to collect data .

may i know which can be the best option , and if possible share some doc's too.

Thanks in advance !!!  

[Ankur Bawiskar]

@amar7 

it's better to discuss this with Snowflake team before proceeding.

[Tony Chatfield1]

Hi, in my opinion Rest via scripted rest api, or an endpoint that is a temp import table so you can utilize transform is the most appropriate solution as they both allow you to control the data populated into your instance. When they say 'slow to collect data' perhaps you should have this clarified as a post from snowflake to SNC shouldn't be collecting anything and slow sounds a lot like poorly conceived GET requests.

[ersureshbe]

Hi, Ankur is right. You should check with Snow Flake. For your reference, use below link for JDBC approach.

https://www.servicenow.com/community/developer-articles/integrate-snowflake-with-servicenow-using-jd...

If you go to REST API approach, snow flake team should consume the url and they should send transfer the data from snowflake. If no effort from snow flake you should go with JDBC approach.