Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What are the bigquery keyboard shortcuts?

Google's bigquery editor has keyboard shortcuts. For example ctrl+space composes a new query. I suspect there are more shortcuts, but I haven't found an useful list of them. Does anyone know them?

like image 959
Ben Haley Avatar asked Oct 15 '15 01:10

Ben Haley


People also ask

How do I run a selected query in BigQuery?

Ctrl + E : Run query from selection.

Is there an IDE for BigQuery?

I would recommend superQuery. It's a full-fledged IDE for Google BigQuery with all the features you would like to find in modern IDE, web-based, including multi-tab, collaboration, git integration, cost controls, result visualizations, shareable boards, auto-complete and more!

What SQL language is BigQuery?

BigQuery supports the Google Standard SQL dialect, but a legacy SQL dialect is also available. If you are new to BigQuery, you should use Google Standard SQL as it supports the broadest range of functionality. For example, features such as DDL and DML statements are only supported using Google Standard SQL.


1 Answers

  • Ctrl + Space: If no query is open: compose new query. If query editor is open: autocomplete current word.
  • Ctrl + Enter: Run current query.
  • Tab: Autocomplete current word.
  • Ctrl: Highlight table names.
  • Ctrl + click on table name: Open table schema.
  • Ctrl + E: Run query from selection.
  • Ctrl + /: Comment current or selected line(s).
  • Ctrl + Shift + F: Format query.
    (on Mac, replace Ctrl with Cmd)

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

like image 57
Sonya Avatar answered Sep 18 '22 07:09

Sonya