In admin panel -> Database -> Queries
You can see all running tasks and it has a source column & details. I want to create a look which would have all jobs which have a source as a "Filter Suggestion" and include either a link to sql or sql (latter is better).
I am able to get a rough list of queries run as filter suggestions from history explore but I cannot figure out where to get the sql. Any ideas? Also job id for bigquery is blank so I cannot infer from information schema there.
Filter suggestions are scanning very big tables leading to a lot of performance issues. I want to know all the fields people are filtering on.
LinkedIn
Twitter
