Skip to content

Instantly share code, notes, and snippets.

@YumaInaura

YumaInaura/BIGQUERY.md

Last active August 21, 2018 21:07
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/eac451fef9221316c8c484ddd93733d3 to your computer and use it in GitHub Desktop.
Save YumaInaura/eac451fef9221316c8c484ddd93733d3 to your computer and use it in GitHub Desktop.
Download ZIP
BigQuery—WebUI useful small but strong tips
Raw
BIGQUERY.md

BigQuery—WebUI useful small but strong tips

TIPS. Show table schema while writing query

  • Control + Click (Windows)
  • Command + Click (Mac)

You can check table definition anytime.

image

TIPC. Compose query and Run query with shortcut

Compose query

  • Control + Space ( Windows )
  • Command + Space ( Mac )

Run query

  • Control + Enter ( Windows )
  • Command + Enter ( Mac )

TIPS. Auto saving query and get unique URL

You can save your query and results with URL in your address bar.

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

TIPS. Show column data type by on cursor column name

Below is In OLD WebUI case.

image

TIPS. Run query from selection

Select part of query and choice "Run selected".

image

You don‘t need anymore edit and undo or open new tabs for run part of query .

Shortcut is …

  • Control + E (Windows)
  • Command + E (Mac)

Shortcut help helps you as many sides

Using the BigQuery Web UI  |  BigQuery  |  Google Cloud

image

Links

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