###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