"Field Usage" System Activity explore retention
Is the retention of Field Usage Explore (/explore/system__activity/field_usage) is same as History explore i.e...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
Does access to system_activity make a "viewer" user into a "standard" user?
Knowledge DropLast tested: Aug 9, 2019 ContextIn most contracts, a "viewer" user is one who can't explore.Howe...
What System Activity explore query will give me the same info as the Admin --> Queries panel?
Knowledge DropLast tested: Aug 25, 2020 Yes! We can use the following System Activity query appended to our ho...
How do I find how many lookless tiles my dashboards have in system activity?
Knowledge DropLast tested: Feb 5, 2018 Go to the dashboard explore (explore/system_activity/dashboard) and sel...
Can I migrate System Activity Dashboards?
Knowledge DropLast tested: Apr 13, 2020 YESScenario:I have a System Activity Dashboard that I've created on on...
Error: Not authorized to run scheduled plan
Knowledge DropLast tested: May 25, 2020 This error may come up in existing schedules that "worked" fine due to...
Can I see user event activity in system activity? For example, seeing which users committed code?
Knowledge DropLast tested: May 13, 2020 Yes, we have the /event and /event_attribute explores in system activi...
Can you restore a folder after you delete it?
Knowledge DropLast tested: Oct 2, 2019 Not directly but you can get back to the old state with some work. We w...
How do I look up unused PDTs in system activity?
Knowledge DropLast tested: Sep 8, 2020 This link will help navigate you to the pdt_event_log explore (Be sure ...
System Activity History: Result source is "stale_cache"
Knowledge DropLast tested: May 28, 2020 If the value for the History table's Result Source field is "stale_cac...
Wrong numbers in user_facts view
Knowledge DropLast tested: Apr 6, 2020The user_facts view is rebuilt every hour on the hour, so if you are mak...
What is the difference between history and query create date?
Knowledge DropLast tested: Oct 16, 2020 Query created date is the time that a specific query was first run. Th...
How can I find out who added a dashboard tile to my dashboard, and when?
Knowledge Drop Last tested: May 2021You can't see this in the UI at the moment, but you can use the dashboard ...
Who can use System Activity?
Knowledge Drop Last tested: June 2020Admins, and any user with the `see_system_activity` permission, can use t...
How are 2FA enabled/disable events tracked?
Knowledge DropLast tested: Jul 13, 2019You can look forupdate_totp_config in the logs and in the System Activi...
Why do I see a ridiculously high count of login events while looking at the System Activity event explore?
Knowledge DropLast tested: Aug 23, 2018When a user logs in using OpenID auth (i.e. Okta, OneLogin, etc.), Look...
Can you SSO embed System Activity content?
Knowledge DropLast tested: Jan 16, 2018No, because the see_system_activity permission is not available in the ...
What is the difference between the query id and history id in system activity?
Knowledge DropLast tested: June 2021The query ID is tied to a particular query. It's uniquely identified by a ...
What does history count by source in System Activity mean?If you are looking at an explore like this that count represents the number of queries run from each source - the count matches the query run count measure in this situation
Knowledge DropLast tested: Jul 1, 2020If you are looking at an explore like thisthat count represents the numb...
How can I tell which dashboards are auto-refreshing?
Knowledge DropLast tested: Apr 21, 2020 There is a "Refresh Interval" field in the Dashboard explore in System...
Can I query system activity via the API?
Knowledge DropLast tested: Nov 23, 2018 Yes! As long as the user whose API credentials are being used has the ...
Can I access, develop or extend the System Activity model?
Knowledge DropLast tested: May 12, 2020 No, at this time users cannot access, develop or extend the system act...
What is cache_only_miss in the system activity History explore?
Knowledge DropLast tested: May 14, 2020 Looker has a feature that will fetch results from the cache if they ex...
What timezone are the i__looker / System Activity timestamps in for the history explore?
Knowledge DropLast Tested: May 22, 2019 At a high level: i__looker/System Activity timestamps are in System Ti...
Why doesn't my user COUNT() in History explore match total existing users? (System Activity)
Knowledge DropLast tested: Nov 7, 2020 The History explore in System Activity is NOT the best place to see ALL...
Why are there events in the Events explore without associated users?
Knowledge DropLast tested: Oct 20, 2020There are some events, likeupdate_user_facts_chunk or mail_sent that ar...
Can I send System Activity data to other users or non-admins?
Knowledge DropLast tested: Mar 9, 2018 Yes, you can send System Activity content to other users, even non-Admi...
Schedule a System Activity report that sends when other scheduled reports fail
Knowledge DropLast tested: Nov 7, 2020 Using System Activity you can tell if a scheduled report was successful...
Can I see a list of all User Attributes in System Activity?
Knowledge DropLast Tested: Sep 4, 2019 No, User attributes are encrypted and at this time we do not have acces...
