Knowledge Drop

Can I temporarily stop or pause a scheduled look or dashboard from going out?

  • 5 April 2021
  • 1 reply
  • 189 views

Userlevel 4

Last Tested: Oct 2, 2020

 

Not natively in the product, but there is a feature request.

Basic Workaround

In order to stop a scheduled look or dashboard, the user has to delete it entirely from the schedules tab in the admin pane. They would then need to recreate the schedule when they want it back.

Alternative Basic Workaround

Through the update_schedule_plan() endpoint, we can set the "enabled'"parameter to "false". This disables the schedule, without fully deleting it. It tells Looker to skip over any possible runs for this schedule - the only nuance with this method is that if we did skip over any runs while it was disabled, when we enable this again it will run once (no matter how many skipped runs happen) right away.

Other Workaround

If you host your own instance, you can restart looker with startup flag options to stop schedules -
--scheduler-threads=0 will disable the scheduler -
BUT once you bring it back, the backlogged schedules will need to run

Another workaround we can try is using a dummy datagroup with a static sql_trigger, so that the value never changes, and trigger the schedule on this datagroup. Or, we can set it to only send if results (if the results aren't changing).

 

This content is subject to limited support.                

 


1 reply

Userlevel 2

I wrote an example script using the Looker API (the second workaround in this article). Click here

Reply