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

Knowledge Drop

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.                

Version history
Last update:
‎04-05-2021 09:09 AM
Updated by: