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__looker
: Thei__looker
model contains accessible SQL text in addition to filter text.Take action: Modify who has view access to the System Activity and
i__looker
models. Looker admins have access to bothi__looker
and System Activity by default. Non-admin users can be granted access to System Activity andi__looker
if they are given thesee_system_activity
permission.
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. See the System Activity Explores page for a list of Explores and their cache rules.
Elite System Activity: An optional analytical store that increases System Activity performance and storage limits.
Read replica option: For customer-hosted instances only, this method increases System Activity performance and provides longer System Activity data retention.
i__looker:
i__looker
is 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.