Skip to content

Instantly share code, notes, and snippets.

@YumaInaura
Last active August 22, 2018 04:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save YumaInaura/8cafb1a3542accaaf9813786495623d4 to your computer and use it in GitHub Desktop.
Save YumaInaura/8cafb1a3542accaaf9813786495623d4 to your computer and use it in GitHub Desktop.
BigQuery—Save query and result with unique private URL will be done by automatic ( without specific sharing )

BigQuery—Save query and result with unique private URL will be done by automatic ( without specific sharing )

Run query

image

After run query unique URL provided.

Example URL pattern:

https://console.cloud.google.com/bigquery?project=mb2jp-152723&pli=1&j=bquxjob_6947b1a0_1655c4e25ad&page=queryresults

Edit query and run

URL has changed by automatic in web browser address bar.

image

Example URL pattern:

https://console.cloud.google.com/bigquery?project=mb2jp-152723&pli=1&j=bquxjob_4c90e92f_1655c4f6584&page=queryresults

Access back to first URL

You can see first query and result!

image

https://console.cloud.google.com/bigquery?project=mb2jp-152723&pli=1&j=bquxjob_6947b1a0_1655c4e25ad&page=queryresults

What a wonderful feature on Bigquery.

Limitation

When URL will be expired?

I don’t know but maybe same as Query History's limitation.

Because Query history links to unique URL with auto saving.

The job and query histories in the UI include all load, export, copy, and query jobs you submitted in the past 6 months (up to 1,000 entries). The limit of 1,000 jobs is cumulative across all job types.

Using the BigQuery Web UI  |  BigQuery  |  Google Cloud

Sharing

If you need share query with another people then probably you should choose specific sharing by Save Query feature.

About OLD WebUI

This case is about NEW WebUI Beat on 2018-08 . But I noticed OLD WebUI also has this feature.

Links

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment