{"id":192836,"date":"2021-08-07T15:12:47","date_gmt":"2021-08-07T22:12:47","guid":{"rendered":"https:\/\/m2msupport.net\/m2msupport\/?page_id=192836"},"modified":"2021-08-07T15:12:48","modified_gmt":"2021-08-07T22:12:48","slug":"delete-a-table-in-bigquery-dataset-in-google-cloud-platform-gcp","status":"publish","type":"page","link":"https:\/\/m2msupport.net\/m2msupport\/delete-a-table-in-bigquery-dataset-in-google-cloud-platform-gcp\/","title":{"rendered":"Delete a table in BigQuery dataset in Google Cloud Platform (GCP)"},"content":{"rendered":"<p>Google&#8217;s BigQuery is an enterprise data warehouse that can execute SQL queries in rapid time. It is highly scalable and runs on Google&#8217;s infrastructure.<\/p>\n<p>Datasets are top-level containers which contains tables and views. A dataset may contain one or more tables.<\/p>\n<p><a href=\"https:\/\/m2msupport.net\/m2msupport\/download-iot-cloud-tester\/\">IoT Cloud Tester<\/a>&nbsp; application provides an easy interface to get the list of&nbsp; tables in a dataset in the Google Cloud Platform.<\/p>\n<h1>To delete a table in a BigQuery dataset,<\/h1>\n<ul>\n<li>In the &#8216;Big Query&#8217; tab, click on &#8216;Tables&#8217; tab.<\/li>\n<li>Get the available datasets for the project<\/li>\n<li>Select a dataset<\/li>\n<li>Click on &#8221;List Tables&#8217;<\/li>\n<li>Select the table id and click on &#8216;Delete Table&#8217;<\/li>\n<\/ul>\n<p><a href=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/delelet_table.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-192837\" src=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/delelet_table.png\" alt=\"\" width=\"847\" height=\"748\" srcset=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/delelet_table.png 847w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/delelet_table-300x265.png 300w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/delelet_table-768x678.png 768w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/delelet_table-600x530.png 600w\" sizes=\"auto, (max-width: 847px) 100vw, 847px\" \/><\/a><\/p>\n<p>A DELETE request is made to delete the table.<\/p>\n<p>DELETE https:\/\/bigquery.googleapis.com\/bigquery\/v2\/projects\/second-inquiry-315605\/datasets\/my_dataset_2\/tables\/my_table_7 HTTP\/1.1<\/p>\n<div class=\"video-responsive\"><iframe loading=\"lazy\" id=\"youTubePlayer\" src=\"https:\/\/www.youtube.com\/embed\/BMPgg0ejXl0?hd=1\" width=\"750\" height=\"421\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Google&#8217;s BigQuery is an enterprise data warehouse that can execute SQL queries in rapid time. It is highly scalable and runs on Google&#8217;s infrastructure. Datasets are top-level containers which contains tables and views. A dataset may contain one or more &hellip; <a href=\"https:\/\/m2msupport.net\/m2msupport\/delete-a-table-in-bigquery-dataset-in-google-cloud-platform-gcp\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"iot_tutorial_template.php","meta":{"footnotes":""},"class_list":["post-192836","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/pages\/192836","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/comments?post=192836"}],"version-history":[{"count":1,"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/pages\/192836\/revisions"}],"predecessor-version":[{"id":192838,"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/pages\/192836\/revisions\/192838"}],"wp:attachment":[{"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/media?parent=192836"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}