Using the look explore in the i__looker model


(Zachary Michel) #1

###Introduction
One of the features Looker provides Admin users with is access to the Usage panel, which is a direct connection to the Looker internal database. The model built on top of this database is called i__looker and we can access specific explores within the model using Looker’s general url query structure - https://host.looker.com/explore/model_name/explore_name?

For this specific case, we will want to access the look explore. https://host.looker.com/explore/i__looker/look?

###The Look Explore
The fields accessible in the look explore are pulled from the look, user, query, and space tables. Each entry in the look table will have a distinct user_id, query_id, and space_id for the respective user who created it, set of query fields and parameters, and a space that it lives in.

Here’s how the explore looks (v. 3.26):

These tables are historical throughout the instance, thus all deleted looks and spaces still exist. One of the key points is to always filter on Table deleted date is NULL for whichever table you want to query against.

Example: I want to find a list of all active Looks on my instance, which space they live in, which users created them, and what fields are used.

Quick link - append this bad boy to your host url.
explore/i__looker/look?fields=look.title,space.name,user.name,query.formatted_fields&f[look.deleted_date]=NULL&f[space.deleted_date]=NULL&sorts=look.title&limit=500&query_timezone=America%2FLos_Angeles&vis=%7B%7D&filter_config=%7B%22look.deleted_date%22%3A%5B%7B%22type%22%3A%22null%22%2C%22values%22%3A%5B%7B%22date%22%3A%222015-08-17T17%3A13%3A48.930Z%22%2C%22unit%22%3A%22day%22%7D%2C%7B%7D%5D%2C%22id%22%3A0%7D%5D%2C%22space.deleted_date%22%3A%5B%7B%22type%22%3A%22null%22%2C%22values%22%3A%5B%7B%22date%22%3A%222015-08-17T17%3A13%3A48.930Z%22%2C%22unit%22%3A%22day%22%7D%2C%7B%7D%5D%2C%22id%22%3A1%7D%5D%7D&dynamic_fields=%5B%5D&show=data%2Cfields&origin=share-expanded


I__looker - monitoring Looker usage
Monitor the errors your team encounters using i__looker
How to see View Connections (Dashboards + Explores)
How to recover a deleted Look using i__looker (before Looker 4.8)