{"id":192792,"date":"2021-08-07T07:50:01","date_gmt":"2021-08-07T14:50:01","guid":{"rendered":"https:\/\/m2msupport.net\/m2msupport\/?page_id=192792"},"modified":"2021-08-07T07:50:03","modified_gmt":"2021-08-07T14:50:03","slug":"create-a-bigquery-dataset-in-google-cloud-platform-gcp","status":"publish","type":"page","link":"https:\/\/m2msupport.net\/m2msupport\/create-a-bigquery-dataset-in-google-cloud-platform-gcp\/","title":{"rendered":"Create a 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 create Datasets in BigQuery in the Google Cloud Platform.<\/p>\n<h1>To create a Dataset 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;Add Dataset&#8217; and enter the name for the Dataset Id<\/li>\n<\/ul>\n<p>In this below example,&nbsp; the dataset named &#8216;iot_dataset&#8217; is created in BigQuery.<\/p>\n<p><a href=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-192794\" src=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset.png\" alt=\"\" width=\"850\" height=\"728\" srcset=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset.png 850w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset-300x257.png 300w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset-768x658.png 768w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset-600x514.png 600w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-192795\" src=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset_2.png\" alt=\"\" width=\"846\" height=\"649\" srcset=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset_2.png 846w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset_2-300x230.png 300w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset_2-768x589.png 768w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset_2-600x460.png 600w\" sizes=\"auto, (max-width: 846px) 100vw, 846px\" \/><\/a><\/p>\n<p>A post request is made to create the dataset in BigQuery. The datasetId is passed as a JSON object of the post request.<\/p>\n<p>POST https:\/\/bigquery.googleapis.com\/bigquery\/v2\/projects\/second-inquiry-315605\/datasets HTTP\/1.1<\/p>\n<p>{&#8220;datasetReference&#8221;:{&#8220;datasetId&#8221;:&#8221;iot_dataset&#8221;}}<\/p>\n<p><strong>Server response to dataset creation request<\/strong><\/p>\n<p>{<\/p>\n<p>&#8220;kind&#8221;: &#8220;bigquery#dataset&#8221;,<\/p>\n<p>&#8220;etag&#8221;: &#8220;TkPgAaJx2b8KPGEyZGyz\/A==&#8221;,<\/p>\n<p>&#8220;id&#8221;: &#8220;second-inquiry-315605:iot_dataset&#8221;,<\/p>\n<p>&#8220;selfLink&#8221;: &#8220;https:\/\/bigquery.googleapis.com\/bigquery\/v2\/projects\/second-inquiry-315605\/datasets\/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;access&#8221;: [<\/p>\n<p>{<\/p>\n<p>&#8220;role&#8221;: &#8220;WRITER&#8221;,<\/p>\n<p>&#8220;specialGroup&#8221;: &#8220;projectWriters&#8221;<\/p>\n<p>},<\/p>\n<p>{<\/p>\n<p>&#8220;role&#8221;: &#8220;OWNER&#8221;,<\/p>\n<p>&#8220;specialGroup&#8221;: &#8220;projectOwners&#8221;<\/p>\n<p>},<\/p>\n<p>{<\/p>\n<p>&#8220;role&#8221;: &#8220;OWNER&#8221;,<\/p>\n<p>&#8220;userByEmail&#8221;: &#8220;iot-cloud-tester@second-inquiry-315605.iam.gserviceaccount.com&#8221;<\/p>\n<p>},<\/p>\n<p>{<\/p>\n<p>&#8220;role&#8221;: &#8220;READER&#8221;,<\/p>\n<p>&#8220;specialGroup&#8221;: &#8220;projectReaders&#8221;<\/p>\n<p>}<\/p>\n<p>],<\/p>\n<p>&#8220;creationTime&#8221;: &#8220;1628347060942&#8221;,<\/p>\n<p>&#8220;lastModifiedTime&#8221;: &#8220;1628347060942&#8221;,<\/p>\n<p>&#8220;location&#8221;: &#8220;US&#8221;,<\/p>\n<p>&#8220;type&#8221;: &#8220;DEFAULT&#8221;<\/p>\n<p>}<\/p>\n<p>The newly created dataset can be viewed in the Google console.<\/p>\n<p><a href=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset_3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-192796\" src=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset_3.png\" alt=\"\" width=\"1288\" height=\"885\" srcset=\"https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset_3.png 1288w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset_3-300x206.png 300w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset_3-768x528.png 768w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset_3-1024x704.png 1024w, https:\/\/m2msupport.net\/m2msupport\/wp-content\/uploads\/2021\/08\/create_dataset_3-600x412.png 600w\" sizes=\"auto, (max-width: 1288px) 100vw, 1288px\" \/><\/a><\/p>\n<div class=\"video-responsive\"><iframe loading=\"lazy\" id=\"youTubePlayer\" src=\"https:\/\/www.youtube.com\/embed\/DpHQCONwS2U?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\/create-a-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-192792","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/pages\/192792","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=192792"}],"version-history":[{"count":1,"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/pages\/192792\/revisions"}],"predecessor-version":[{"id":192797,"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/pages\/192792\/revisions\/192797"}],"wp:attachment":[{"href":"https:\/\/m2msupport.net\/m2msupport\/wp-json\/wp\/v2\/media?parent=192792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}