System Activity is an internal LookML model that connects to Looker’s underlying application database. System Activity Explores and dashboards built upon this model show information about your Looker instance, including all Looks and dashboards saved on your instance, user information, historical query information, and instance performance statistics. This data can be useful for monitoring and auditing purposes.
The text in filters run by users is accessible in System Activity and can be viewed by any user who has permission to view the System Activity model. For customers using
i__lookermodel contains accessible SQL text in addition to filter text.
Take action: Modify who has view access to the System Activity and
i__lookermodels. Looker admins have access to both
i__lookerand System Activity by default. Non-admin users can be granted access to System Activity and
i__lookerif they are given the
System Activity includes the following elements:
System Activity dashboards: Looker-created dashboards showing usage and performance information about the Looker instance. You can download, schedule, set alerts on, and drill into metrics and elements just like on any other dashboard. Data in the System Activity dashboards is updated and cached every 12 hours.
System Activity Explores: Using System Activity Explores, you can create your own Looks and dashboards to monitor and analyze your Looker instance. Data in the System Activity Explores is updated and cached every 12 hours, although you can use the Clear Cache and Refresh option to retrieve up-to-date information.
Elite System Activity: An optional analytical store that increases System Activity performance and storage limits. The table below summarizes some of the differences:
Standard System Activity Elite System Activity Data retention limit 90 days Up to 1 year Concurrent query limit Yes No Caching policy Refresh every 12 hours No forced caching
Read replica option: For customer-hosted instances only, this method increases System Activity performance and provides longer System Activity data retention.
i__lookeris Looker’s legacy set of Explores for internal analytic data.