Could you please guide us on connecting ServiceNow data in databricks

[ankris]

Would like to extract data like ticket info, resolve time, etc., from ServiceNow in databricks.

Not finding much information in community and appreciate your guidance on the same.

[Debayan]

Hi, there are some third party JDBC connector on this (such as fivetran and cddata etc. ) , It seems like there is not enough documentation around JDBC connectivity from Databricks.

[crannow]

ServiceNow offers API capabilities. You can consume the ServiceNow API within a Databricks notebook to extract data from ServiceNow. Following is a suggested prompt to use with ChatGPT for example python code to connect to ServiceNow's api.

PROMPT: "As a Python and Databricks expert can you assist me in programming a connection to consume ServiceNow api's to get data like ticket information, and resolution time?"