Get the list of tables in BigQuery dataset in Google Cloud Platform (GCP)

Google's BigQuery is an enterprise data warehouse that can execute SQL queries in rapid time. It is highly scalable and runs on Google's infrastructure.

Datasets are top-level containers which contains tables and views. A dataset may contain one or more tables.

IoT Cloud Tester  application provides an easy interface to get the list of  tables in a dataset in the Google Cloud Platform.

To get the list of tables in a BigQuery dataset,

• In the 'Big Query' tab, click on 'Tables' tab.
• Get the available datasets for the project
• Select a dataset
• Click on ''List Tables'

A GET request is made to get the list of tables.

GET https://bigquery.googleapis.com/bigquery/v2/projects/second-inquiry-315605/datasets/company/tables HTTP/1.1

Server response to get the tables in a dataset

{

"kind": "bigquery#tableList",

"etag": "rTcRgV+cuv0sgMpoeyeP7w==",

"tables": [

{

"kind": "bigquery#table",

"id": "second-inquiry-315605:company.employee",

"tableReference": {

"projectId": "second-inquiry-315605",

"datasetId": "company",

"tableId": "employee"

},

"type": "TABLE",

"creationTime": "1628353587167"

}

],

"totalItems": 1

}