Database Reference
In-Depth Information
Figure 3.5
BigQuery Welcome screen
You can navigate the data in your projects using the left side panel. If you
have only one BigQuery-enabled project you can access, it should already be
selected by default. If this is the case, the project you just created, BigQuery
Examples, should appear in the navigation panel to indicate that it is the
current project. If you have more than one project, you can switch between
them by clicking the arrow next to the project title and selecting Switch to
Project.
Because your project was just created, there is no data under the project, so
there is not much to see. However, all BigQuery users have access to a public
dataset containing tables that can be used to try BigQuery. Click the link
publicdata:samples
to open the dataset. You see a list of names appear
under the link corresponding to tables available in this public dataset. The
datasets referenced in the sample code in this topic are available publicly
so that you can query them without having to load your own versions. To
view them in this interface, click the arrow next to the project title, and
select Switch to Project Display Project. In the dialog that appears,
enter
bigquery-e2e
in the Project ID field and click OK. You see additional
datasets appear in the navigation panel.
Now that you have access to a couple tables, you can explore the data in
those tables. Click the
natality
table under
publicdata:samples
to
see that the main panel changes to display the schema of the table. This
table contains birth records collected by the U.S. government. Click the
Details button that appears on the top-right corner of the main panel to see
a summary of the table and a sample of the records contained in this table.
