{"id":9068,"date":"2021-05-30T11:31:04","date_gmt":"2021-05-30T11:31:04","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=9068"},"modified":"2024-03-19T10:49:22","modified_gmt":"2024-03-19T10:49:22","slug":"creation-and-deletion-of-bi-engine","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/","title":{"rendered":"Creation and deletion of BI Engine"},"content":{"rendered":"\r\n<h2><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;BigQuery BI Engine reservation creation and deletion&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:513,&quot;3&quot;:{&quot;1&quot;:0},&quot;12&quot;:0}\">BigQuery BI Engine reservation creation and deletion<\/span><\/h2>\r\n<p>&nbsp;<\/p>\r\n<p><a href=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/\" target=\"_blank\" rel=\"noreferrer noopener\" data-type=\"URL\" data-id=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/\">BigQuery<\/a> BI Engine is fast, in-memory analysis service. By using BI Engine you can analyze the data stored in BigQuery with sub-second query response time and with high concurrency.<\/p>\r\n<p>Creating and managing reservations in BigQuery BI Engine is crucial for optimizing query performance and ensuring efficient utilization of resources. This introduction will outline the significance and procedures involved in both creating and deleting reservations in BigQuery BI Engine, empowering users to streamline their analytical workflows effectively.<\/p>\r\n<p>BigQuery BI Engine reservations enable users to allocate memory resources for query caching, accelerating query execution and reducing latency. By reserving capacity, organizations can ensure consistent performance for critical queries and enhance overall data analytics efficiency.<\/p>\r\n\r\n\r\n\r\n<p><strong>Prerequisites<\/strong><\/p>\r\n\r\n\r\n\r\n<p><a href=\"https:\/\/www.prwatech.com\/course\/gcptraining\" target=\"_blank\" rel=\"noreferrer noopener\" data-type=\"URL\" data-id=\"https:\/\/www.prwatech.com\/course\/gcptraining\">GCP<\/a> account<\/p>\r\n\r\n\r\n\r\n<p>Open console.<\/p>\r\n\r\n\r\n\r\n<p>Click Menu &gt; Big Query &gt; BI Engine.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"336\" height=\"178\" class=\"wp-image-9069\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-418.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-418.png 336w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-418-300x159.png 300w\" sizes=\"auto, (max-width: 336px) 100vw, 336px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Click on Create Reservation.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"467\" height=\"167\" class=\"wp-image-9070\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-419.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-419.png 467w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-419-300x107.png 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Choose the location.<\/p>\r\n\r\n\r\n\r\n<p>Choose the capacity of the BI engine. Click Next.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"454\" height=\"337\" class=\"wp-image-9071\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-420.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-420.png 454w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-420-300x223.png 300w\" sizes=\"auto, (max-width: 454px) 100vw, 454px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Check the Right side for the costing for BI Engine.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"387\" height=\"282\" class=\"wp-image-9072\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-421.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-421.png 387w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-421-300x219.png 300w\" sizes=\"auto, (max-width: 387px) 100vw, 387px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Click on Create.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"415\" height=\"204\" class=\"wp-image-9073\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-422.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-422.png 415w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-422-300x147.png 300w\" sizes=\"auto, (max-width: 415px) 100vw, 415px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>It will create the BI Engine.<\/p>\r\n\r\n\r\n\r\n<p><strong>Deleting BI engine<\/strong><\/p>\r\n\r\n\r\n\r\n<p>To Delete BI Engine, Click on 3 dots in the right side of the BI Engine.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"174\" class=\"wp-image-9074\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-423.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-423.png 628w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-423-300x83.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Click Delete.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"214\" class=\"wp-image-9075\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-424.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-424.png 604w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-424-300x106.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Enter REMOVE to confirm deletion. Press proceed.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"590\" height=\"420\" class=\"wp-image-9076\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-425.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-425.png 590w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-425-300x214.png 300w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>The BI Engine will be deleted.<\/p>\r\n<p>This is all about BigQuery BI Engine reservation creation and deletion.<\/p>\r\n<p>&nbsp;<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>BigQuery BI Engine reservation creation and deletion &nbsp; BigQuery BI Engine is fast, in-memory analysis service. By using BI Engine you can analyze the data stored in BigQuery with sub-second query response time and with high concurrency. Creating and managing reservations in BigQuery BI Engine is crucial for optimizing query performance and ensuring efficient utilization [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1632,1],"tags":[1425,728,1401,732,605,699,700,617,683,684,685,611,1400,692],"class_list":["post-9068","post","type-post","status-publish","format-standard","hentry","category-bigquery","category-google-cloud-platform","tag-bi-engine","tag-bigquery","tag-bigquery-console","tag-bigquery-sql","tag-gcp","tag-gcp-certification","tag-gcp-cloud-console","tag-google-cloud","tag-google-cloud-certification","tag-google-cloud-console","tag-google-cloud-courses","tag-google-cloud-platform","tag-google-cloud-platform-tutorial","tag-google-cloud-training"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>BigQuery BI Engine reservation creation and deletion - Prwatech<\/title>\n<meta name=\"description\" content=\"Master BigQuery BI Engine reservation creation and deletion with Prwatech - Dive deep with our expert instructors.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BigQuery BI Engine reservation creation and deletion - Prwatech\" \/>\n<meta property=\"og:description\" content=\"Master BigQuery BI Engine reservation creation and deletion with Prwatech - Dive deep with our expert instructors.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/\" \/>\n<meta property=\"og:site_name\" content=\"Prwatech\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prwatech.in\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-30T11:31:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-19T10:49:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-418.png\" \/>\n<meta name=\"author\" content=\"Prwatech\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:site\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prwatech\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/\",\"url\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/\",\"name\":\"BigQuery BI Engine reservation creation and deletion - Prwatech\",\"isPartOf\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-418.png\",\"datePublished\":\"2021-05-30T11:31:04+00:00\",\"dateModified\":\"2024-03-19T10:49:22+00:00\",\"author\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\"},\"description\":\"Master BigQuery BI Engine reservation creation and deletion with Prwatech - Dive deep with our expert instructors.\",\"breadcrumb\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/#primaryimage\",\"url\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-418.png\",\"contentUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-418.png\",\"width\":336,\"height\":178},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prwatech.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creation and deletion of BI Engine\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prwatech.in\/blog\/#website\",\"url\":\"https:\/\/prwatech.in\/blog\/\",\"name\":\"Prwatech\",\"description\":\"Share Ideas, Start Something Good.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prwatech.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\",\"name\":\"Prwatech\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"caption\":\"Prwatech\"},\"url\":\"https:\/\/prwatech.in\/blog\/author\/prwatech123\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"BigQuery BI Engine reservation creation and deletion - Prwatech","description":"Master BigQuery BI Engine reservation creation and deletion with Prwatech - Dive deep with our expert instructors.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"BigQuery BI Engine reservation creation and deletion - Prwatech","og_description":"Master BigQuery BI Engine reservation creation and deletion with Prwatech - Dive deep with our expert instructors.","og_url":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/","og_site_name":"Prwatech","article_publisher":"https:\/\/www.facebook.com\/prwatech.in\/","article_published_time":"2021-05-30T11:31:04+00:00","article_modified_time":"2024-03-19T10:49:22+00:00","og_image":[{"url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-418.png","type":"","width":"","height":""}],"author":"Prwatech","twitter_card":"summary_large_image","twitter_creator":"@Eduprwatech","twitter_site":"@Eduprwatech","twitter_misc":{"Written by":"Prwatech","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/","url":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/","name":"BigQuery BI Engine reservation creation and deletion - Prwatech","isPartOf":{"@id":"https:\/\/prwatech.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/#primaryimage"},"image":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/#primaryimage"},"thumbnailUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-418.png","datePublished":"2021-05-30T11:31:04+00:00","dateModified":"2024-03-19T10:49:22+00:00","author":{"@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3"},"description":"Master BigQuery BI Engine reservation creation and deletion with Prwatech - Dive deep with our expert instructors.","breadcrumb":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/#primaryimage","url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-418.png","contentUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-418.png","width":336,"height":178},{"@type":"BreadcrumbList","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prwatech.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Creation and deletion of BI Engine"}]},{"@type":"WebSite","@id":"https:\/\/prwatech.in\/blog\/#website","url":"https:\/\/prwatech.in\/blog\/","name":"Prwatech","description":"Share Ideas, Start Something Good.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prwatech.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3","name":"Prwatech","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","caption":"Prwatech"},"url":"https:\/\/prwatech.in\/blog\/author\/prwatech123\/"}]}},"_links":{"self":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/9068","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/comments?post=9068"}],"version-history":[{"count":4,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/9068\/revisions"}],"predecessor-version":[{"id":10952,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/9068\/revisions\/10952"}],"wp:attachment":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media?parent=9068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/categories?post=9068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/tags?post=9068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}