{"id":192798,"date":"2021-08-07T08:02:59","date_gmt":"2021-08-07T15:02:59","guid":{"rendered":"https:\/\/m2msupport.net\/m2msupport\/?page_id=192798"},"modified":"2021-08-07T08:03:01","modified_gmt":"2021-08-07T15:03:01","slug":"get-the-list-of-bigquery-datasets-in-a-project-in-google-cloud-platform-gcp","status":"publish","type":"page","link":"https:\/\/m2msupport.net\/m2msupport\/get-the-list-of-bigquery-datasets-in-a-project-in-google-cloud-platform-gcp\/","title":{"rendered":"Get the list of BigQuery datasets  in a project 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 datsets in the Google Cloud Platform.<\/p>\n<h1>To get the list of datasets in BigQuery,<\/h1>\n<ul>\n<li>In the &#8216;Big Query&#8217; tab, click on &#8216;Datasets&#8217; tab.<\/li>\n<li>Click on &#8216;List Datasets&#8217;<\/li>\n<\/ul>\n<p><a href=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_datasets.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-192799\" src=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_datasets.png\" alt=\"\" width=\"1277\" height=\"936\" srcset=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_datasets.png 1277w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_datasets-300x220.png 300w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_datasets-768x563.png 768w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_datasets-1024x751.png 1024w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_datasets-600x440.png 600w\" sizes=\"auto, (max-width: 1277px) 100vw, 1277px\" \/><\/a><\/p>\n<p>A GET request is made to get the list of datasets from BigQuery.<\/p>\n<p>GET https:\/\/bigquery.googleapis.com\/bigquery\/v2\/projects\/second-inquiry-315605\/datasets HTTP\/1.1<\/p>\n<p><strong>Server response for getting the datasets from BigQuery.<\/strong><\/p>\n<p>{<\/p>\n<p>&#8220;kind&#8221;: &#8220;bigquery#datasetList&#8221;,<\/p>\n<p>&#8220;etag&#8221;: &#8220;yEYyl\/YbK4QwdJSWHWW5Mg==&#8221;,<\/p>\n<p>&#8220;datasets&#8221;: [<\/p>\n<p>{<\/p>\n<p>&#8220;kind&#8221;: &#8220;bigquery#dataset&#8221;,<\/p>\n<p>&#8220;id&#8221;: &#8220;second-inquiry-315605:employee&#8221;,<\/p>\n<p>&#8220;datasetReference&#8221;: {<\/p>\n<p>&#8220;datasetId&#8221;: &#8220;employee&#8221;,<\/p>\n<p>&#8220;projectId&#8221;: &#8220;second-inquiry-315605&#8221;<\/p>\n<p>},<\/p>\n<p>&#8220;location&#8221;: &#8220;US&#8221;<\/p>\n<p>},<\/p>\n<p>{<\/p>\n<p>&#8220;kind&#8221;: &#8220;bigquery#dataset&#8221;,<\/p>\n<p>&#8220;id&#8221;: &#8220;second-inquiry-315605:iot_dataset&#8221;,<\/p>\n<p>&#8220;datasetReference&#8221;: {<\/p>\n<p>&#8220;datasetId&#8221;: &#8220;iot_dataset&#8221;,<\/p>\n<p>&#8220;projectId&#8221;: &#8220;second-inquiry-315605&#8221;<\/p>\n<p>},<\/p>\n<p>&#8220;location&#8221;: &#8220;US&#8221;<\/p>\n<p>},<\/p>\n<p>{<\/p>\n<p>&#8220;kind&#8221;: &#8220;bigquery#dataset&#8221;,<\/p>\n<p>&#8220;id&#8221;: &#8220;second-inquiry-315605:my_dataset_2&#8221;,<\/p>\n<p>&#8220;datasetReference&#8221;: {<\/p>\n<p>&#8220;datasetId&#8221;: &#8220;my_dataset_2&#8221;,<\/p>\n<p>&#8220;projectId&#8221;: &#8220;second-inquiry-315605&#8221;<\/p>\n<p>},<\/p>\n<p>&#8220;location&#8221;: &#8220;US&#8221;<\/p>\n<p>},<\/p>\n<p>{<\/p>\n<p>&#8220;kind&#8221;: &#8220;bigquery#dataset&#8221;,<\/p>\n<p>&#8220;id&#8221;: &#8220;second-inquiry-315605:topic_to_bq&#8221;,<\/p>\n<p>&#8220;datasetReference&#8221;: {<\/p>\n<p>&#8220;datasetId&#8221;: &#8220;topic_to_bq&#8221;,<\/p>\n<p>&#8220;projectId&#8221;: &#8220;second-inquiry-315605&#8221;<\/p>\n<p>},<\/p>\n<p>&#8220;location&#8221;: &#8220;US&#8221;<\/p>\n<p>}<\/p>\n<p>]<\/p>\n<p>}<\/p>\n<p>The list of datasets in a project can also be viewed in the Google console.<\/p>\n<p><a href=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_dataset2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-192800\" src=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_dataset2.png\" alt=\"\" width=\"1292\" height=\"886\" srcset=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_dataset2.png 1292w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_dataset2-300x206.png 300w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_dataset2-768x527.png 768w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_dataset2-1024x702.png 1024w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/list_dataset2-600x411.png 600w\" sizes=\"auto, (max-width: 1292px) 100vw, 1292px\" \/><\/a><\/p>\n<div class=\"video-responsive\"><iframe loading=\"lazy\" id=\"youTubePlayer\" src=\"https:\/\/www.youtube.com\/embed\/hr3QAwP5wBc?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-bigquery-datasets-in-a-project-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-192798","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/pages\/192798","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=192798"}],"version-history":[{"count":1,"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/pages\/192798\/revisions"}],"predecessor-version":[{"id":192801,"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/pages\/192798\/revisions\/192801"}],"wp:attachment":[{"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/media?parent=192798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}