The BigQuery browser provides access to sources stored as BigQuery tables. You may browse, search, and select the tables that you want to use as sources for your dataset.
- The browser appears when you select the BigQuery tab to create a dataset. See Import Data Page.
- For more information, see Using BigQuery.
- For more information on how data types are converted to and from BigQuery sources, see BigQuery Data Type Conversions.
Figure: BigQuery Browser
If you have access to multiple projects:
- Reading: you can browse for BigQuery tables in other projects from which to read.
- Writing: you can browse for BigQuery databases that are accessible from other projects to which you have read and write access.
Figure: Enter a project identifier to browse for BigQuery databases and tablesEnter the project identifier in the textbox, and click Go.
Tip: The identifiers for your projects are available from the Projects menu in the toolbar. See Projects Menu.
Tip: You can paste project identifiers from publicly available projects to read from them.
Use the links and icons to browse for databases and tables.
NOTE: Avoid using the Back button on your browser, which exits the browser without applying changes to your configuration.
|Database||Click these links to open a BigQuery database to reveal its tables.|
Click the Plus icon to select this table as your source.
To preview its data, hover over the name of the table, and then click the Eye icon.
Tip: Sizes and update timestamps are calculated and displayed next to tables. They are not displayed next to databases.
Use these links to navigate between pages of databases or tables.
NOTE: In some cases, subsequent pages of tables may be blank, and counts of tables may not match displayed figures. This is a known issue.
Click the links in the breadcrumb trail to navigate.
To filter the list of databases or tables, enter a string in the Search box. The filter is applied as you type and matches anywhere in the name of a currently displayed database or table name.