Creating Looker usage and metadata reports with i__looker

Caution: The i__looker model has been deprecated in favor of System Activity. See Monitoring Looker usage with System Activity Explores for more information about creating Looker usage and metadata reports.

Looker admins and users who have been granted the see_system_activity permission have access to an instance's Usage panel, which connects directly to Looker's underlying application database, called i__looker. The i__looker database stores information about your Looker instance, including all Looks and dashboards that are saved on your instance, user information, and 90 days of historical queries.

Looker admins have access to i__looker by default. Non-admin users can be granted access to i__looker if they are also given the see_system_activity permission.

Caution: Any user who has the see_system_activity permission can view the SQL text of any SQL query that is run on your Looker instance, as well as any text that is entered into filters.

Chat Team Tip: Time-based data in i__looker is stored in the Looker System time zone. See the Using Time Zone Settings page for more information.