Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

What are the bigquery keyboard shortcuts?

Tags:

google-bigquery

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
Sign in to Comment

Related questions

How to generate series in BigQuery Standard SQL
How can I find a Google BigQuery dataset size, not table sizes?
BigQuery: SPLIT() returns only one value
Mocking Bigquery for integration tests
FLATTEN with TABLE_DATE_RANGE
Can you use field alias with space in Google Big Query
Using IF in BigQuery SQL
Error: Not found: Dataset my-project-name:domain_public was not found in location US
Does BigQuery support UPDATE, DELETE, and INSERT (SQL DML) statements?
Google BigQuery, I lost null row when using 'unnest' function
BigQuery StandardSQL: Last 7 Days using _TABLE_SUFFIX
BigQuery: convert epoch to TIMESTAMP
Querying multiple tables in Big Query
How to manage schema migrations in Google BigQuery
Create a table from query results in Google BigQuery
WITH in BigQuery
BigQuery - Check if table already exists
Converting JSON into newline delimited JSON in Python
Migrating from non-partitioned to Partitioned tables
Populating a table with all dates in a given range in Google BigQuery

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!