Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

When does a cached Big Query job expire?

I am currently using bigquery and whenever a query is run, the job is cached in memory and subsequent pages can be fetched from the cached table. So, is there a fixed expiration date for the cached tables? What factors does the job data persistence depend on? I am trying to see if the job still exists if I come back after a week or a month.

like image 999
theshadowmonkey Avatar asked Feb 02 '26 18:02

theshadowmonkey


1 Answers

Directly from the docs (if you Google "App Engine BigQuery Caching") :

Results are cached for approximately 24 hours and cache lifetimes are extended when a query returns a cached result.

So basically, as long as you get your cached result once every 24 hours, cache should stay indefinitely.

like image 139
Patrice Avatar answered Feb 04 '26 14:02

Patrice



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!