https://community.databricks.com/t5/data-engineering/servicenow-lakeflow-connector-using-table-api-only-for-tables/m-p/134287#M50077 <P>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.</P><P>Is there an easy work around, to manually configure the source table of the connector to point to a servicenow user-defined view?</P><P>In ServiceNow, a user defined view is easily accessible through the standard TABLE API.&nbsp; This can be easily tested via Postman and other API clients.&nbsp; User defined views offer the ability to query data consumable by users without the need to display all internal id such as sys_id.&nbsp; 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.</P> Wed, 08 Oct 2025 21:52:03 GMT ckanzabedian 2025-10-08T21:52:03Z https://community.databricks.com/t5/data-engineering/servicenow-lakeflow-connector-using-table-api-only-for-tables/m-p/134287#M50077 <P>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.</P><P>Is there an easy work around, to manually configure the source table of the connector to point to a servicenow user-defined view?</P><P>In ServiceNow, a user defined view is easily accessible through the standard TABLE API.&nbsp; This can be easily tested via Postman and other API clients.&nbsp; User defined views offer the ability to query data consumable by users without the need to display all internal id such as sys_id.&nbsp; 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.</P> Wed, 08 Oct 2025 21:52:03 GMT https://community.databricks.com/t5/data-engineering/servicenow-lakeflow-connector-using-table-api-only-for-tables/m-p/134287#M50077 ckanzabedian 2025-10-08T21:52:03Z https://community.databricks.com/t5/data-engineering/servicenow-lakeflow-connector-using-table-api-only-for-tables/m-p/134301#M50082 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/168473">@ckanzabedian</a>,&nbsp;have you checked out the documentation yet for the ServiceNow connector?<BR /><A href="https://learn.microsoft.com/en-us/azure/databricks/ingestion/lakeflow-connect/servicenow-limits" target="_blank" rel="noopener">https://learn.microsoft.com/en-us/azure/databricks/ingestion/lakeflow-connect/servicenow-limits</A>&nbsp;<BR />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</P><P><BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BS_THE_ANALYST_0-1759988169411.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/20589i46D80BFA468511AF/image-size/large?v=v2&amp;px=999" role="button" title="BS_THE_ANALYST_0-1759988169411.png" alt="BS_THE_ANALYST_0-1759988169411.png" /></span></P><P>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&nbsp;<STRONG>setup guide</STRONG> :&nbsp;<A href="https://www.databricks.com/resources/demos/tours/platform/servicenow-lakeflow-connect" target="_blank" rel="noopener">https://www.databricks.com/resources/demos/tours/platform/servicenow-lakeflow-connect</A>&nbsp;<BR /><BR />This page seems to also indicate it's Tables only at the moment:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BS_THE_ANALYST_1-1759988706790.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/20590iC076C297FA7B6C67/image-size/large?v=v2&amp;px=999" role="button" title="BS_THE_ANALYST_1-1759988706790.png" alt="BS_THE_ANALYST_1-1759988706790.png" /></span></P><P><BR />All the best,<BR />BS</P> Thu, 09 Oct 2025 05:51:26 GMT https://community.databricks.com/t5/data-engineering/servicenow-lakeflow-connector-using-table-api-only-for-tables/m-p/134301#M50082 BS_THE_ANALYST 2025-10-09T05:51:26Z