Delete a table 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 delete a table 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'
  • Select the table id and click on 'Delete Table'

A DELETE request is made to delete the table.

DELETE https://bigquery.googleapis.com/bigquery/v2/projects/second-inquiry-315605/datasets/my_dataset_2/tables/my_table_7 HTTP/1.1