{"id":8663,"date":"2021-05-29T06:51:17","date_gmt":"2021-05-29T06:51:17","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=8663"},"modified":"2024-03-16T05:26:46","modified_gmt":"2024-03-16T05:26:46","slug":"executing-queries-of-multiple-gb-of-data-in-seconds","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/","title":{"rendered":"Executing queries of multiple GB of data in seconds"},"content":{"rendered":"\r\n<h2><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Analyze massive datasets with BigQuery&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:513,&quot;3&quot;:{&quot;1&quot;:0},&quot;12&quot;:0}\">Analyze massive datasets with BigQuery<\/span><\/h2>\r\n<p>&nbsp;<\/p>\r\n<div class=\"flex-1 overflow-hidden\">\r\n<div class=\"react-scroll-to-bottom--css-adbhs-79elbk h-full\">\r\n<div class=\"react-scroll-to-bottom--css-adbhs-1n7m0yu\">\r\n<div class=\"flex flex-col text-sm pb-9\">\r\n<div class=\"w-full text-token-text-primary\" data-testid=\"conversation-turn-3\">\r\n<div class=\"px-4 py-2 justify-center text-base md:gap-6 m-auto\">\r\n<div class=\"flex flex-1 text-base mx-auto gap-3 md:px-5 lg:px-1 xl:px-5 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem] group final-completion\">\r\n<div class=\"relative flex w-full flex-col agent-turn\">\r\n<div class=\"flex-col gap-1 md:gap-3\">\r\n<div class=\"flex flex-grow flex-col max-w-full\">\r\n<div class=\"min-h-[20px] text-message flex flex-col items-start gap-3 whitespace-pre-wrap break-words [.text-message+&amp;]:mt-5 overflow-x-auto\" data-message-author-role=\"assistant\" data-message-id=\"b10c4ae6-47bf-4fe9-b3a8-7fa767aa8269\">\r\n<div class=\"markdown prose w-full break-words dark:prose-invert light\">\r\n<p>In the era of burgeoning digital information, the ability to efficiently process and derive insights from vast datasets is paramount. Enter BigQuery, Google&#8217;s fully managed, serverless data warehouse solution designed to tackle the challenges of analyzing massive datasets with unprecedented speed and scalability.<\/p>\r\n<p>&nbsp;<\/p>\r\n<p>This introduction will explore the foundational principles and capabilities of BigQuery, empowering organizations to unlock the full potential of their data assets. From its seamless integration with Google Cloud Platform to its SQL-like querying capabilities and real-time data analytics features, BigQuery offers a robust framework for businesses to glean actionable intelligence swiftly and cost-effectively. Moreover, its inherent scalability allows for seamless expansion as data volumes grow, ensuring sustained performance and reliability. Through this exploration, we will delve into the mechanisms that underpin BigQuery&#8217;s efficiency, its practical applications across various industries, and the transformative impact it can have on data-driven decision-making processes. Join us as we embark on a journey to harness the power of BigQuery and unlock new insights from vast datasets.<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<button class=\"cursor-pointer absolute z-10 rounded-full bg-clip-padding border text-token-text-secondary border-token-border-light right-1\/2 bg-token-main-surface-primary bottom-5\"><\/button><\/div>\r\n<div class=\"flex flex-col text-sm pb-9\"><strong style=\"font-size: 23px;\">Prerequisites<\/strong><\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<p><a href=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/gcp-google-cloud-platform\/\" target=\"_blank\" rel=\"noreferrer noopener\" data-type=\"URL\" data-id=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/gcp-google-cloud-platform\/\">GCP<\/a> <a href=\"https:\/\/cloud.google.com\/free\/?utm_source=google&amp;utm_medium=cpc&amp;utm_campaign=japac-IN-all-en-dr-BKWS-all-core-trial-EXA-dr-1605216&amp;utm_content=text-ad-none-none-DEV_c-CRE_644159077394-ADGP_Hybrid+%7C+BKWS+-+EXA+%7C+Txt+~+GCP_General_core+brand_main-KWID_43700074766895889-kwd-87853815&amp;userloc_9062010-network_g&amp;utm_term=KW_gcp&amp;gad_source=1&amp;gclid=CjwKCAjw48-vBhBbEiwAzqrZVJQBJJN37i294eGLbh2S93HIcrHiy2x1bZP2sGr8OA9UPFKATRwzzxoCw7cQAvD_BwE&amp;gclsrc=aw.ds\">account<\/a><\/p>\r\n\r\n\r\n\r\n<p>Open Console.<\/p>\r\n\r\n\r\n\r\n<p>Open Menu &gt; <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\/\">Big Query <\/a>&gt; SQL Workspace.<\/p>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"355\" height=\"194\" class=\"wp-image-8664\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-70.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-70.png 355w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-70-300x164.png 300w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>In query editor. Paste the below code.<\/p>\r\n\r\n\r\n\r\n<p>SELECT<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 *<\/p>\r\n\r\n\r\n\r\n<p>FROM<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 bigquery-samples.wikipedia_benchmark.Wiki10B<\/p>\r\n\r\n\r\n\r\n<p>LIMIT<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 5<\/p>\r\n\r\n\r\n\r\n<p>And click run.<\/p>\r\n\r\n\r\n\r\n<p>Within seconds we will get the output. This query processed 692 GB in less than a second.<\/p>\r\n\r\n\r\n\r\n<p>NB : We are accessing public dataset provided by google. Processing speed depends on networks.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"369\" class=\"wp-image-8665\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-71.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-71.png 628w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-71-300x176.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Paste the code into query.<\/p>\r\n\r\n\r\n\r\n<p>SELECT<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 language,<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 title,<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 SUM(views) AS views<\/p>\r\n\r\n\r\n\r\n<p>FROM<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 bigquery-samples.wikipedia_benchmark.Wiki10B<\/p>\r\n\r\n\r\n\r\n<p>WHERE<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 title LIKE &#8216;%Google%&#8217;<\/p>\r\n\r\n\r\n\r\n<p>GROUP BY<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 language,<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 title<\/p>\r\n\r\n\r\n\r\n<p>ORDER BY<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 views DESC;<\/p>\r\n\r\n\r\n\r\n<p>then press Run.<\/p>\r\n\r\n\r\n\r\n<p>It will execute 425 GB of data within 8.3 seconds.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"479\" class=\"wp-image-8666\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-72.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-72.png 628w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-72-300x229.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Paste the below code in query<\/p>\r\n\r\n\r\n\r\n<p>SELECT<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 language,<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 title,<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 SUM(views) AS views<\/p>\r\n\r\n\r\n\r\n<p>FROM<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 &#8216;bigquery-samples.wikipedia_benchmark.Wiki100B&#8217;<\/p>\r\n\r\n\r\n\r\n<p>WHERE<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 title LIKE &#8216;%Google%&#8217;<\/p>\r\n\r\n\r\n\r\n<p>GROUP BY<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 language&#8217;<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 title<\/p>\r\n\r\n\r\n\r\n<p>ORDER BY<\/p>\r\n\r\n\r\n\r\n<p>\u00a0\u00a0\u00a0\u00a0 views DESC;<\/p>\r\n\r\n\r\n\r\n<p>click Run<\/p>\r\n\r\n\r\n\r\n<p>It will execute 4.1 TB of data in 47.5 seconds.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"481\" class=\"wp-image-8667\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-73.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-73.png 628w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-73-300x230.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n<p>&nbsp;<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Analyze massive datasets with BigQuery &nbsp; In the era of burgeoning digital information, the ability to efficiently process and derive insights from vast datasets is paramount. Enter BigQuery, Google&#8217;s fully managed, serverless data warehouse solution designed to tackle the challenges of analyzing massive datasets with unprecedented speed and scalability. &nbsp; This introduction will explore the [&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":[728,1401,1403,736,732,1402,605,729,699,700,1399,683,684,685,611,692,733],"class_list":["post-8663","post","type-post","status-publish","format-standard","hentry","category-bigquery","category-google-cloud-platform","tag-bigquery","tag-bigquery-console","tag-bigquery-documentation","tag-bigquery-in-cloud","tag-bigquery-sql","tag-bigquery-tutorial","tag-gcp","tag-gcp-bigquery","tag-gcp-certification","tag-gcp-cloud-console","tag-gcp-console","tag-google-cloud-certification","tag-google-cloud-console","tag-google-cloud-courses","tag-google-cloud-platform","tag-google-cloud-training","tag-sql-in-bigquery"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Analyze massive datasets with BigQuery - Prwartech<\/title>\n<meta name=\"description\" content=\"Master Analyze massive datasets with BigQuery with Prwatech - Dive deep with our expert instructors and comprehensive curriculum.\" \/>\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=\"Analyze massive datasets with BigQuery - Prwartech\" \/>\n<meta property=\"og:description\" content=\"Master Analyze massive datasets with BigQuery with Prwatech - Dive deep with our expert instructors and comprehensive curriculum.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/\" \/>\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-29T06:51:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-16T05:26:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-70.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\/executing-queries-of-multiple-gb-of-data-in-seconds\/\",\"url\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/\",\"name\":\"Analyze massive datasets with BigQuery - Prwartech\",\"isPartOf\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-70.png\",\"datePublished\":\"2021-05-29T06:51:17+00:00\",\"dateModified\":\"2024-03-16T05:26:46+00:00\",\"author\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\"},\"description\":\"Master Analyze massive datasets with BigQuery with Prwatech - Dive deep with our expert instructors and comprehensive curriculum.\",\"breadcrumb\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/#primaryimage\",\"url\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-70.png\",\"contentUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-70.png\",\"width\":355,\"height\":194},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prwatech.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Executing queries of multiple GB of data in seconds\"}]},{\"@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":"Analyze massive datasets with BigQuery - Prwartech","description":"Master Analyze massive datasets with BigQuery with Prwatech - Dive deep with our expert instructors and comprehensive curriculum.","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":"Analyze massive datasets with BigQuery - Prwartech","og_description":"Master Analyze massive datasets with BigQuery with Prwatech - Dive deep with our expert instructors and comprehensive curriculum.","og_url":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/","og_site_name":"Prwatech","article_publisher":"https:\/\/www.facebook.com\/prwatech.in\/","article_published_time":"2021-05-29T06:51:17+00:00","article_modified_time":"2024-03-16T05:26:46+00:00","og_image":[{"url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-70.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\/executing-queries-of-multiple-gb-of-data-in-seconds\/","url":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/","name":"Analyze massive datasets with BigQuery - Prwartech","isPartOf":{"@id":"https:\/\/prwatech.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/#primaryimage"},"image":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/#primaryimage"},"thumbnailUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-70.png","datePublished":"2021-05-29T06:51:17+00:00","dateModified":"2024-03-16T05:26:46+00:00","author":{"@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3"},"description":"Master Analyze massive datasets with BigQuery with Prwatech - Dive deep with our expert instructors and comprehensive curriculum.","breadcrumb":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/#primaryimage","url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-70.png","contentUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-70.png","width":355,"height":194},{"@type":"BreadcrumbList","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/executing-queries-of-multiple-gb-of-data-in-seconds\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prwatech.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Executing queries of multiple GB of data in seconds"}]},{"@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\/8663","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=8663"}],"version-history":[{"count":5,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/8663\/revisions"}],"predecessor-version":[{"id":10927,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/8663\/revisions\/10927"}],"wp:attachment":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media?parent=8663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/categories?post=8663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/tags?post=8663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}