Geek Answers Handbook

What are the bigquery keyboard shortcuts?

Google bigquery has keyboard shortcuts. For example, ctrl + space creates a new request. I suspect there are more shortcuts, but I did not find a useful list of them. Does anyone know them?

+6
source share
4 answers
  • Ctrl + Space : if the request is not open: make a new request. If the query editor is open: autocomplete the current word.
  • Ctrl + Enter : execute the current request.
  • Tab : Autocomplete the current word.
  • Ctrl : Select table names.
  • Ctrl + click on the table name: Open the table.
  • Ctrl + E : execute the query from the selection.
  • Ctrl + / : comment on the current or selected line (s).
  • Ctrl + Shift + F : format request.
    (on Mac, replace Ctrl with Cmd )

This is a list from the official documentation: https://cloud.google.com/bigquery/bigquery-web-ui#keyboardshortcuts

+9
source

I found myself constantly updating the bq page by accidentally pressing F5 , as this is commonly used by a shortcut in many data tools to execute the / script request. Therefore, in the recently published Chrome extension - BigQuery Mate - I added F5 to execute the query in the query editor.

Just added:

I realized (a little back) that another shortcut is now available that I did not know or did not see anyone mentioned earlier, and was not available at the moment this question was asked:

While your mouse is above the Query Editor - pressing Alt - puts you in copy mode of any rectangular part of your code. Very useful!

July 7, 2016 Update:

I thought it was also useful to update this post with some BgQuery Mate keyboard shortcuts:

  • F5 - execute request
  • Ctrl + F5 - make a selection
  • F1 - help with a keyword / function of the selected one or a sub-cursor - opens the corresponding documentation (sensitivity to SQL version - outdated / standard)
  • Ctrl + Alt + / and Shift + Ctrl + Alt + / - comment / uncomment out of selection Context menu
  • Right Click > BigQuery Mate > Help for the selected keyword / function - opens the corresponding documentation (SQL Version sensitive - Legacy / Standard)
  • Right Click > BigQuery Mate > Preserve Format somewhere in the editor - save format - adjust the query text so that further copy / paste saves the case
+5
source

I don't know them all, but this seems like a good place to share what I know:

  • ctrl + enter : query is running

  • tab : autocomple

  • Keep ctrl pressed: selects tables, clicking on them brings you to it

(note that in Apple ctrl there may be a command key - I did not know about ctrl + space , but it can be overloaded by mac os)

+4
source

Continuing with the answer from Felipe Hoffa, the following keyboard shortcuts work on Mac:

  • ctrl + enter : a request is executed (same as Windows)
  • tab : autocompletes
  • keep the command key pressed: selects tables, clicking on them brings you to it.
+1
source

More articles:


All Articles