{"id":514797,"date":"2024-10-11T07:48:03","date_gmt":"2024-10-11T05:48:03","guid":{"rendered":"https:\/\/www.devoteam.com\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/"},"modified":"2025-09-15T15:46:17","modified_gmt":"2025-09-15T13:46:17","slug":"bigquery-pricing-how-to-prepare-for-upcoming-billing-changes","status":"publish","type":"expert-view","link":"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/","title":{"rendered":"BigQuery Pricing: How to Prepare for Upcoming Billing Changes"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-understanding-the-bigquery-pricing-changes\"><strong>Understanding the BigQuery Pricing Changes<\/strong><\/h2>\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/cloud.google.com\/resources\/storage\/billing-fix-bigquery?hl=en\">Google&#8217;s upcoming billing adjustments <\/a>aim to align BigQuery pricing with the underlying Cloud Storage costs. While this change promotes transparency, it&#8217;s crucial to understand its implications for your BigQuery usage. Let&#8217;s break down the two key areas affected:<\/p>\n\n<ul class=\"wp-block-list\">\n<li><strong>Storage Retrieval Fees:<\/strong> If your BigQuery queries access data stored in Nearline, Coldline, or Archive storage classes within Cloud Storage, you&#8217;ll now be faced with retrieval fees. These fees vary based on the storage class and the amount of data retrieved.<\/li>\n\n\n\n<li><strong>Inter-Region Network Data Transfer Fees: <\/strong>When your BigQuery dataset and the Cloud Storage bucket it accesses reside in different regions, you&#8217;ll be charged for the data transferred between them. These fees can add up, especially for large datasets or frequent queries.<\/li>\n<\/ul>\n\n<h2 class=\"wp-block-heading\" id=\"h-assessing-your-potential-costs\"><strong>Assessing Your Potential Costs<\/strong><\/h2>\n\n<p class=\"wp-block-paragraph\">Unfortunately, there&#8217;s no single, straightforward way to pinpoint the exact costs you&#8217;ll face due to the billing changes. However, we can employ a combination of strategies to gain valuable insights:<\/p>\n\n<h3 class=\"wp-block-heading\" id=\"h-1-identify-cloud-storage-buckets-accessed-by-bigquery\"><strong>1. Identify Cloud Storage Buckets Accessed by BigQuery<\/strong><\/h3>\n\n<p class=\"wp-block-paragraph\">Analyse BigQuery&#8217;s <code><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">INFORMATION_SCHEMA<\/mark><\/code> views to reveal which Cloud Storage buckets your queries interact with. While this doesn&#8217;t tell us the bucket locations or storage classes, it&#8217;s a crucial first step.<\/p>\n\n<p class=\"wp-block-paragraph\">Use this query to list accessed buckets:<\/p>\n\n<pre class=\"wp-block-code has-medium-font-size\"><code><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">SELECT SPLIT<\/mark>(query, <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-green-cyan-color\">'gs:\/\/'<\/mark>)&#91;<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">1<\/mark>]\n<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">FROM<\/mark> erik-trial.`<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-green-cyan-color\">region-europe-north1<\/mark>`.INFORMATION_SCHEMA.JOBS_BY_PROJECT\n<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">WHERE<\/mark> query <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-green-cyan-color\">like<\/mark> '<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-green-cyan-color\">%gs:\/\/%<\/mark>' <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">and<\/mark> error_result.reason <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">is null<\/mark><\/code><\/pre>\n\n<p class=\"wp-block-paragraph\">Remember to run this query for each region where you have BigQuery datasets.<\/p>\n\n<h3 class=\"wp-block-heading\" id=\"h-2-identify-bucket-locations-and-storage-classes\"><strong>2. Identify Bucket Locations and Storage Classes<\/strong><\/h3>\n\n<p class=\"wp-block-paragraph\">To determine if you have buckets in different locations or using Nearline, Coldline, or Archive storage, leverage the gsutil command-line tool in Cloud Shell:<\/p>\n\n<p class=\"wp-block-paragraph\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-green-cyan-color\">gsutil ls | xargs -n 1 gsutil ls -L -b | grep -B 1 &#8216;Storage|Location constraint&#8217;<\/mark><\/p>\n\n<p class=\"wp-block-paragraph\">This command lists your buckets, their locations, and storage classes.<\/p>\n\n<h3 class=\"wp-block-heading\" id=\"h-3-combine-the-information\"><strong>3. Combine the Information<\/strong><\/h3>\n\n<p class=\"wp-block-paragraph\">To identify areas where new charges will apply, cross-reference the buckets accessed by BigQuery with their locations and storage classes.<\/p>\n\n<p class=\"wp-block-paragraph\">In our sandvox environment we ran step 1 with the query:<\/p>\n\n<pre class=\"wp-block-code has-medium-font-size\"><code><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">SELECT SPLIT<\/mark>(query, '<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-light-green-cyan-color\">gs:\/\/<\/mark>')&#91;<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">1<\/mark>] <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">as<\/mark> referenced_buckets, query\n<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">FROM<\/mark> erik-trial.`<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-green-cyan-color\">region-europe-north1<\/mark>`.INFORMATION_SCHEMA.JOBS_BY_PROJECT\n<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">WHERE<\/mark> query <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">like<\/mark> '<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-green-cyan-color\">%gs:\/\/%<\/mark>' and error_result.reason <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">is null<\/mark><\/code><\/pre>\n\n<p class=\"wp-block-paragraph\">Which returned the following:<\/p>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img decoding=\"async\" src=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/Screenshot-2024-10-03-at-15.29.23.png\" alt=\"Results of the command in BigQuery in a table\" class=\"wp-image-107355\" style=\"width:700px\"\/><\/figure>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<p class=\"wp-block-paragraph\">As you can see, the column referenced_buckets starts with the name of a bucket referenced by a past query. Looking at the query column, we see this includes Load and External jobs.<\/p>\n\n<p class=\"wp-block-paragraph\">The only bucket referenced by this project and region is <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">erik-trial-different-region<\/mark>, let\u2019s remember this bucket for the next step.<\/p>\n\n<p class=\"wp-block-paragraph\">Keep in mind that we only ran this for the region <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">region-europe-north1<\/mark>. To include more BigQuery regions this has to be rerun for each region.<\/p>\n\n<p class=\"wp-block-paragraph\">To get more information about the buckets in our project, we ran step 2 in the Cloud Shell which returned the following:<\/p>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/AD_4nXc148pkaqfTw-Gr3Xe35UBVH3wyUbbLizpAV8wEHiuGCefovXjGuTZhBEhO7_WMr8ngUPtgLEXx2laVUjMJ_ExJtb9nDx0PhDc1Iu3JAgGtWKZE_QotmCvh1V8pLLEoWGxFPKIppJhGG6DomawtB92fpBs.png\" alt=\"Part of a code line in BigQuery\"\/><\/figure>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<p class=\"wp-block-paragraph\">As you can see, our bucket from step 1 is here. It has the Storage class Standard and is in the location \u201cEU\u201d.\u00a0<\/p>\n\n<p class=\"wp-block-paragraph\">Based on the billing updates, from November users will\u00a0 be charged for the following SKU:<\/p>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/AD_4nXfMiJXLYKL_rWDJK1V6YgVJIiY-WcumFVdATBNYbw7lUAhfmuKnMEYXYCBWPX84_c0xim-FsBYXCxZqx27N5pA3kRyuZVWgwaDhmqLvaFu1QfSM2Ma_slaor_aZvmcBXV5_Slmpnc9S22alSFMNW5N0X7lh.png\" alt=\"BigQuery Pricing updates: Network Data Transfer GCP Inter Region within Europe: 0,02 USD per 1 gibibyte\"\/><\/figure>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<p class=\"wp-block-paragraph\">If the charge is significant, we should consider moving our bucket to <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">europe-north1<\/mark> or our BigQuery dataset to <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">europe-west4<\/mark>. Going forward <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">europe-west4<\/mark> will be treated equal to <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">EU<\/mark> when it comes to the new charges and won\u2019t therefore be affected by inter region transfer costs.<\/p>\n\n<h2 class=\"wp-block-heading\" id=\"h-taking-action\"><strong>Taking Action<\/strong><\/h2>\n\n<p class=\"wp-block-paragraph\">Armed with this knowledge, you can take proactive steps to prepare for the BigQuery pricing changes and manage your Cloud Storage costs. Here are my recommendations:<\/p>\n\n<ul class=\"wp-block-list\">\n<li><strong>Optimise Data Placement: <\/strong>Consider relocating frequently accessed data to the same region as your BigQuery datasets to avoid inter-region transfer fees. If you are importing data from remote Cloud Storage locations, store the data in a Cloud Storage bucket that is in the same region as the destination BigQuery dataset. For example:\n<ul class=\"wp-block-list\">\n<li>If you are reading data into BigQuery US multi-region, consider placing your Cloud Storage bucket in us-central1.<\/li>\n\n\n\n<li>If you are reading data into BigQuery us-west1, consider placing your Cloud Storage bucket in us-west1.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n<p class=\"wp-block-paragraph\">Additionally, if you want to co-locate an existing Cloud Storage bucket to your BigQuery region, you can use Storage Transfer Service.<\/p>\n\n<ul class=\"wp-block-list\">\n<li><strong>Review Storage Classes: <\/strong>Evaluate if savings from storing data in Nearline, Coldline, or Archive classes outweigh retrieval fees. Consider enabling Autoclass on the bucket.<\/li>\n\n\n\n<li><strong>Monitor Usage:<\/strong> Keep an eye on your BigQuery usage patterns and adjust your data storage strategies as needed.<\/li>\n<\/ul>\n\n<p class=\"wp-block-paragraph\">Read more about the <a href=\"https:\/\/cloud.google.com\/skus\/?currency=USD&amp;filter=C7FF-4F9E-C0DB&amp;e=48754805&amp;hl=en\">affected SKUs<\/a> and BigQuery <a href=\"https:\/\/cloud.google.com\/storage\/pricing#retrieval-pricing\">pricing<\/a> on the Google Cloud page.<\/p>\n\n<p class=\"wp-block-paragraph\">Optimising your BigQuery data warehouse can significantly impact costs. Read how to do it with <a href=\"https:\/\/devoteam.info\/expert-view\/optimise-your-data-warehouse-bigquery-nested-and-repeated-fields\/\">nested fields<\/a> and <a href=\"https:\/\/devoteam.info\/expert-view\/improve-bigquery-performance-normalisation-vs-denormalisation\/\">denormalisation<\/a>.<\/p>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<div class=\"wp-block-cover alignfull is-style-blur-image is-style-blur-image-less\" style=\"margin-top:0;margin-bottom:0;padding-top:0;padding-right:0;padding-bottom:0;padding-left:0\"><span aria-hidden=\"true\" class=\"wp-block-cover__background has-black-background-color has-background-dim-70 has-background-dim\"><\/span><img loading=\"lazy\" decoding=\"async\" width=\"2560\" height=\"1707\" src=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes-.jpg\" class=\"wp-block-cover__image-background wp-post-image\" alt=\"\" data-object-fit=\"cover\" srcset=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes-.jpg 2560w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--300x200.jpg 300w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--1024x683.jpg 1024w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--768x512.jpg 768w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--1536x1024.jpg 1536w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--2048x1366.jpg 2048w\" sizes=\"auto, (max-width: 2560px) 100vw, 2560px\" \/><div class=\"wp-block-cover__inner-container is-layout-flow wp-block-cover-is-layout-flow\">\n<div class=\"wp-block-group alignfull has-base-color has-text-color has-global-padding is-layout-constrained wp-container-core-group-is-layout-5c84bf8b wp-block-group-is-layout-constrained\" style=\"margin-top:0px;margin-bottom:0px;padding-top:var(--wp--preset--spacing--xx-large);padding-right:var(--wp--preset--spacing--medium);padding-bottom:var(--wp--preset--spacing--xx-large);padding-left:var(--wp--preset--spacing--medium)\">\n<div class=\"wp-block-group is-layout-flow wp-block-group-is-layout-flow\">\n<div class=\"wp-block-group has-global-padding is-content-justification-left is-layout-constrained wp-container-core-group-is-layout-5f9de3d0 wp-block-group-is-layout-constrained\">\n<h2 class=\"wp-block-heading has-text-align-left has-secondary-font-family has-large-font-size\" id=\"h-are-you-concerned-about-the-google-bigquery-pricing-changes\">Are you concerned about the Google BigQuery pricing changes?<\/h2>\n<\/div>\n\n\n\n<p class=\"has-text-align-left has-main-accent-color has-text-color wp-block-paragraph\">Our team of Google Cloud experts can help you with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Optimising data placement to avoid inter-region transfer fees.<\/li>\n\n\n\n<li>Reviewing storage classes to ensure that savings outweigh retrieval fees.<\/li>\n\n\n\n<li>Monitoring usage and adjusting data storage strategies.<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-left has-main-accent-color has-text-color wp-block-paragraph\"><strong>Don&#8217;t wait until these changes impact your budget. <\/strong><\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-left is-layout-flex wp-container-core-buttons-is-layout-3c38c079 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/devoteam.info\/me\/get-in-touch\/\">Contact Us<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This November Google is rolling out billing changes that could impact your cloud costs. Get ready for new retrieval fees from Nearline, Coldline, and Archive storage. Additionally, there will be new charges for inter-region network data transfers when accessing Cloud Storage data from a BigQuery dataset in a different location.\u00a0Don&#8217;t let these changes catch you off guard! This article will help you identify BigQuery jobs that could trigger these new fees, helping you stay ahead of potential cost increases.<\/p>\n","protected":false},"featured_media":327430,"template":"","categories":[2330,912],"tags":[2863,2284,2504],"industry":[],"class_list":["post-514797","expert-view","type-expert-view","status-publish","has-post-thumbnail","hentry","category-data-me","category-google-cloud-me","tag-data-analytics-me","tag-google-cloud-me","tag-google-cloud-platform-me"],"acf":[],"cards":"\n\t<div class=\"single-post-card\">\n\n\t\t<figure class=\"wp-block-post-featured-image\"><a href=\"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/\" target=\"_self\" ><img width=\"2560\" height=\"1707\" src=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes-.jpg\" class=\"attachment-post-thumbnail size-post-thumbnail wp-post-image\" alt=\"BigQuery Pricing: How to Prepare for Upcoming Billing Changes\" style=\"aspect-ratio:4\/3;width:100%;object-fit:cover;\" decoding=\"async\" loading=\"lazy\" srcset=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes-.jpg 2560w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--300x200.jpg 300w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--1024x683.jpg 1024w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--768x512.jpg 768w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--1536x1024.jpg 1536w, https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--2048x1366.jpg 2048w\" sizes=\"auto, (max-width: 2560px) 100vw, 2560px\" \/><\/a><\/figure>\n\n\t\t\n\t\t<div class=\"wp-block-group is-vertical is-layout-flex wp-container-core-group-is-layout-43282307 wp-block-group-is-layout-flex\">\n\t<p style=\"font-style:normal;font-weight:700\" class=\"has-link-color wp-elements-1 wp-block-lp-post-type has-text-color has-primary-color has-small-font-size\">Expert View<\/p>\n\n\t\t\n\t\t<h3 style=\"font-style:normal;font-weight:400\" class=\"wp-block-post-title has-base-font-size\"><a href=\"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/\" target=\"_self\" >BigQuery Pricing: How to Prepare for Upcoming Billing Changes<\/a><\/h3><\/div>\n\t\t\n\t<\/div>\n\n","yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>BigQuery Pricing: How to Prepare for Upcoming Billing Changes | Devoteam<\/title>\n<meta name=\"description\" content=\"Google&#039;s changing BigQuery pricing this November! Learn how to identify BigQuery jobs that could trigger new fees and avoid unexpected cost increases.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BigQuery Pricing: How to Prepare for Upcoming Billing Changes\" \/>\n<meta property=\"og:description\" content=\"Google&#039;s changing BigQuery pricing this November! Learn how to identify BigQuery jobs that could trigger new fees and avoid unexpected cost increases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/\" \/>\n<meta property=\"og:site_name\" content=\"Devoteam\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-15T13:46:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes-.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\\\/\",\"url\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\\\/\",\"name\":\"BigQuery Pricing: How to Prepare for Upcoming Billing Changes | Devoteam\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes-.jpg\",\"datePublished\":\"2024-10-11T05:48:03+00:00\",\"dateModified\":\"2025-09-15T13:46:17+00:00\",\"description\":\"Google's changing BigQuery pricing this November! Learn how to identify BigQuery jobs that could trigger new fees and avoid unexpected cost increases.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\\\/#breadcrumb\"},\"inLanguage\":\"en-SA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-SA\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\\\/#primaryimage\",\"url\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes-.jpg\",\"contentUrl\":\"https:\\\/\\\/devoteam.info\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes-.jpg\",\"width\":2560,\"height\":1707},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/devoteam.info\\\/me\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Expert View\",\"item\":\"https:\\\/\\\/devoteam.info\\\/me\\\/expert-view\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BigQuery Pricing: How to Prepare for Upcoming Billing Changes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/devoteam.info\\\/me\\\/#website\",\"url\":\"https:\\\/\\\/devoteam.info\\\/me\\\/\",\"name\":\"Devoteam\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/devoteam.info\\\/me\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-SA\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"BigQuery Pricing: How to Prepare for Upcoming Billing Changes | Devoteam","description":"Google's changing BigQuery pricing this November! Learn how to identify BigQuery jobs that could trigger new fees and avoid unexpected cost increases.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/","og_locale":"en_US","og_type":"article","og_title":"BigQuery Pricing: How to Prepare for Upcoming Billing Changes","og_description":"Google's changing BigQuery pricing this November! Learn how to identify BigQuery jobs that could trigger new fees and avoid unexpected cost increases.","og_url":"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/","og_site_name":"Devoteam","article_modified_time":"2025-09-15T13:46:17+00:00","og_image":[{"width":2560,"height":1707,"url":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes-.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/","url":"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/","name":"BigQuery Pricing: How to Prepare for Upcoming Billing Changes | Devoteam","isPartOf":{"@id":"https:\/\/devoteam.info\/me\/#website"},"primaryImageOfPage":{"@id":"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/#primaryimage"},"image":{"@id":"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/#primaryimage"},"thumbnailUrl":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes-.jpg","datePublished":"2024-10-11T05:48:03+00:00","dateModified":"2025-09-15T13:46:17+00:00","description":"Google's changing BigQuery pricing this November! Learn how to identify BigQuery jobs that could trigger new fees and avoid unexpected cost increases.","breadcrumb":{"@id":"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/#breadcrumb"},"inLanguage":"en-SA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/"]}]},{"@type":"ImageObject","inLanguage":"en-SA","@id":"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/#primaryimage","url":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes-.jpg","contentUrl":"https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes-.jpg","width":2560,"height":1707},{"@type":"BreadcrumbList","@id":"https:\/\/devoteam.info\/me\/expert-view\/bigquery-pricing-how-to-prepare-for-upcoming-billing-changes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devoteam.info\/me\/"},{"@type":"ListItem","position":2,"name":"Expert View","item":"https:\/\/devoteam.info\/me\/expert-view\/"},{"@type":"ListItem","position":3,"name":"BigQuery Pricing: How to Prepare for Upcoming Billing Changes"}]},{"@type":"WebSite","@id":"https:\/\/devoteam.info\/me\/#website","url":"https:\/\/devoteam.info\/me\/","name":"Devoteam","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devoteam.info\/me\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-SA"}]}},"uagb_featured_image_src":{"full":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes-.jpg",2560,1707,false],"thumbnail":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--150x150.jpg",150,150,true],"medium":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--300x200.jpg",300,200,true],"medium_large":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--768x512.jpg",768,512,true],"large":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--1024x683.jpg",1024,683,true],"1536x1536":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--1536x1024.jpg",1536,1024,true],"2048x2048":["https:\/\/devoteam.info\/wp-content\/uploads\/2024\/12\/BigQuery-Pricing-How-to-Prepare-for-Upcoming-Billing-Changes--2048x1366.jpg",2048,1366,true]},"uagb_author_info":{"display_name":"aleksandra.juda","author_link":"https:\/\/devoteam.info\/me\/author\/"},"uagb_comment_info":0,"uagb_excerpt":"This November Google is rolling out billing changes that could impact your cloud costs. Get ready for new retrieval fees from Nearline, Coldline, and Archive storage. Additionally, there will be new charges for inter-region network data transfers when accessing Cloud Storage data from a BigQuery dataset in a different location.\u00a0Don't let these changes catch you&hellip;","_links":{"self":[{"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/expert-view\/514797","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/expert-view"}],"about":[{"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/types\/expert-view"}],"version-history":[{"count":0,"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/expert-view\/514797\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/media\/327430"}],"wp:attachment":[{"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/media?parent=514797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/categories?post=514797"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/tags?post=514797"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/devoteam.info\/me\/wp-json\/wp\/v2\/industry?post=514797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}