How to identify Looks/Dashboards that use a Specific Table

BarbK
Participant I

Hi all!

We have a table in Looker that we want to delete.  But we want to identify any Looks or Dashboards that might be using this table so that we can implement fixes before we delete it.  How do I find the list of Looks/Dashboards that use a table?  If I could also find out which fields are used by those Looks/Dashboards, that would be a bonus!

Thanks so much!  Barb

3 7 4,922
7 REPLIES 7

Hi @BarbK 

You can use system activity as a good starting point. We have a fields used parameter and you can group this by dashboard ID and Look ID. In fields used, you can filter for starts with or contains the view name associated with the table. To make this more precise, we can also add filters for the model and explore to narrow down the result set. Here is an example link that should point you in the right direction. 

https://HOSTNAME/explore/system__activity/history?fields=look.id,look.link,history.real_dash_id,dash...

Please let us know if you have any questions.

Thanks,

Eric

BarbK
Participant I

Hi @Eric_Lyons ,

Thanks so much for getting back to me so fast!

I tried that link and got an error message screen with “Hmmm… can't reach this page”.

Any ideas on what I should do to see that?

Thanks so much!!  

Barb

Hi @BarbK you need to add your looker instance’s host name where HOSTNAME appears. So, if my Looker instance’s url is eric.looker.com I would use 

https://eric.looker.com/explore/system__activity/history?fields=look.id,look.link,history.real_dash_...

BarbK
Participant I

Hi @Eric_Lyons !

Okay, so I’m a relative newby to all things Looker, so sorry that you have to put up with that!  🙂

I replaced the ‘https://eric.looker.com’ with our company’s looker address, and pasted it into my Chrome browser, and I got back the message:
“Could not find the model or view requested”

Are there other things in that string that I need to replace?

Thanks! Barb

Hi @BarbK no worries! We would also want to verify you have access to the system activity model. You should be able to see the model in the explore dropdown, but if you do not, you may want to consult your Looker Admin about your permissions/ model sets.

45f41a00-2068-42ed-89a7-b2db41e8479c.png

BarbK
Participant I

Aha!

Thanks so much, @Eric_Lyons !

That is the missing part of the puzzle.  I’ll get the access to the system activity model from my admin.

You are the best!   🙂

Barb

AnnS
Participant I

@Eric_Lyons Is there a way to see what views are being used in a dashboard?  Or at least what models are using a particular view, so that I can query those model/dashboard combos?

Top Labels in this Space
Top Solution Authors