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. Both the granularity and retention of System Activity data are subject to system constraints. System Activity is designed for collecting high-volume data, and aggregating it can be used to supplement your business logs.
This data can be useful for supplementing monitoring and auditing activities, but is not intended to replace your current compliance strategy.
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 9 System Activity Explores that power the System Activity dashboards is updated and cached every 12 hours, and data in the remaining Explores is updated and cached every hour. For all System Activity Explores, 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
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.
Understanding PDT log actions: Use the PDT Event Log Explore to view and understand PDT log actions and their corresponding action data.