How long do async query results last for?

Looker Tips & Resources Technical Tips & Tricks
1

Knowledge Drop

Last tested: Feb 12, 2018

If Instant Dashboards are enabled, then async query results are kept for 30 days.

Otherwise, the default time-to-live (TTL) for an async query result set is 5 minutes. This can be changed by setting the --async-results-cache-time startup flag to the number of seconds that results should stay in cache:

--async-results-cache-time=3600

# set result TTL to 1 hour

2

Does the time-to-live countdown start only after the async query is complete?

I.E. - if time-to-live is 5 minutes and the async query task takes 3 minutes, will the results live another 5 minutes after that (so 8 minutes past submission)?