BigQuery Saves Your Query Results — Here’s How to Find Them

Photo by Lacey Williams on Unsplash

Ever run a heavy BigQuery SQL query, processed gigabytes of data — and then accidentally closed the tab or forgot to save the results? 😬

Don’t re-run it. Your results are still there.

BigQuery automatically saves query results to an anonymous temporary table for 24 hours. You can find it under Job Information → Temporary Table.

This is also the engine behind BigQuery’s caching behavior: if you run the exact same query again within that window — with no changes — BigQuery serves results directly from cache, at no charge.

One caveat worth knowing: if your result set exceeds 10 GB (that’s the output, not the data scanned), it won’t be cached. So for very large result sets, you’ll want to write results to a permanent table explicitly.

Originally published on my blog Datawise