I'm hoping to create a service account to allow me to retrieve information on the queries that are currently running in Looker, to enhance observability and allow us to spot problems quickly. I currently plan to do this by using the "all_running_queries" method in the Python "looker_sdk" library. Ideally, I'd like to have a service user with minimal privileges to get this information, but I'm not sure if that is possible with the Looker API.
From an earlier post, I know that "Only admin API users can kill queries via the API." Is the same true for getting a list of running queries? Does the service API account need to have the "Admin" role to be able to call "all_running_queries" and see what's currently running?
LinkedIn
Twitter
