Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

Look inspection

  • 22 December 2017
  • 1 reply
  • 115 views
JohnRomanski
Userlevel 1

After a couple of years and a couple of thousand looks, we have a bunch of looks that don’t work anymore: missing fields, or missing models.



A couple of questions/requests:



Is there any way to examine what a look used to do? What models/fields were being displayed or how?


(Maybe this this feature would only be enabled in development mode.)



Is there any way to delete a look from the look detail/view page? If I am on ‘/look/23’ and getting a model not found error, it would be nice to be able to delete this look from there, or even just the content validator.

1 reply

powellandy
Userlevel 3

Hi,



I can answer some of these points. Firstly there’s no way to delete a Look from the content validator view.



Next it is indeed possible to delete a look on the Look page by clicking the cog in the top right-hand corner:





There is also a way to examine looks. You can use the i__looker/look explore. Link is





https://your-instance-name.looker.com/explore/i__looker/look/





In the explore filter on look.deleted_date is null for all non-deleted Looks.



You can add look.id, query.explore, query.model, query.formatted_fields, and query.viz_config to find out info about explore, model, fields and viz used in the Look. A sample URL would be





https://your-instance-name.looker.com/explore/i__looker/look?fields=look.id,query.view,query.model,query.formatted_fields,query.vis_config&f[look.deleted_date]=NULL&limit=500





Unfortunately I don’t believe there’s an easy way to filter to the Looks shown as invalid by the content validator. This feature would be a great addition. But you can filter down to specific looks after getting the IDs from the content validator.



There are plenty of other fields you can add too, I encourage you to have a play.



Best,


Andy

Reply


Terms of Service