Does `sql_trigger` work for data groups used in normal explores, or just PDTs?
For a normal explore (not a PDT), I’ve been testing the below `sql_trigger` which should pretty much refresh every time I refresh the dashboard since the value returned will always change, being that it’s a timestamp.
datagroup: product_page_daily {
sql_trigger: SELECT CURRENT_TIMESTAMP() ;;
}
However, it still keeps using the cache:
Solved! Go to Solution.
Yeah, it’s set to the default:
Therefore, I agree–it should be resetting every 5 minutes when the sql trigger is run.
Update: You know what, I think this is because I didn’t have my change the sql_trigger published. I’m guessing it needs to be on the master branch since the sql_triggers are run externally by a cron job (instead of based on my branch’s code, probably). I will test this.