Database Reference
In-Depth Information
the service for each new project. None of the other cloud services are strictly
required, but we recommend you also enable Google Cloud Storage (GCS),
which enables additional ways to get data in and out of BigQuery.
Before proceeding to the next step, it is useful to understand how to navigate
the console. The navigation menu is on the left of the main panel and lists
the various sections of the console:
•
Project title
: Displays the name of the currently selected project. This
is also the link back to the project list view.
•
Overview
: Summary of the project settings and sample wizard
•
APIs & auth
: Manage the set of services enabled and access
credentials.
•
Permissions
: Manage project members and permissions.
•
Settings
: Set up billing details. Also delete the project when you no
longer need it.
•
BigQuery
: BigQuery web application.
There are a couple of additional sections but they are not relevant to using
BigQuery. By default, the project is assigned the name My Project, which
appears at the top of the navigation panel. It will be helpful to rename the
project to BigQuery Examples so you can refer to it easily in later sections.
To do this, navigate to Settings and select Rename. Enter the name
BigQuery Examples
in the dialog that opens and save it.
Before you can try any samples that involve API access, you need to set up
authentication keys. Navigate to the APIs & auth section. A Credentials entry
will appear in the navigation panel. Selecting this entry will bring up a panel
that allows you to manage access keys and identities. Clicking on Create New
Client ID launches a dialog that allows you to select the type of client you
require.
The details of each type are beyond the scope of this chapter; for now,
just select Service Account (
Figure 3.2
)
and create the identity. After the
account is created, your browser will receive the secret key and prompt you
to save the file. You will also see a message containing the password for the
secret key, which is always “notasecret.” The password is not intended to
be a strong password. The downloaded file, on the other hand, contains the
secret key that will be used to assert the identity of this service account and
