Knowledge Drop

Can you set datagroups to clear cache at a certain time of day?

  • 5 April 2021
  • 0 replies
  • 101 views

Userlevel 5
Badge
  • Looker Staff
  • 172 replies

Last tested: March 2021

Yes! Since datagroups use SQL triggers, you can use the exact same queries as in our docs on `sql_trigger_value`.

In particular, you can use `SELECT FLOOR((UNIX_TIMESTAMP(NOW()) - 60*60*3)/(60*60*24))`, where "3" is the UTC hour of day you'd like to clear cache.

 

This content is subject to limited support.                


0 replies

Be the first to reply!

Reply