All saved personal queries disappeared in Google BigQuery

user_2080756 0
Viewed 6095

Today I loged in to BigQuery and found all of my saved personal queries disappeared. It says No saved queries yet. Write and save a query to get started.

I had a lot of large queries that I still need and I have no desire to rewrite it from scratch.

Project queries are still there, I can perform new queries and go through query history. I tried to log out and log in several times with zero effect. Have someone encountered this kind of issue before?

I would appreciate any help!

Update: I submitted the bug to Google's Issue Tracker https://issuetracker.google.com/issues/119349142

google-bigquery
4 Answers

Edit (2022-07-18)

As user @rurp mentioned SAVED QUERIES is now available both below and in the left panel (see screenshot).

Saved queries in BigQuery is now in Explorer

Original

If anyone looking for where the SAVED QUERIES are and found that the legacy UI is no longer available and found that the docs are outdated (it says check in the "left side navigation") this is where you can find it in 2021:

Location of Saved queries in BigQuery tab of Google Cloud Platform

user_20187710

Looks like a bug in the new/beta console UI. Mine have also disappeared. As a workaround, go to the old BigQuery UI here. You should see them there:

enter image description here

enter image description here

user_28772780
user_20807560

As per the latest update, this is where you can find saved queries: enter image description here

user_86975130
Related