Interacting with BigQuery Google Professional Data Engineer GCP

Web UI in the Cloud Console

• graphical web UI in the Cloud Console
• to create and manage BigQuery resources
• to run SQL queries.
• has three main sections: navigation panel for viewing, details panel for more details and query editor to make queries

BigQuery classic web UI

• classic web UI can do tasks like
  • running queries
  • loading data
  • exporting data.

bq command-line tool

• A python-based, command-line tool
• supports two kinds of flags — global flags and command flags.

Flags to be used as

bq –global_flag argument bq_command –command-specific_flag argument

• Global flags (or common flags) can be used in all commands.
• Command-specific flags apply to a specific command.

Separate multiple global or command-specific flags using a space. For example:

bq \

–global_flag argument \

–global_flag argument \

bq_command \

–command-specific_flag argument \

–command-specific_flag argument

Specify command arguments as

• –flag=argument
• –flag=’argument’
• –flag=”argument”
• –flag argument
• –flag ‘argument’
• –flag “argument”

For single or double quotes around arguments –

bq query –nouse_legacy_sql \

‘SELECT

COUNT(*)

FROM

`bigquery-public-data`.samples.shakespeare’