ServiceNow LakeFlow Connector - Using TABLE API only for tables and NOT views

ckanzabedian
Databricks Partner

‎10-08-2025 02:52 PM

The current Databricks ServiceNow Lakeflow connector relies on ServiceNow REST TABLE API to capture data. And for some reason, it is unable to list a user defined view as a data source to be configured, even though ServiceNow user defined views are accessible view the TABLE APIs.

Is there an easy work around, to manually configure the source table of the connector to point to a servicenow user-defined view?

In ServiceNow, a user defined view is easily accessible through the standard TABLE API.  This can be easily tested via Postman and other API clients.  User defined views offer the ability to query data consumable by users without the need to display all internal id such as sys_id.  After creating a view in ServiceNow (e.g. u_incident_view), the Lakeflow connector does not list it as a possible table to connect to. It seems to query the list of tables and ignores the views.

Labels:
0 Kudos

BS_THE_ANALYST
Databricks Partner

‎10-08-2025 10:45 PM - edited ‎10-08-2025 10:51 PM

Hi @ckanzabedian, have you checked out the documentation yet for the ServiceNow connector?
https://learn.microsoft.com/en-us/azure/databricks/ingestion/lakeflow-connect/servicenow-limits 
The link above is about the limits. I can't see a mention about views, but, this part does mention that it can only ingest Tables that contain a sys_id



BS_THE_ANALYST_0-1759988169411.png

Whilst there doesn't seem to be a mention of views, that doesn't mean it isn't necessarily supported (or won't be in a future release). I've just clicked through a setup guide : https://www.databricks.com/resources/demos/tours/platform/servicenow-lakeflow-connect 

This page seems to also indicate it's Tables only at the moment:

BS_THE_ANALYST_1-1759988706790.png


All the best,
BS