Hi
I’m after a way to list all the fields - dimensions and measures - exposed (not hidden) in all explores in a model.
I’ve seen i__looker, but want it for ‘explore’ rather than ‘look’ as below.
https://instance_name.looker.com//explore/i__looker/look
Or do I have to create a data dictionary?
Thanks
Yup, you’re talking about a data dictionary!
@Dave_Trumbull noted a potential option here:
It feels like we’re almost there with the Field Usage Explore that I stumbled upon yesterday. (https://xxxxxxx.looker.com/explore/system__activity/field_usage). If it also had the labels, descriptions and field types, it would suit my immediate needs.
As far as I can tell though, you can’t really build a rich data dictionary with i__looker, but you can via the lookml_model_explore api endpoint. We have a block that helps with that:
The Data Dictionary block pulls up metadata about fields built within the Looker Model (by using the `lookML_model_explore API` call) and displays the fields in a digestible format that provides transparency about metric definitions. The definitions...