{"id":192832,"date":"2021-08-07T15:04:54","date_gmt":"2021-08-07T22:04:54","guid":{"rendered":"https:\/\/m2msupport.net\/m2msupport\/?page_id=192832"},"modified":"2021-08-07T15:05:34","modified_gmt":"2021-08-07T22:05:34","slug":"get-the-list-of-tables-in-bigquery-dataset-in-google-cloud-platform-gcp","status":"publish","type":"page","link":"https:\/\/m2msupport.net\/m2msupport\/get-the-list-of-tables-in-bigquery-dataset-in-google-cloud-platform-gcp\/","title":{"rendered":"Get the list of tables 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>\u00a0 application provides an easy interface to get the list of\u00a0 tables in a dataset in the Google Cloud Platform.<\/p>\n<h1>To get the list of tables 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<\/ul>\n<p><a href=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/get_tables.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-192833\" src=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/get_tables.png\" alt=\"\" width=\"845\" height=\"726\" srcset=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/get_tables.png 845w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/get_tables-300x258.png 300w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/get_tables-768x660.png 768w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/get_tables-600x516.png 600w\" sizes=\"auto, (max-width: 845px) 100vw, 845px\" \/><\/a><\/p>\n<p>A GET request is made to get the list of tables.<\/p>\n<p>GET https:\/\/bigquery.googleapis.com\/bigquery\/v2\/projects\/second-inquiry-315605\/datasets\/company\/tables HTTP\/1.1<\/p>\n<p><strong>Server response to get the tables in a dataset<\/strong><\/p>\n<p>{<\/p>\n<p>&#8220;kind&#8221;: &#8220;bigquery#tableList&#8221;,<\/p>\n<p>&#8220;etag&#8221;: &#8220;rTcRgV+cuv0sgMpoeyeP7w==&#8221;,<\/p>\n<p>&#8220;tables&#8221;: [<\/p>\n<p>{<\/p>\n<p>&#8220;kind&#8221;: &#8220;bigquery#table&#8221;,<\/p>\n<p>&#8220;id&#8221;: &#8220;second-inquiry-315605:company.employee&#8221;,<\/p>\n<p>&#8220;tableReference&#8221;: {<\/p>\n<p>&#8220;projectId&#8221;: &#8220;second-inquiry-315605&#8221;,<\/p>\n<p>&#8220;datasetId&#8221;: &#8220;company&#8221;,<\/p>\n<p>&#8220;tableId&#8221;: &#8220;employee&#8221;<\/p>\n<p>},<\/p>\n<p>&#8220;type&#8221;: &#8220;TABLE&#8221;,<\/p>\n<p>&#8220;creationTime&#8221;: &#8220;1628353587167&#8221;<\/p>\n<p>}<\/p>\n<p>],<\/p>\n<p>&#8220;totalItems&#8221;: 1<\/p>\n<p>}<\/p>\n<div class=\"video-responsive\"><iframe loading=\"lazy\" id=\"youTubePlayer\" src=\"https:\/\/www.youtube.com\/embed\/PTaQZSYBH2M?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\/get-the-list-of-tables-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-192832","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/pages\/192832","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=192832"}],"version-history":[{"count":2,"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/pages\/192832\/revisions"}],"predecessor-version":[{"id":192835,"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/pages\/192832\/revisions\/192835"}],"wp:attachment":[{"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/media?parent=192832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}