syned
syned

Reputation: 111

All saved personal queries disappeared in Google BigQuery

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

Upvotes: 10

Views: 9305

Answers (4)

atoth
atoth

Reputation: 858

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

Upvotes: 13

Deeksha
Deeksha

Reputation: 213

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

Upvotes: 0

syned
syned

Reputation: 111

There was an issue that was fixed by Google. Private queries are available again. See for details https://issuetracker.google.com/issues/119314731

Upvotes: 0

Graham Polley
Graham Polley

Reputation: 14791

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

Upvotes: 2

Related Questions