Interacting with BigQuery

There are three main ways you interact with BigQuery:

  • Loading and exporting data
  • Querying and viewing data
  • Managing data

To perform these interactions, you can use:

Loading and exporting data

In most cases, you load data into BigQuery Storage. If you want to get the data back out of BigQuery, you can export the data.

Alternatively, you can set up a table as an external data source, which allows you to query data stored outside of BigQuery.

Querying and viewing data

After you load your data into BigQuery, you can query or view the data in your tables. For example, you can perform the following tasks:

Managing data

In addition to querying and viewing data, you can manage data in BigQuery in the following ways:

  • Listing projects, jobs, datasets, and tables
  • Getting information about jobs, datasets, and tables
  • Defining, updating, or patching datasets and tables
  • Deleting datasets and tables
  • Managing table partitions

Monitor your resources on the go

Get the Google Cloud Console app to help you manage your projects.

Send feedback about...