Merged Query Search
Python script that prints the number, and the ids, of dashboards containing merged queries
Repository Documenter
Python script that exports query info about visualizations in all dashboards into a .csv file. Documented fields include:
- Dashboard Title
- Vis Title
- Query ID
- Model
- View
- Fields
Secure User Spaces
Python script that identifies Looker users whose user space is not secure. By default, a new Looker user's personal space is public to all users. This script will make those spaces private.
User Downgrade
Python script that identifies two types of users:
- User that has not logged into Looker in one year
- User with standard features (Explore/SQL Runner) that has not used the features in three months
and emails them a notification warning of a downgrade or whatever type of messaging you would like.
*This script uses a MySQL Looker application database to identify and log users. That can be replaced by the Looker API or another database based on your use case and Looker setup. Obviously, the date checks in the script can be modified to meet your use case.