Menu
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
398
View saved queries Saved query functionality is available only in the Google Cloud console. To view a saved query, open the BigQuery Google Cloud console, expand your project node in the Explorer panel, and then expand the Saved queries ( N ) node, where N indicates the number of saved queries in your project.
Open the BigQuery page in the Google Cloud console. In the Explorer panel, expand your project and dataset, then select the table. In the details panel, click Export and select Export to Cloud Storage.
In addition, BigQuery has free operations and a free usage tier. Each project that you create has a billing account attached to it. Any charges incurred by BigQuery jobs run in the project are billed to the attached billing account. BigQuery storage charges are also billed to the attached billing account.
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:
146
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:
24
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
