LinkedIn
Twitter
I am working on optimizing merge queries and I found some useful usage data from the history explore (screenshot below). Is there a way to see the results of a merge query from `merge_query.id`?
A few findings:
- This id is numeric, e.g 129386
- I was able to view the dashboard a merge query is on. If I have to explore all the tiles in a dashboard, one by one, I can eventually know see merge query results, but that takes too much time. I am asking if there's a more efficient way.
- When I explore/run a merge query, the url looks like this "https://xxx.looker.com/merge?mid=WG5EH7L0yGq7nfl86zdyPT". I am not sure what mid is, probably merge id. I think knowing this piece will solve my problem, but the format doesn't match any column in the history explore (not merge_query.id, not merge_query.hash)
It depends on what you mean by 'see the results' - if you are in the 'History' explore, you can just pull in the Merge Query: ID field and clicking on that ID in the results table will bring you to the merged results interface for that particular query. Is there something else you are looking to see?
Thank you for your reply. By seeing the merge result, I mean the screen you see when you explore/open one, as below. The url is like this "https://xxx.looker.com/merge?mid=WG5EH7L0yGq7nfl86zdyPT". I basically want to see what a merge query is about.
I'm not sure if we can get to the merged query explore UI itself, but we can see a table of the queries that are combined to create merged results, and see the fields they are joined on as you see below. If you click on 'query' in the 'link' column it will take you to each of the queries that are combined in a merged query, and you can group them together as you see below so you see which queries are combined.
If you substitute your URL at the start of the link below, it should bring up the same view on your instance:
YOUR_INSTANCE_NAME/explore/system__activity/merge_query?fields=merge_query_source_query.id,merge_query_source_query.query_id,query.link,merge_query.created_time,merge_query_source_query.rank,merge_query.id,merge_query_source_query.merge_fields&sorts=merge_query_source_query.id+desc&limit=500&column_limit=50&vis=%7B%7D&filter_config=%7B%7D&dynamic_fields=%5B%5D&origin=share-expanded
