Elite System Activity

Note: Elite System Activity is a paid feature on Looker (original). Contact a Google Cloud sales specialist to discuss purchasing the Elite System Activity feature.

Elite System Activity is a standard feature on the Enterprise and Embed editions of Looker (Google Cloud core).

Benefits

Elite System Activity includes an analytical store for System Activity data that provides the following benefits:

• System Activity Explores and dashboards remain the same, so the process of viewing System Activity data is no different.
• More System Activity data can be stored. System Activity data can be retained for up to 1 year.
• System Activity queries are offloaded from the Looker instance, which improves System Activity query performance and may improve Looker's performance. Elite System Activity also removes the concurrent query limit on System Activity Explores and dashboards along with the forced 12-hour caching policy for System Activity Explores and dashboards.

Note: This data can be useful for supplementing monitoring and auditing activities, but is not intended to replace your current compliance strategy.

Note: When Elite System Activity is enabled, System Activity dashboards and Explores will query the analytical store, but legacy i__looker Explores won't. If Elite System Activity is enabled, Google Cloud recommends that you update any saved Looks or dashboards that query i__looker and cause them to query System Activity instead.

Refresh intervals

The following tables refresh every 10 minutes:

• event
• event_attribute
• history
• pdt_event_log
• query
• query_api_client_context
• query_metrics
• sql_text

The user table refreshes once an hour.

The following tables refresh every 24 hours:

• access_token
• api_usage
• compliance_user_permissions
• content_metadata
• content_usage
• dashboard
• dashboard_element
• dashboard_layout
• dashboard_layout_component
• db_connection
• field_usage
• group
• group_group
• group_user
• look
• merge_query
• merge_query_source_query
• model_set
• node
• permission_set
• result_maker
• role
• role_group
• role_user
• scheduled_job
• scheduled_job_stage
• scheduled_plan
• scheduled_plan_destination
• session
• slug
• space
• space_user
• sql_query
• user_attribute
• user_facts
• user_facts_role