# Exploring the BigQuery Query History

---
title: "Exploring the BigQuery Query History"
seoTitle: "Understanding BigQuery Query History"
seoDescription: "Discover how BigQuery's Job History helps track and retrieve past queries efficiently with filtering options and saved results for recent queries"
datePublished: Wed Feb 19 2025 09:46:00 GMT+0000 (Coordinated Universal Time)
cuid: cm7bqa747000o09l54f2jex14
slug: exploring-the-bigquery-query-history
cover: https://cdn.hashnode.com/res/hashnode/image/stock/unsplash/afW1hht0NSs/upload/7044ae79c50580b2b3314f80f33f5bff.jpeg
tags: databases, google-cloud, sql, bigquery, gcp, data-engineering

---

Here’s a BigQuery trick I use all the time—seriously, not saying this to make my post catchier 😁.  
  
It’s not flashy or very complicated, but it’s one of my favorites: Job History.  
  
Under the Query Editor, you’ll find Job History, which stores all past queries—either your own (Personal History) or those run by others in the project (Project History).  
  
🔍 Why is this useful?  
  
✅ Quickly find queries you forgot to save.  
  
✅ Filter by date, SQL definition (summary), or user to track down past work.  
  
✅ For recent queries, you might even retrieve results from the temporary table—saving you from rerunning expensive queries.  
  
This has saved me so many times after accidentally closing a query tab. (Just remember: if you never executed the query, it won’t be there!)  
  
Also, please be reminded that the job data is also available via an INFORMATION SCHEMA view (check out the comments for a post about that one).

![No alt text provided for this image](https://media.licdn.com/dms/image/v2/D4D22AQFGpdKJ6PunCA/feedshare-shrink_2048_1536/B4DZUZAbT4GcAo-/0/1739881298596?e=1743033600&v=beta&t=UHQg6L0vaIodzQ2HEuT0buNkNKY8Vd6U3VIVg71p9vw align="left")

*Found it useful? Subscribe to my Analytics newsletter at* [***notjustsql.com***](https://notjustsql.com/)*.*

---

*Enjoyed this? Here are some related articles you might find useful:*

- [Change history in BigQuery](https://datawise.dev/change-history-in-bigquery)
- [BigQuery Saves Your Query Results — Here's How to Find Them](https://datawise.dev/bigquery-saves-your-query-results-here-s-how-to-find-them)