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

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 ...

Get Professional Cloud Architect - Google Cloud Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.