Professional Cloud Architect – Google Cloud Certification Guide

bq

Now, let's look at the command-line tools for BigQuery. BigQuery was described in more detail in Chapter 11, Analyzing Big Data Options, so in this section, we won't do a deep dive into the service. However, in general, the main ways to interact with BigQuery is to load, export, query, view, and manage data. One of the ways we can do this is from Cloud Shell using the bq command-line tool.

BigQuery can be complex to use from the bq command line, and it is recommended to review the bq command-line tool reference page for full details at https://cloud.google.com/bigquery/docs/bq-command-line-tool.

Let's look at some common use cases. In the following examples, we will create a new dataset, create a table, and then query it:

1. The following ...