Hi All
I am trying to pull table display.metric_instance from Azure Data Factory using Service Now connector. In Azure Data factory, they have an option to query data directly from Snow(check below screenshot).
Do we have a SQL Syntax documentation for this? As this query will directly hit Snow database, I would like to know the syntax for this. For example , I am unable to use CAST and CONVERT functions while querying the data. Also how do I improve the performance of the query.
For example, if I pull the full table it takes around 8 hours to complete, and when I give some filter options , error is thrown as "Operation Time Out".
Could you please suggest some techniques on improving the performance and SQL Query Syntax documentation?
I do not have any control on ServiceNow apart from Querying the data.
Thanks in advance
