Skip to Content
Learning Google BigQuery
book

Learning Google BigQuery

by Thirukkumaran Haridass, Eric Brown
December 2017
Beginner to intermediate
264 pages
5h 38m
English
Packt Publishing
Content preview from Learning Google BigQuery

Listing all datasets and all tables in the project

The following code will list all the datasets in the project and all the tables under the datasets in the project. Call this method in the main method and see lists of tables under each dataset:

Do not start your dataset name with an underscore (_) because this convention is used by Google to hide datasets. Hidden datasets contains temp tables generated by the query output.

If the project has a huge number of datasets, then use labels for them; this will make searching for datasets easy via API. Use the ListDatasetsOptions.Filter property to filter datasets by label. To retrieve datasets via ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Google BigQuery: The Definitive Guide

Google BigQuery: The Definitive Guide

Valliappa Lakshmanan, Jordan Tigani
Google BigQuery Analytics

Google BigQuery Analytics

Siddartha Naidu, Jordan Tigani

Publisher Resources

ISBN: 9781787288591Supplemental Content