The Google Cloud console provides a graphical interface that you can use to createand manage BigQuery resources and run SQL queries.
To try BigQuery in the Google Cloud console, see the quickstartQuery a public dataset with the Google Cloud console.
Before you begin
- 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.
Go to project selector
-
In the Google Cloud console, on the project selector page, select or create a Google Cloud project.
Go to project selector
-
Enable the BigQuery API.
Enable the API
For new projects, the BigQuery API is automatically enabled.
- 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 you a sandbox to perform the steps. For more information, see Enable the BigQuery sandbox.
Open BigQuery in the Google Cloud console
Go to the Google Cloud console.
Go to the Google Cloud console
In the Google Cloud console toolbar, clickmenu Navigation menu.
In the Analytics section, click BigQuery.
You can also open the BigQuery page by entering the following URL in yourbrowser:
https://console.cloud.google.com/bigquery
BigQuery opens in your most recently accessed project.
To simplify navigation, you can add (or pin) BigQuery as a topproduct in the navigation menu:
In the Google Cloud console navigation menu, hold the pointer overBigQuery.
Click push_pin Pin.
Overview of the BigQuery page
The BigQuery page has three main sections:
- The BigQuery navigation menu
- The Explorer pane
The details pane
Navigation menu
In the BigQuery navigation menu, you can select the followinganalysis, migration, and administration options:
BigQuery Studio, which displays your datasets, tables, and otherBigQuery resources. In this workspace, you can performcommon BigQuery tasks such as the following:
- Create, run, save, and share queries and Colab Enterprisenotebooks.
- Work with tables, views, routines, and other BigQueryresources.
- See your BigQuery job history.
Data transfers, which opens the BigQuery Data Transfer API page.
Scheduled queries, which displays your scheduled queries.
Analytics Hub, which displays all of the data exchanges that you canaccess in your Google Cloud project.
SQL translation, which lets you convert your Teradata SQL queries sothat they work in BigQuery.
Capacity Management, which displays slot commitments, reservations,and reservation assignments.
BI Engine, which opens the BI Engine page.
You can control how the BigQuery navigation menu is displayed:
To collapse the navigation menu so that only the icons are visible, click
Hide BigQuery navigation menu.
To temporarily expand the menu when it's collapsed, hold the pointer overthe menu.
To expand the menu so that the labels stay visible, click
Show BigQuery navigation menu.
Explorer pane
The Explorer pane is visible when you select BigQuery Studio in thenavigation menu. This pane lists current Google Cloud projects and any starredprojects.
To view the resources in your projects and datasets, do the following:
To view the datasets that you have access to in a project, expand theproject.
To view tables, views, and functions in a dataset, expand the dataset.
You can also use the search box to search for resources by name (dataset, table, or view name) orby labelwithin your current and starred projects. The search box finds the resources thatdirectly match, or contain matches, to your search query. It might not showall the resources in the matched resource's level. To see all the resources,click Show more.
You can control how the Explorer pane is displayed:
To collapse the Explorer pane, click thefirst_page icon.
To expand the Explorer pane, click thelast_page icon.
Details pane
The details pane shows information about your BigQuery resources.When you select a dataset, table, view, or other resource in the Explorerpane, a new tab is displayed. On these tabs, you can view information about theresource, or you can create tables and views, modify table schemas, export data,and perform other actions.
When you navigate through tabs, the resource corresponding to the focused tabis selected in the Explorer pane. If you open BigQuery usingyour workspace URL, then your workspace query editor tab opens, and thecorresponding resource is selected in the Explorer pane.
Work with projects
All of the work that you perform in BigQuery is done within aGoogle Cloud project. You can see the project name on theGoogle Cloud console toolbar:
Any costs that you incur for using BigQuery are charged to thebilling account that's attached to the project. For more information, seeBigQuery pricing.
Switch to a project
To switch to a Google Cloud project in the Google Cloud console, followthese steps:
On the Google Cloud console toolbar, click the name of your project.
In the projects dialog, click the name of the project that you want toswitch to.
This selection becomes your active project.
Star a project
You can star a Google Cloud project to the Explorer pane in the followingthree ways:
If you have access to a dataset or table but don't have access to theproject that contains that dataset, follow these steps:
In the Explorer pane, clickadd Add data.
In the Add data dialog, click Star a project by name.
In the dialog, enter the name of the project that you want to star.
If you have the Viewer (
roles/viewer
) IAM role on theproject, you can follow one of the following methods:Method 1
Switch to the project that you want to star.
In the Explorer pane, hold the pointer over the name of the projectthat you want to star, and then clickstar_border Star.
Method 2
In the Explorer pane, clickadd Add data.
In the Add data dialog, click Search for and star a project:
In the dialog, click the name of the project that you want to star.
Remove a project
To remove a project from the Explorer pane, click the name of the project,and then clickstar Unstar.
Display resources
The Explorer pane lists datasets that you can browse in your currentproject or any projects that you starred.
- To display the datasets in a project, clickarrow_right Toggle node for thatproject.
- To display the tables, views, and functions in a dataset, click thedataset.
To display information about a resource in a project or dataset, click the nameof the resource in the Explorer pane and view the details pane. The set ofavailable actions depends on the resource. For example, the following imageshows the tab for a table:
Star resources
If you have important or current projects, datasets, or tables, you can star themin the Explorer pane. To star a resource, hold the pointer over the name ofthe resource that you want to star, and then clickstar_border Star.
For more information on starring a project, seeStar a project.
View starred resources
To view only the starred resources in the Explorer pane, clickShow starred resources only in the Explorer pane.
To view all the resources in the Explorer pane, clickShow all resources.
Unstar resources
To unstar a resource, clickstar Unstar next to the resource.
Welcome tab
The first time you open BigQuery, you see the welcome taband a query editor tab, with the welcome tab in focus. The welcome tab containsthe following demo guides:
Run a sample query on a public dataset from Google Trends.
Add data to BigQuery.
You may close the welcome tab, but it appears again when you refresh the page.If you want to see the welcome tab on startup, select theShow welcome page on startup checkbox. To go back to the welcome tab, click Welcome.
To open a query editor from the welcome tab, clickadd_box Compose a new query. To accessways to import data and search data sources that work withBigQuery, click add_box Add data.
If you open BigQuery using your workspace URL, thenyour workspace query editor tab opens first.
Run query demo guide
The Get started section contains the demo guide for running a samplequery on a Google Trends public dataset.
To run the demo guide, follow these steps. To exit the demo at any time,click close Close tour.
In the Google Cloud console, go to theBigQuery page.
Go to BigQuery
Ensure that you are on the BigQuerywelcome page: click
Welcome.
Click search Open this query.
The
bigquery-public-data
project is automatically added to the Explorerpane. The public project and thegoogle_trends
dataset are expanded, andthe Google Trends Data dialog highlights the starredtop_terms
table.Additionally, the query editor is opened with a predefined query.In the Google Trends Data dialog, click Next.
In the Google Trends Query dialog, click Next.
To return to the previous step, click Back in the dialog.
In the Run this query dialog, click Try it.
To return to the previous step, click Back in the dialog.
In the Query results dialog, click Done.
You can run this demo multiple times.
To view the Google Trends public dataset, in the welcome page, clickView dataset.
Run add data demo guide
The Add your own data section contains the demo guide for adding data toBigQuery through popular sources.
To run the demo guide, follow these steps. To exit the demo at any time,click close Close tour. To return to theprevious step where applicable, click Back.
In the Google Cloud console, go to theBigQuery page.
Go to BigQuery
Ensure that you are on the BigQuerywelcome page: click
Welcome.
Click Launch this guide for one of the three options: local file, Google Drive, or Cloud Storage.
In the Open Add Data panel dialog, click Try it.
The source type that you selected is highlighted on the Add data pane.
In the Select source dialog, click Try it.
In the Configure source details dialog, click Next.
In the Configure destination details dialog, click Next.
In the Create table dialog, click Done.
You can run this demo guide only once through either of the three available sourcesin the Add your own data section. After you complete the demo, theLaunch this guide buttons change to Add data and act as a shortcutto the Create table subtask.
View recently accessed resources
In the Google Cloud console, you can view your 10 most recently accessed resources.These resources include tables, saved queries, models, and routines.
When you create or update a resource in the console or queryeditor, the resource is marked as recent. For a recently openedresource to be marked as recent, you have to open it in the workspace tab. Ifyou run a query on a resource, then the resource is not marked as recent.
To view your recently accessed resources, follow these steps:
In the Google Cloud console, go to the BigQuery page.
Go to BigQuery
Ensure that you are on the BigQuerywelcome page: click
Welcome.
In the Recently accessed section, you see your 10 recently accessedresources:
You can star or open a resource in the Recently accessed section. To seemore options, click more_vert View actions.
When you delete a recently accessed resource through the consoleor query editor, it is also removed from the Recently accessed section. Ifanother user deletes your recently accessed resource or if you lose permissionto that resource, you might still see the resource in the Recently accessedsection. When you try to open or star that resource, it disappears and yousee the Resource is no longer available
message.
Work with tabs
You can control how you work with tabs in the details pane.
Split two tabs
Whenever you select a resource or clickadd_box Compose new query in the detailspane, a new tab opens. If more than one tab is open, you can split the tabs intotwo panes and view them side by side.
To split tabs into two panes, follow these steps:
Next to the tab name, clickarrow_drop_downOpen menu.
Select one of the following options:
- To place the selected tab in the left pane, select Split tab toleft.
- To place the selected tab in the right pane, select Split tab toright.
To unsplit the tabs, selectarrow_drop_downOpen menu on one of the open tabs, and then select Move tab to leftpane or Move tab to right pane.
To split tabs when querying tables, follow these steps:
In the Explorer menu, click the table that you want to query.
Click Query, and then click In new tab or In split tab:
Click the field name that you want to query:
The following image shows the details pane with two open tabs. One tab has aSQL query, and the other tab shows details about a table.
Move a tab
To move a tab from one pane to the other pane, follow these steps:
Next to the tab name, clickarrow_drop_downOpen menu.
Select Move tab to right pane or Move tab to left pane (whicheveroption is available).
Close a tab
To close all tabs except for one, follow these steps:
Next to the tab name, clickarrow_drop_downOpen menu.
SelectcancelClose other tabs.
View personal and project history
You can view job histories in the footer of the details pane:
To view details of your own jobs, click Personal history.
To view details of recent jobs in your project, click Project history.
To see the details of a job or to open the query in an editor, do the following:
In the Actions column for a job or query, clickmore_vert Actions.
Select Show job details or Open query in editor.
The job histories include all load, export, copy, and query jobs that yousubmitted in the past six months (up to 1,000 entries). The limit of 1,000 jobsis cumulative across all job types.
Keyboard shortcuts
To view shortcuts in the Google Cloud console, clickkeyboard SQL workspace shortcuts.The following keyboard shortcuts are supported in the Google Cloud console:
Action | Windows or Linux shortcut | macOS shortcut |
---|---|---|
Run query | Ctrl+Enter | Cmd+Enter |
Run selected query | Ctrl+e | Cmd+e |
SQL autosuggest | Tab or Ctrl+Space | Tab or Ctrl+Space |
Gemini code completion and generation | Ctrl+Shift+Space | Ctrl+Shift+Space |
Format query | Ctrl+Shift+f | Cmd+Shift+f |
Toggle line comment | Ctrl+/ | Cmd+/ |
Split or move active tab to right | Ctrl+Alt+] | Cmd+Alt+] |
Split or move active tab to left | Ctrl+Alt+[ | Cmd+Alt+[ |
Open tab menu (keyboard focused tab) | Shift+F10 | Shift+F10 |
Close tab (keyboard focused tab) | Delete or Backspace | Delete or Backspace |
See list of editor shortcuts | F1 | F1 |
Examples
You can find Google Cloud console examples throughout the how-to guidessection of the BigQuery documentation.
To see examples of loading data and querying data using theGoogle Cloud console, see theLoad and query data with the Google Cloud console.
What's next
- To learn about querying a public dataset and using the BigQuery sandbox,see Querya public dataset with the Google Cloud console.