I have an Azure Function instance. I would like to execute a KQL query to fetch some data from an Azure app insights instance of another app, then push the data to an on-prem database.
I am aware that we can send a GET request to the REST endpoint of the app insights via an API token, but is there a better way to do this? Ideally, I would like to directly execute the query somehow, since my Azure function resides in the same resource group.