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

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:

All the best,
BS