Use the Cloud console
The Google Cloud console provides a graphical interface that you can use to create and manage BigQuery resources and run SQL queries.
For more information about working with BigQuery by using the Google Cloud console, see Cloud console quickstart.
Before you begin
Before you can use the Cloud console, you must create or select a Google Cloud project.
- Sign in to your Google Cloud account. If you're new to Google Cloud, create an account to evaluate how our products perform in real-world scenarios. New customers also get $300 in free credits to run, test, and deploy workloads.
-
In the Google Cloud console, on the project selector page, select or create a Google Cloud project.
-
In the Google Cloud console, on the project selector page, select or create a Google Cloud project.
- BigQuery is automatically enabled in new projects.
To activate BigQuery in a preexisting project, go to
Enable the BigQuery API.
- Optional:
Enable
billing for the project. If you don't want to enable billing or provide
a credit card, the steps in this document still work. BigQuery
provides a
sandbox to perform the steps.
To learn more about the BigQuery sandbox, including limitations, how to add a billing account and upgrade your project, and troubleshooting, see Enable BigQuery Sandbox.
Opening the BigQuery page in the Cloud console
To open the BigQuery page in the Cloud console:
Open the Cloud console.
In the navigation menu, click BigQuery.
You can also open the BigQuery page directly by entering the following URL in your browser.
https://console.cloud.google.com/bigquery
Or, click here to open the BigQuery page in the Cloud console directly using your most recently accessed project:
Cloud console overview
The Cloud console has three main sections, shown in the following screenshot:
Navigation menu
The navigation menu contains a list of BigQuery resources that you can view:
The SQL workspace section displays your datasets, tables, views, and other BigQuery resources. This is where you can create and run queries, work with tables and views, see your BigQuery job history, and perform other common BigQuery tasks.
The Transfers section opens the BigQuery Data Transfer Service page.
The Scheduled queries section displays your scheduled queries.
The Analytics Hub section displays all data exchanges that you have access to in that project.
The SQL translation tool lets you convert your Teradata SQL queries to work in BigQuery.
The Monitoring section lets you monitor the BigQuery workloads.
The Capacity Management section displays slot commitments, reservations, and reservation assignments.
The BI Engine section opens the BigQuery BI Engine page.
To collapse the navigation menu so that only the icons are visible, click Hide BigQuery navigation menu. To temporarily expand the menu again, hold the pointer over the menu. To expand the menu so that the labels remain visible, click Show BigQuery navigation menu.
Explorer panel
The Explorer panel is visible when you select SQL workspace in the navigation menu. This panel contains a list of your current project plus any pinned projects. To view the datasets that you have access to in a project, expand the project. To view tables, views, and functions in that dataset, expand the dataset.
You can also use the search box to search for resources by name (project, dataset, table, or view name) or search for resources by label. The search box finds the resources that match, or contain matches, within your current and pinned projects.
To use search and autocomplete powered by Data Catalog (beta), in the Try search and autocomplete powered by Data Catalog dialog, click Enable. With this feature enabled, BigQuery loads your results on demand for searches in the Explorer panel and for autocomplete in SQL queries. If you have a large number of resources, Data Catalog improves the Cloud console's performance. It also lets you search for resources outside of your current and pinned projects.
Details panel
The details panel shows information about your BigQuery resources. When you select a dataset, table, view, or other resource in the Explorer panel, the Cloud console opens a new tab in the details panel with information about the resource. From these tabs, you can create tables and views, modify table schemas, export data, and perform other actions.
Working with projects
All of your BigQuery work is done within a project. This project's name can be seen in the navigation panel below the filter datasets box. You can also view the current project by using the platform bar at the top of the page.
All of your work within the project is charged to the billing account attached to the project. For more information on BigQuery charges, see the pricing page.
Switching projects
To switch projects in the Cloud console:
In the platform bar at the top of the page, click your project.
In the projects dialog, click the name of the project in the list. This replaces your previous project in the Cloud console with the one you chose.
Pinning (adding) a project
You can add or pin a project in the Cloud console. A pinned project is listed in the Explorer panel, where you can browse the datasets in the project.
Option 1: Open a project and pin it
To pin a project after opening it, follow these steps:
Switch to the project you want to pin.
In the Explorer panel, select the project name.
Pin the project using one of these options:
- Next to the project name, click Pin .
In the details panel, click Pin project.
Option 2: Select from a list of projects
To pin a project by selecting from a list of projects, follow these steps:
In the Explorer panel, click Add data
.Click Pin a project.
In the dialog, click the name of a project.
Removing a project from the Cloud console
To remove a pinned project, follow these steps:
In the Explorer panel, select the project name.
Unpin the project using one of these options:
- Next to the project name, click Unpin .
- In the details panel, click Unpin project.
Displaying resources
The Explorer panel lists datasets that you can browse in your current project or any projects that you pinned. To display the datasets in a project, click the Expand node
icon next to the project name. To display the tables, views, and functions in a dataset, click the Expand node icon next to the dataset name.To display information about a resource, click the name of the resource in the Explorer panel. Each resource that you select opens a new tab in the details panel. From there, you can perform operations on the resource, such as creating, deleting, sharing, or updating the resource. The set of available actions depends on the resource. For example, the following screenshot shows the tab for a table.
To run a query, in the details panel, click Compose new query. This action opens a new Editor tab where you can enter a SQL query. To run the query, click Run. For more information about querying tables, see Running interactive queries.
Working with tabs
Whenever you select a resource or click Compose new query, the Cloud console opens a new tab in the details panel. If you have more than one tab open, you can split the tabs into two panes and view two tabs side by side.
To split tabs into two panes, follow these steps:
In the corner of any tab, click the Open menu
icon.To place the selected tab in the left pane, select Split tab to left. To place the selected tab in the right pane, select Split tab to right.
To split tabs when querying tables, follow one of these methods:
Click Query > In new tab or Query > In split tab.
Click the field name that you want to query.
The following image shows the SQL Explorer panel with two open tabs. One tab has a SQL query and the other tab shows details about a table.
To move a tab from one pane to the other pane, follow these steps:
In the corner of the tab, click the Open menu
icon.Select Move tab to right pane or Move tab to left pane.
To close all tabs except for one, follow these steps:
In the corner of the tab, click the Open menu
icon.Select Close other tabs.
View personal and project history
Expand the bottom panel to view your personal and project history. The Personal history tab displays information of your recent jobs, whereas the Project history tab displays information of recent jobs in your project.
To see the details of a job or to open the query in an editor, click the
More menu, and select the
respective option.
The job histories in the Cloud console include all load, export, copy, and query jobs that you submitted in the past 6 months (up to 1,000 entries). The limit of 1,000 jobs is cumulative across all job types.
Keyboard shortcuts
The following keyboard shortcuts are supported in the Cloud console:
Key combination (Windows/Linux) | Key combination (macOS) | Action |
---|---|---|
Ctrl+Enter |
Cmd+Enter |
Run current query |
Tab |
Tab |
Autocomplete current word |
Ctrl |
Cmd |
Highlight table names |
Ctrl+E |
Cmd+E |
Run query from selection |
Ctrl+/ |
Cmd+/ |
Comment current or selected lines |
Examples
You can find Cloud console examples throughout the How-to guides section of the BigQuery documentation.
To see examples of loading data and querying data using the Cloud console, see the Load and query data with the Google Cloud console.
What's next
- To learn about querying a public dataset and using the BigQuery sandbox, see Query a public dataset with the Google Cloud console.