This page provides an overview of ways to interact with BigQuery.
There are three main ways you interact with BigQuery:
To perform these interactions, you can use:
- The BigQuery web UI in the Cloud Console
- The BigQuery classic web UI
- The BigQuery REST API or client libraries
Loading and exporting 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:
- Run interactive queries
- Run batch queries
- Create a view, which is a virtual table defined by a SQL query
- Use partitioned tables to query a subset of your 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
- For more information about using the BigQuery web UI, see Using the BigQuery web UI.
- For more information about using the
bqcommand-line tool, see Using the
- To learn more about accessing BigQuery programmatically, see the REST API reference or the BigQuery client libraries page.