How to find which Looks are using a Model

Looker Q&A Looker
1

I need to find out which Looks are using a model. Could someone please tell me how to get this information. I am using Looker version 23.2.24

Thank you

2

https://YOUR_INSTANCE_URL/explore/system__activity/look?fields=query.model,query.view,look.id,look.link,look.title&f[look.moved_to_trash]=No&sorts=query.model&limit=500&column_limit=50&vis=%7B%7D&filter_config=%7B%22look.moved_to_trash%22%3A%5B%7B%22type%22%3A%22is%22%2C%22values%22%3A%5B%7B%22constant%22%3A%22No%22%7D%2C%7B%7D%5D%2C%22id%22%3A0%2C%22error%22%3Afalse%7D%5D%7D&dynamic_fields=%5B%5D&origin=share-expanded

Replace YOUR_INSTANCE_URL with your instance xyx.cloud.looker.com

1 Like
3

Thank you so much. That worked.

For anyone else who is searching for answers to the same question, you can do this too

SELECT
query.model AS query.model,
query.view AS query.view,
look.id AS look.id,
look.id AS look.link,
look.title AS look.title
FROM look
INNER JOIN query ON look.query_id = query.id
WHERE query.view = ‘name of explore goes here’