Versions Compared

Old Version 1

changes.mady.by.user Nadine Hinojosa

Saved on

compared with

New Version 2

changes.mady.by.user Nadine Hinojosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The following SHOW commands can be used to describe BigQuery schema information.

Anchor
backtotop
backtotop

Table of Contents

SHOW PROJECTS

SHOW PROJECTS

This command lists all the projects that you have direct access to.

Example


Code Block
SHOW PROJECTS

...

Back to top

SHOW DATASETS
SHOW DATASETS
SHOW DATASETS [project_ID]
SHOW DATASETS [project_ID1,project_ID2,project_ID3,...]
SHOW DATASETS [project_ID,...] INCLUDE_PUBLICDATA
This command lists all the datasets from the specified project.
...
The INCLUDE_PUBLICDATA option lists all the datasets in the publicdata project.
Examples

 Code Block
SHOW DATASETS
GO
SHOW DATASETS [sample-project-12345]
GO
SHOW DATASETS [sample-project-12345,shared-project]
GO
SHOW DATASETS [sample-project-12345,shared-project] INCLUDE_PUBLICDATA
GO
...

Back to top
SHOW TABLES
SHOW TABLES
SHOW TABLES [project_ID]
SHOW TABLES [project_ID:dataset_ID]
SHOW TABLES [project_ID:dataset_ID.table]
This command lists all the tables in the specified dataset.
...
To retrieve the properties of a table, specify project ID, dataset ID, and table.
Examples
 Code Block
SHOW TABLES
GO
SHOW TABLES [sample-project-12345]
GO
SHOW TABLES [sample-project-12345:dataset1]
GO
SHOW TABLES [sample-project-12345:dataset1.github_timeline]
GO
SHOW TABLES [dataset1.github_timeline]
GO
...
Back to top
SHOW VIEWS
SHOW VIEWS
SHOW VIEWS [project_ID]
SHOW VIEWS [project_ID:dataset_ID]
SHOW VIEWS [project_ID:dataset_ID.view]
This command lists all the views in the specified dataset.
...
To retrieve the properties of a view, specify project ID, dataset ID, and view.
Examples
 Code Block
SHOW VIEWS
GO
SHOW VIEWS [sample-project-12345]
GO
SHOW VIEWS [sample-project-12345:dataset1]
GO
SHOW VIEWS [sample-project-12345:dataset1.github_timeline_view]
GO
SHOW VIEWS [dataset1.github_timeline_view]
GO
...
Back to top
SHOW FIELDS
SHOW FIELDS [project_ID:dataset_ID.table]
SHOW FIELDS [dataset_ID.table]
SHOW FIELDS [project_ID:dataset_ID.view]
SHOW FIELDS [dataset_ID.view]
This command lists all the fields in the specified table or view.
If project_ID is not specified, it will default to the current project.
Examples
 Code Block
SHOW FIELDS [dataset1.github_timeline]
GO
SHOW FIELDS [sample-project-12345:dataset1.github_timeline]
GO
...
Quote Identifiers
  • You must surround the entire name reference with brackets. For example, [my-project-123:dataset1.tableName].
  • If the dataset, table, or view name starts with a number or is a SQL keyword, use the double quote symbol ( " ) to enclose the dataset, table, or view name.
Back to top