{"id":6604,"date":"2024-10-19T10:41:00","date_gmt":"2024-10-19T02:41:00","guid":{"rendered":"https:\/\/35.220.245.118\/?post_type=blog&#038;p=6604"},"modified":"2025-01-07T12:32:50","modified_gmt":"2025-01-07T04:32:50","slug":"bigquery-editions-simple-plans-for-all-your-data-needs","status":"publish","type":"blog","link":"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/","title":{"rendered":"BigQuery Editions: Simple Plans for All Your Data Needs"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"6604\" class=\"elementor elementor-6604\" data-elementor-post-type=\"blog\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b866ec4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b866ec4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cd16a20\" data-id=\"cd16a20\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-84a8ef5 de_scroll_animation_no elementor-widget elementor-widget-text-editor\" data-id=\"84a8ef5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.18.0 - 20-12-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<h1 dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 12pt;\"><span style=\"font-size: 20pt; font-family: Arial,sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Introduction to BigQuery editions<\/span><\/h1><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 12pt 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery offers three editions (Standard, Enterprise, and Enterprise Plus) to support different workloads. These editions are an alternative to existing reservation models. You can use editions and on-demand models at the same time.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 12pt 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Each edition offers a set of capabilities at a different price point to meet the needs of different types of customers. You can create a\u00a0 <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reservations-intro\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">reservation<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> or a <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reservations-details\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">capacity commitment<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> for an edition. Capacity commitments are not required to purchase slots, but can save you money. For more information about slots autoscaling, see <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/slots-autoscaling-intro\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Introduction to slots autoscaling<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 12pt 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery editions are a property of compute power, not storage, so you can query datasets regardless of how they are stored, as long as you are not using a non-matching edition-specific capability.<\/span><\/p><h2 dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 6pt 0pt 4pt 0pt;\"><span style=\"font-size: 17pt; font-family: 'Google Sans',sans-serif; color: #202124; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Editions features<\/span><\/h2><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery offers three editions: Standard, Enterprise, and Enterprise Plus. The Standard edition is the most basic, while the Enterprise Plus edition is the most advanced. Each edition has different pricing, compute model, max reservation size, max reservations per admin project, commitment plans, monthly SLO, compliance controls, data governance, storage encryption, BI acceleration, materialized views, search, unstructured data, integrated machine learning, workload management, supported assignment types, and multi-cloud analytics.<\/span><\/p><div dir=\"ltr\" style=\"margin-left: 0pt;\" align=\"left\"><table style=\"border: none; border-collapse: collapse;\"><colgroup> <col width=\"125\" \/> <col width=\"97\" \/> <col width=\"145\" \/> <col width=\"145\" \/> <col width=\"112\" \/><\/colgroup><tbody><tr style=\"height: 55pt;\"><td style=\"vertical-align: middle; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\">\u00a0<\/td><td style=\"vertical-align: middle; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Standard<\/span><\/p><\/td><td style=\"vertical-align: middle; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Enterprise<\/span><\/p><\/td><td style=\"vertical-align: middle; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Enterprise Plus<\/span><\/p><\/td><td style=\"vertical-align: middle; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Non-edition offerings<\/span><\/p><\/td><\/tr><tr style=\"height: 70.75pt;\"><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#analysis_pricing_models\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Pricing model<\/span><\/a><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Slot-hours (1 minute minimum)<\/span><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Slot-hours (1 minute minimum)<\/span><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Slot-hours (1 minute minimum)<\/span><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Pay per query with free tier<\/span><\/p><\/td><\/tr><tr style=\"height: 37.75pt;\"><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reservations-intro\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Compute model<\/span><\/a><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/slots-autoscaling-intro\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Autoscaling<\/span><\/a><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/slots-autoscaling-intro\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Autoscaling + Baseline<\/span><\/a><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/slots-autoscaling-intro\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Autoscaling + Baseline<\/span><\/a><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">On-demand<\/span><\/p><\/td><\/tr><tr style=\"height: 54.25pt;\"><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reservations-workload-management\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Maximum reservation size<\/span><\/a><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">1,600 slots<\/span><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/quotas#reservations\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Quota<\/span><\/a><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/quotas#reservations\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Quota<\/span><\/a><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/quotas#reservations\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Quota<\/span><\/a><\/p><\/td><\/tr><tr style=\"height: 87.25pt;\"><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reservations-workload-management#admin-project\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Maximum reservations per administration project<\/span><\/a><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">10<\/span><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\">\u00a0<\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\">\u00a0<\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\">\u00a0<\/td><\/tr><tr style=\"height: 87.25pt;\"><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reservations-details\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Commitment plans<\/span><\/a><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\">\u00a0<\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reservations-details#annual_commitments\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">1-year commitment at 20% discount or 3-year commitment at 40% discount<\/span><\/a><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reservations-details#annual_commitments\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">1-year commitment at 20% discount or 3-year commitment at 40% discount<\/span><\/a><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Monthly and annual commitment discounts<\/span><\/p><\/td><\/tr><tr style=\"height: 70.75pt;\"><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/sla\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Monthly Service Level Objective (SLO)<\/span><\/a><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&gt;=99.9%<\/span><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&gt;=99.99%<\/span><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&gt;=99.99%<\/span><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: -2.232pt -2.232pt -2.232pt -2.232pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">&gt;=99.99%<\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 12pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/editions-intro\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">More detail<\/span><\/a><\/p><h2 dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 12pt;\"><span style=\"font-size: 17pt; font-family: 'Google Sans',sans-serif; color: #202124; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Overview of BigQuery pricing<\/span><\/h2><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 12pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery pricing is based on <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#analysis_pricing_models\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Compute pricing<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> and <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#storage\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Storage pricing<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> . Compute costs are based on the amount of data processed, while storage costs are based on the amount of data stored. Other operations, such as using <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#bqomni\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery Omni<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">, <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#bqml\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery ML<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">, <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#bi_engine_pricing\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">BI Engine<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">, and streaming <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#data_extraction_pricing\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">reads<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> and <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#data_ingestion_pricing\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">writes<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">, are also charged.<\/span><\/p><div dir=\"ltr\" style=\"margin-left: 0pt;\" align=\"left\"><table style=\"border: none; border-collapse: collapse;\"><colgroup> <col width=\"178\" \/> <col width=\"446\" \/><\/colgroup><tbody><tr style=\"height: 44.496pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; background-color: #ffffff; margin-top: 12pt; margin-bottom: 12pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Operation<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; background-color: #ffffff; margin-top: 12pt; margin-bottom: 12pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Price<\/span><\/p><\/td><\/tr><tr style=\"height: 44.496pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; background-color: #ffffff; margin-top: 12pt; margin-bottom: 12pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Compute<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 9pt; margin-bottom: 9pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Including SQL queries, user-defined functions, scripts, and certain DML and DDL statements.<\/span><\/p><\/td><\/tr><tr style=\"height: 44.496pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Storage<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Based on the amount of data stored in BigQuery<\/span><\/p><\/td><\/tr><tr style=\"height: 44.496pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Other operations<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 12pt; margin-bottom: 0pt; padding: 0pt 0pt 12pt 0pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#bqomni\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery Omni<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">, <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#bqml\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery ML<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">, <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#bi_engine_pricing\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">BI Engine<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">, and streaming <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#data_extraction_pricing\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">reads<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> and <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#data_ingestion_pricing\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">writes<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div><h2 dir=\"ltr\" style=\"line-height: 1.56; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 30pt; font-family: 'Google Sans',sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/h2><h2 dir=\"ltr\" style=\"line-height: 1.56; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 17pt; font-family: 'Google Sans',sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Free operations<\/span><\/h2><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 12pt; padding: 12pt 0pt 0pt 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">The following BigQuery operations are free of charge in every location. <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/quotas\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Quotas and limits<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> apply to these operations.<\/span><\/p><div dir=\"ltr\" style=\"margin-left: 0pt;\" align=\"left\"><table style=\"border: none; border-collapse: collapse;\"><colgroup> <col width=\"106\" \/> <col width=\"518\" \/><\/colgroup><tbody><tr style=\"height: 46pt;\"><td style=\"vertical-align: middle; background-color: #ffffff; padding: 3.816pt 3.816pt 3.816pt 3.816pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; background-color: #ffffff; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Operation<\/span><\/p><\/td><td style=\"vertical-align: middle; background-color: #ffffff; padding: 3.816pt 3.816pt 3.816pt 3.816pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; background-color: #ffffff; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Details<\/span><\/p><\/td><\/tr><tr style=\"height: 72pt;\"><td style=\"vertical-align: top; background-color: #ffffff; padding: 3.816pt 3.816pt 3.816pt 3.816pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Load data<\/span><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: 3.816pt 3.816pt 3.816pt 3.816pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Free using the shared slot pool. Customers can choose <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#capacity_compute_analysis_pricing\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">editions pricing<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> for guaranteed capacity. Once the data is loaded into BigQuery, you are charged for storage. For details, see <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#capacity_compute_analysis_pricing\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Data ingestion editions pricing<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p><\/td><\/tr><tr style=\"height: 72pt;\"><td style=\"vertical-align: top; background-color: #ffffff; padding: 3.816pt 3.816pt 3.816pt 3.816pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Copy data<\/span><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: 3.816pt 3.816pt 3.816pt 3.816pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">You are not charged for copying a table, but you do incur charges for Data ingestion editions pricing or storing the new table and the table you copied. For more information, see <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/managing-tables#copy-table\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Copying an existing table<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p><\/td><\/tr><tr style=\"height: 88.5pt;\"><td style=\"vertical-align: top; background-color: #ffffff; padding: 3.816pt 3.816pt 3.816pt 3.816pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Export data<\/span><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: 3.816pt 3.816pt 3.816pt 3.816pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Free using the shared slot pool, but you do incur charges for storing the data in Cloud Storage. Customers can choose <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#capacity_compute_analysis_pricing\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">editions pricing<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> for guaranteed capacity. When you use the <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/other-statements#export_data_statement\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">EXPORT DATA SQL statement<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">, you are charged for query processing. For details, see <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#exporting_data\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Exporting data<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p><\/td><\/tr><tr style=\"height: 55.5pt;\"><td style=\"vertical-align: top; background-color: #ffffff; padding: 3.816pt 3.816pt 3.816pt 3.816pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Delete operations<\/span><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: 3.816pt 3.816pt 3.816pt 3.816pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">You are not charged for deleting datasets or tables, deleting individual table partitions, deleting views, or deleting user-defined functions<\/span><\/p><\/td><\/tr><tr style=\"height: 88.5pt;\"><td style=\"vertical-align: top; background-color: #ffffff; padding: 3.816pt 3.816pt 3.816pt 3.816pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Metadata operations<\/span><\/p><\/td><td style=\"vertical-align: top; background-color: #ffffff; padding: 3.816pt 3.816pt 3.816pt 3.816pt; overflow: hidden; overflow-wrap: break-word; border: solid #202124 0.5pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 12pt; margin-bottom: 0pt; padding: 0pt 0pt 11pt 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">You are not charged for list, get, patch, update and delete calls. Examples include (but are not limited to): listing datasets, updating a dataset&#8217;s access control list, updating a table&#8217;s description, or listing user-defined functions in a dataset.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 11pt; padding: 1pt 0pt 0pt 0pt;\">\u00a0<\/p><\/td><\/tr><\/tbody><\/table><\/div><h2 dir=\"ltr\" style=\"line-height: 1.56; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\">\u00a0<\/h2><h2 dir=\"ltr\" style=\"line-height: 1.56; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 17pt; font-family: 'Google Sans',sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Free usage tier<\/span><\/h2><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 12pt; padding: 12pt 0pt 0pt 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery offers free usage limits for some resources during and after the free trial period. You can try BigQuery&#8217;s free tier in the <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/sandbox\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery sandbox<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> \u00a0 without a credit card. If you go over the usage limits, you will be charged according to the pricing.<\/span><\/p><div dir=\"ltr\" style=\"margin-left: 0pt;\" align=\"left\"><table style=\"border: none; border-collapse: collapse; table-layout: fixed; width: 468pt;\"><colgroup> <col \/> <col \/> <col \/><\/colgroup><tbody><tr style=\"height: 46.5pt;\"><td style=\"vertical-align: middle; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #333333; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Resource<\/span><\/p><\/td><td style=\"vertical-align: middle; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #333333; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Monthly free usage limits<\/span><\/p><\/td><td style=\"vertical-align: middle; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: center; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #333333; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Details<\/span><\/p><\/td><\/tr><tr style=\"height: 72pt;\"><td style=\"vertical-align: top; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Storage<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">The first 10 GiB per month is free.<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery ML models and training data stored in BigQuery are included in the BigQuery storage free tier.<\/span><\/p><\/td><\/tr><tr style=\"height: 166.5pt;\"><td style=\"vertical-align: top; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Queries (analysis)<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">The first 1 TiB of query data processed per month is free.<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 23pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Queries that use BigQuery ML prediction, inspection, and evaluation functions are included in the BigQuery analysis free tier. BigQuery ML queries that contain <\/span><span style=\"font-size: 12pt; font-family: 'Roboto Mono',monospace; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">CREATE MODEL<\/span><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> statements are not.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 24pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#capacity_compute_analysis_pricing\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Editions pricing<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> is also available for high-volume customers that prefer a stable, monthly cost.<\/span><\/p><\/td><\/tr><tr style=\"height: 105pt;\"><td style=\"vertical-align: top; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery ML <\/span><span style=\"font-size: 12pt; font-family: 'Roboto Mono',monospace; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">CREATE MODEL<\/span><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> queries<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">The first 10 GiB of data processed by queries that contain <\/span><span style=\"font-size: 12pt; font-family: 'Roboto Mono',monospace; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">CREATE MODEL<\/span><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> statements per month is free.<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery ML <\/span><span style=\"font-size: 12pt; font-family: 'Roboto Mono',monospace; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">CREATE MODEL<\/span><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> queries are independent of the BigQuery analysis free tier, and only apply to BigQuery ML built-in models (models that are trained within BigQuery).<\/span><\/p><\/td><\/tr><tr style=\"height: 55.5pt;\"><td style=\"vertical-align: top; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">BI Engine<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Up to 1 GiB of free capacity for Looker Studio users.<\/span><\/p><\/td><td style=\"vertical-align: top; padding: 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt 0.5760000000000001pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 11pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">This free capacity is available to all Looker Studio users, without needing a reservation.<\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 12pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">More BigQuery printing detail : <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing#free-tier\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Source<\/span><\/a><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 12pt;\"><span style=\"font-size: 17pt; font-family: 'Google Sans',sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Google Cloud Pricing Calculator<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 12pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloudpricingcalculator.appspot.com\/#!?id=41e34550-42ef-465d-a2b8-adcabcdc3fa6#resultBlock\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">GCP pricing calculator<\/span><\/a><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"> is a web-based tool that provides an estimate of the cost of using GCP services. It is a simple and efficient tool that can be used to understand how pricing works within Google Cloud. The pricing calculator takes into account the type and amount of resources used, as well as the region in which the resources are located. The estimated cost can be used to budget for GCP usage and to compare the costs of different GCP services.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 12pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">The pricing calculator is a valuable tool for anyone who is considering using GCP services. It can help to ensure that you are aware of the costs associated with using GCP and that you are making the most cost-effective choices for your needs.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 12pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><span style=\"border: none; display: inline-block; overflow: hidden; width: 624px; height: 439px;\"><img fetchpriority=\"high\" decoding=\"async\" style=\"margin-left: 0px; margin-top: 0px;\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcrnGRFhPLhNc_3hQ7AMN8lroYW6NAMvJ_ZC6O6pHVgD6ID7esyAcj8zFJvpmlefb7pb-isFEPQXzqc6XxR2f8hxUAFxaJcK49asmmXUJvmp-OlA-k9zuLJhCjveZ89wypcfUL-Cg?key=eTyu9r3OEom1kRYDFS_S6A\" width=\"624\" height=\"439\" \/><\/span><\/span><\/p><p><b id=\"docs-internal-guid-aa3b2f89-7fff-6ca8-fa37-3a5fa14d4723\" style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 12pt 0pt 12pt 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">For information about BigQuery editions pricing, see <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery pricing<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p><h2 dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 6pt 0pt 4pt 0pt;\"><span style=\"font-size: 17pt; font-family: 'Google Sans',sans-serif; color: #202124; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Quotas<\/span><\/h2><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 8pt 0pt 12pt 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Slots from all editions are subject to the same quota. Your quota is not fulfilled on a per-edition basis. For information about quotas, see <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/quotas#reservations\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Quotas and limits<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: -3pt 0pt 9pt 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">For more information on slots autoscaling, see <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/slots-autoscaling-intro\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Introduction to slots autoscaling<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 9pt 0pt;\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">For more information on reservations, see <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reservations-intro\"><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Introduction to Reservations<\/span><\/a><span style=\"font-size: 12pt; font-family: Roboto,sans-serif; color: #202124; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 12pt;\"><span style=\"font-size: 17pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Save Money on BigQuery Storage with New Billing Model<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 12pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">This blog post discusses how to reduce BigQuery storage costs by using Physical Bytes Storage Billing (PBSB) instead of Logical Bytes Storage Billing (LBSB).\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 12pt; margin-bottom: 12pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">PBSB is a way to bill for storage, it takes into account the actual amount of data that you store. LBSB is another way to bill for storage, as it does not require you to track the actual amount of data that you store. The PBSB will include improved observability over table storage metadata. Typically, a 50%-90% compression ratio is observed for Physical Bytes.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 12pt 0pt;\"><span style=\"font-size: 17pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Logical bytes and physical bytes<\/span><\/p><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 12pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery offers two storage billing options: logical bytes and physical bytes. Physical bytes storage billing is more cost-effective for customers who use compression. To reduce storage costs, you can implement a two-step approach:<\/span><\/p><ol style=\"margin-top: 0; margin-bottom: 0; padding-inline-start: 48px;\"><li dir=\"ltr\" style=\"list-style-type: decimal; font-size: 13.5pt; font-family: Arial,sans-serif; color: #5f6368; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\" aria-level=\"1\"><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 12pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Migrate data to a dataset with physical bytes storage billing.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: decimal; font-size: 13.5pt; font-family: Arial,sans-serif; color: #5f6368; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\" aria-level=\"1\"><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 12pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Compress data using BigQuery&#8217;s built-in compression capabilities.<\/span><\/p><\/li><\/ol><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 18pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">First Approach<\/span><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">: Conduct a BigQuery cost benefit assessment between PBSB and LBSB Google has provided an example of how to calculate the price difference at the dataset level using this <\/span><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/information-schema-table-storage#example_2\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">query<\/span><\/a><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">.<\/span><\/p><div dir=\"ltr\" style=\"margin-left: 0pt;\" align=\"left\"><table style=\"border: none; border-collapse: collapse; table-layout: fixed; width: 468pt;\"><colgroup> <col \/><\/colgroup><tbody><tr style=\"height: 0pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\/*<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Source: https:\/\/cloud.google.com\/bigquery\/docs\/information-schema-table-storage#example_2<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">*\/<\/span><\/p><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0DECLARE active_logical_gb_price \u00a0 \u00a0 FLOAT64 DEFAULT 0.02;<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0DECLARE long_term_logical_gb_price\u00a0 FLOAT64 DEFAULT 0.01;<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0DECLARE active_physical_gb_price\u00a0 \u00a0 FLOAT64 DEFAULT 0.04;<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0DECLARE long_term_physical_gb_price FLOAT64 DEFAULT 0.02;\u00a0<\/span><\/p><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0WITH<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0storage_sizes AS (<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SELECT<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0table_schema AS dataset_name,<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SUM(active_logical_bytes) \/ power(1024, 3) AS<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0active_logical_gb,<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SUM(long_term_logical_bytes) \/ power(1024, 3) AS<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0long_term_logical_gb,<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SUM(active_physical_bytes) \/ power(1024, 3) AS<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0active_physical_gb,<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SUM(long_term_physical_bytes) \/ power(1024, 3) AS<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0long_term_physical_gb,<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SUM(total_physical_bytes) \/ power(1024, 3) AS<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0total_physical_gb,<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SUM(total_logical_bytes) \/ power(1024, 3) AS<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0total_logical_gb<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0FROM<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0region-REGION.INFORMATION_SCHEMA.TABLE_STORAGE_BY_PROJECT<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0WHERE<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0total_logical_bytes &gt; 0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0AND total_physical_bytes &gt; 0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0GROUP BY 1<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0)<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0SELECT<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0dataset_name,<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0active_logical_gb,<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0long_term_logical_gb,<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0active_physical_gb,<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0long_term_physical_gb,<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0total_logical_gb \/ total_physical_gb AS compression_ratio,<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0active_logical_gb * active_logical_gb_price AS<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0active_logical_cost,<\/span><\/p><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0long_term_logical_gb * long_term_logical_gb_price AS<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0long_term_logical_cost,<\/span><\/p><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0active_physical_gb * active_physical_gb_price AS active_physical_cost,<\/span><\/p><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0long_term_physical_gb * long_term_physical_gb_price AS<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0long_term_physical_cost,<\/span><\/p><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0((active_logical_gb * active_logical_gb_price) + \u00a0 \u00a0 \u00a0 (long_term_logical_gb * long_term_logical_gb_price))<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8211; ((active_physical_gb * active_physical_gb_price) + (long_term_physical_gb * long_term_physical_gb_price))\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">AS total_cost_difference<\/span><\/p><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0FROM<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0storage_sizes<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0ORDER BY<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0compression_ratio DESC;<\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 18pt 0pt 0pt 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Running the query in the example above results in the following details in the table below;<\/span><\/p><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 18pt 0pt 0pt 0pt;\"><span style=\"font-size: 13.5pt; font-family: Arial,sans-serif; color: #5f6368; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><span style=\"border: none; display: inline-block; overflow: hidden; width: 624px; height: 227px;\"><img decoding=\"async\" style=\"--smush-placeholder-width: 624px; --smush-placeholder-aspect-ratio: 624\/227;margin-left: 0px; margin-top: 0px;\" data-src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcIShPlQpXC3BwZ6B7MM-HwSIVKbrViHQ89X4cRN4iNDi1lQDWvLIFDDd62PBEblUTNFTo9kLl6Qju2KcSQx3ZxKRSl2ByVVIN1LYhuOK11d7MUELPonsDobvJsjXuxySUa-9RV4g?key=eTyu9r3OEom1kRYDFS_S6A\" width=\"624\" height=\"227\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/span><\/span><\/p><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 12pt; padding: 12pt 0pt 0pt 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">The first datasets have a compression ratio of 16 to 25, reducing storage costs by 8x to $8,558\/month. The last dataset uses 96% of active physical storage for time travel, unsuitable for PBSB. The &#8220;_session&#8221; and &#8220;_scripts&#8221; objects are billed based on logical bytes and can be disregarded by modifying the query with this clause<\/span><\/p><div dir=\"ltr\" style=\"margin-left: 0pt;\" align=\"left\"><table style=\"border: none; border-collapse: collapse; table-layout: fixed; width: 468pt;\"><colgroup> <col \/><\/colgroup><tbody><tr style=\"height: 0pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.2; background-color: #ffffff; margin-top: 18pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">where total_logical_bytes &gt; 0 AND total_physical_bytes &gt; 0 AND table_schema not like &#8216;_scripts%&#8217; AND table_schema not like &#8216;_session%&#8217;. [2, 7, 8]<\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 12pt; margin-bottom: 0pt; padding: 0pt 0pt 12pt 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Second approach: <\/span><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">To optimize storage costs, you can switch to physical storage billing for suitable datasets. However, you will not be able to do this if your organization has any flat-rate commitments.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 12pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">To update the billing model for a dataset, use the BigQuery (BQ) update command and set the storage_billing_model flag to PHYSICAL. For example:<\/span><\/p><div dir=\"ltr\" style=\"margin-left: 0pt;\" align=\"left\"><table style=\"border: none; border-collapse: collapse; table-layout: fixed; width: 468pt;\"><colgroup> <col \/><\/colgroup><tbody><tr style=\"height: 0pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 1.2; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">bq update -d &#8211;storage_billing_model=PHYSICAL PROJECT_ID:DATASET_ID<\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 12pt; margin-bottom: 0pt; padding: 0pt 0pt 12pt 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">It takes 24 hours for the change to take effect.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 12pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Another factor to consider is time travel. Time travel allows you to query updated or deleted data, restore deleted tables, or restore expired tables. The default time travel window covers the past seven days, but you can configure it using the BQ command-line tool to balance storage costs with your data retention needs. For example:<\/span><\/p><div dir=\"ltr\" style=\"margin-left: 0pt;\" align=\"left\"><table style=\"border: none; border-collapse: collapse; table-layout: fixed; width: 468pt;\"><colgroup> <col \/><\/colgroup><tbody><tr style=\"height: 0pt;\"><td style=\"vertical-align: top; padding: 5pt 5pt 5pt 5pt; overflow: hidden; overflow-wrap: break-word; border: solid #000000 1pt;\"><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 12pt; margin-bottom: 12pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">bq update &#8211;dataset=true &#8211;max_time_travel_hours=48 PROJECT_ID:DATASET_NAME<\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 12pt 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">This command sets the time travel window to 48 hours (2 days) for the specified dataset.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 12pt 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">The &#8211;max_time_travel_hours value must be an integer expressed in multiples of 24 (48, 72, 96, 120, 144, 168) between 48 (2 days) and 168 (7 days).<\/span><\/p><h2 dir=\"ltr\" style=\"line-height: 1.466664; background-color: #ffffff; margin-top: 0pt; margin-bottom: 27pt; padding: 24pt 0pt 0pt 0pt;\"><span style=\"font-size: 16pt; font-family: Arial,sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Considerations<\/span><\/h2><ul style=\"margin-top: 0; margin-bottom: 0; padding-inline-start: 48px;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 13.5pt; font-family: Arial,sans-serif; color: #5f6368; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\" aria-level=\"1\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 12pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery storage pricing is based on the amount of physical storage used. If you use physical storage, you will be charged twice as much as if you used logical storage.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 13.5pt; font-family: Arial,sans-serif; color: #5f6368; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\" aria-level=\"1\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">To benefit from physical storage billing, your compression ratio must be greater than 2.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 13.5pt; font-family: Arial,sans-serif; color: #5f6368; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\" aria-level=\"1\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">In logical storage billing, you are not charged for bytes used for time travel storage. However, in physical storage billing, you are charged for bytes used for time travel storage. This is because physical storage is used to store both current and historical data.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 13.5pt; font-family: Arial,sans-serif; color: #5f6368; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\" aria-level=\"1\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">To ensure accurate billing, it is advisable to conduct an evaluation of time travel storage utilization once your BigQuery workload has reached a stable state and established a predictable pattern. This is important because the bytes utilized for time travel storage can vary over time.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 13.5pt; font-family: Arial,sans-serif; color: #5f6368; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\" aria-level=\"1\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">You can configure the time travel window according to your specific data retention requirements while considering storage costs. For instance, you can customize the time travel window, adjusting it from the default 7 days to a shorter duration such as 2 days.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 13.5pt; font-family: Arial,sans-serif; color: #5f6368; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\" aria-level=\"1\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">A fail-safe period of 7 days will be enforced, during which the time travel setting cannot be modified. However, once this period ends, you can configure additional time travel days according to your preference. This configurable range extends from 2 to 7 days, allowing you to establish an effective time travel window spanning between 9 and 14 days. If no action is taken, the default time travel window will remain set at 14 days.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 13.5pt; font-family: Arial,sans-serif; color: #5f6368; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\" aria-level=\"1\"><p dir=\"ltr\" style=\"line-height: 1.38; background-color: #ffffff; margin-top: 0pt; margin-bottom: 12pt;\" role=\"presentation\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">You can switch to physical bytes storage billing at any time. However, you must wait 14 days before you can change the billing model again.<\/span><\/p><\/li><\/ul><p><b style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 12pt 0pt 12pt 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\"><span style=\"border: none; display: inline-block; overflow: hidden; width: 624px; height: 228px;\"><img decoding=\"async\" style=\"--smush-placeholder-width: 624px; --smush-placeholder-aspect-ratio: 624\/228;margin-left: 0px; margin-top: 0px;\" data-src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeZ_rnyVntRHyFdGfM-FuV2BENii1tt3GAB7nci-XW9bIZpK2_6StR5BYP6MrFlThtKbC8m6g3Sy-JBc2w2BD4kuDr3KQksKo_Cw-fhuI-qbolrVxPz-wC25l1oHrjlqVyN_jeAYg?key=eTyu9r3OEom1kRYDFS_S6A\" width=\"624\" height=\"228\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/span><\/span><\/p><h1 dir=\"ltr\" style=\"line-height: 1.466664; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 24pt 0pt 27pt 0pt;\"><span style=\"font-size: 20pt; font-family: Arial,sans-serif; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Conclusion<\/span><\/h1><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: -15pt 0pt 12pt 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Switching to BigQuery Physical Bytes Storage Billing (PBSB) can save money on BigQuery storage. The process of assessing and transitioning to this cost-effective billing model is straightforward, so you can maximize the benefits.\u00a0<\/span><\/p><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 12pt 0pt;\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1f1f1f; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Please refer to more information :<\/span><\/p><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 0pt 0pt 12pt 0pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/cloud.google.com\/blog\/products\/data-analytics\/new-bigquery-billing-model-helps-reduce-physical-storage-costs\"><span style=\"font-size: 12pt; font-family: 'Google Sans',sans-serif; color: #1155cc; background-color: #ffffff; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">Reducing BigQuery physical storage cost with new billing model<\/span><\/a><\/p><p dir=\"ltr\" style=\"line-height: 2.1; background-color: #ffffff; margin-top: 0pt; margin-bottom: 0pt; padding: 12pt 0pt 0pt 0pt;\"><a style=\"text-decoration: none;\" href=\"https:\/\/www.linkedin.com\/pulse\/bigquery-storage-billing-models-paul-desmond\/\"><span style=\"font-size: 11pt; font-family: Arial,sans-serif; color: #1155cc; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: underline; -webkit-text-decoration-skip: none; text-decoration-skip-ink: none; vertical-align: baseline; white-space: pre-wrap;\">BigQuery Storage Billing Models<\/span><\/a><\/p><p>\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"featured_media":6830,"template":"","meta":{"postBodyCss":"","postBodyMargin":[],"postBodyPadding":[],"postBodyBackground":{"backgroundType":"classic","gradient":""},"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[18],"tags":[41,84],"class_list":["post-6604","blog","type-blog","status-publish","has-post-thumbnail","hentry","category-blog","tag-bigquery","tag-data"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v26.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>BigQuery Editions: Simple Plans for All Your Data Needs - Admazes - Innovative Marketing &amp; Technology Solutions that Drive Business Values<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BigQuery Editions: Simple Plans for All Your Data Needs\" \/>\n<meta property=\"og:description\" content=\"Introduction to BigQuery editions BigQuery offers three &hellip; BigQuery Editions: Simple Plans for All Your Data Needs \u67e5\u770b\u5168\u6587 &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/\" \/>\n<meta property=\"og:site_name\" content=\"Admazes - Innovative Marketing &amp; Technology Solutions that Drive Business Values\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/admazes\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-07T04:32:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/admazes.com\/wp-content\/uploads\/2024\/10\/\u622a\u5c4f2025-01-07-\u4e0b\u534812.31.48.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1418\" \/>\n\t<meta property=\"og:image:height\" content=\"708\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data1\" content=\"9 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/\",\"url\":\"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/\",\"name\":\"BigQuery Editions: Simple Plans for All Your Data Needs - Admazes - Innovative Marketing &amp; Technology Solutions that Drive Business Values\",\"isPartOf\":{\"@id\":\"https:\/\/admazes.com\/zh-hans\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/admazes.com\/wp-content\/uploads\/2024\/10\/\u622a\u5c4f2025-01-07-\u4e0b\u534812.31.48.png\",\"datePublished\":\"2024-10-19T02:41:00+00:00\",\"dateModified\":\"2025-01-07T04:32:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/#primaryimage\",\"url\":\"https:\/\/admazes.com\/wp-content\/uploads\/2024\/10\/\u622a\u5c4f2025-01-07-\u4e0b\u534812.31.48.png\",\"contentUrl\":\"https:\/\/admazes.com\/wp-content\/uploads\/2024\/10\/\u622a\u5c4f2025-01-07-\u4e0b\u534812.31.48.png\",\"width\":1418,\"height\":708},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/admazes.com\/zh-hans\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BigQuery Editions: Simple Plans for All Your Data Needs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/admazes.com\/zh-hans\/#website\",\"url\":\"https:\/\/admazes.com\/zh-hans\/\",\"name\":\"Admazes - Innovative Marketing & Technology Solutions that Drive Business Values\",\"description\":\"Official Website\",\"publisher\":{\"@id\":\"https:\/\/admazes.com\/zh-hans\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/admazes.com\/zh-hans\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/admazes.com\/zh-hans\/#organization\",\"name\":\"Admazes - Innovative Marketing & Technology Solutions that Drive Business Values\",\"url\":\"https:\/\/admazes.com\/zh-hans\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/admazes.com\/zh-hans\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/35.220.245.118\/wp-content\/uploads\/2024\/05\/Admazes_Logo_outline-1.png\",\"contentUrl\":\"https:\/\/35.220.245.118\/wp-content\/uploads\/2024\/05\/Admazes_Logo_outline-1.png\",\"width\":7200,\"height\":2000,\"caption\":\"Admazes - Innovative Marketing & Technology Solutions that Drive Business Values\"},\"image\":{\"@id\":\"https:\/\/admazes.com\/zh-hans\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/admazes\",\"https:\/\/www.linkedin.com\/company\/admazes\",\"https:\/\/www.instagram.com\/admazes\/\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"BigQuery Editions: Simple Plans for All Your Data Needs - Admazes - Innovative Marketing &amp; Technology Solutions that Drive Business Values","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:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/","og_locale":"zh_CN","og_type":"article","og_title":"BigQuery Editions: Simple Plans for All Your Data Needs","og_description":"Introduction to BigQuery editions BigQuery offers three &hellip; BigQuery Editions: Simple Plans for All Your Data Needs \u67e5\u770b\u5168\u6587 &raquo;","og_url":"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/","og_site_name":"Admazes - Innovative Marketing &amp; Technology Solutions that Drive Business Values","article_publisher":"https:\/\/www.facebook.com\/admazes","article_modified_time":"2025-01-07T04:32:50+00:00","og_image":[{"width":1418,"height":708,"url":"https:\/\/admazes.com\/wp-content\/uploads\/2024\/10\/\u622a\u5c4f2025-01-07-\u4e0b\u534812.31.48.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"9 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/","url":"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/","name":"BigQuery Editions: Simple Plans for All Your Data Needs - Admazes - Innovative Marketing &amp; Technology Solutions that Drive Business Values","isPartOf":{"@id":"https:\/\/admazes.com\/zh-hans\/#website"},"primaryImageOfPage":{"@id":"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/#primaryimage"},"image":{"@id":"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/#primaryimage"},"thumbnailUrl":"https:\/\/admazes.com\/wp-content\/uploads\/2024\/10\/\u622a\u5c4f2025-01-07-\u4e0b\u534812.31.48.png","datePublished":"2024-10-19T02:41:00+00:00","dateModified":"2025-01-07T04:32:50+00:00","breadcrumb":{"@id":"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/#primaryimage","url":"https:\/\/admazes.com\/wp-content\/uploads\/2024\/10\/\u622a\u5c4f2025-01-07-\u4e0b\u534812.31.48.png","contentUrl":"https:\/\/admazes.com\/wp-content\/uploads\/2024\/10\/\u622a\u5c4f2025-01-07-\u4e0b\u534812.31.48.png","width":1418,"height":708},{"@type":"BreadcrumbList","@id":"https:\/\/admazes.com\/zh-hans\/blog\/bigquery-editions-simple-plans-for-all-your-data-needs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/admazes.com\/zh-hans\/"},{"@type":"ListItem","position":2,"name":"BigQuery Editions: Simple Plans for All Your Data Needs"}]},{"@type":"WebSite","@id":"https:\/\/admazes.com\/zh-hans\/#website","url":"https:\/\/admazes.com\/zh-hans\/","name":"Admazes - Innovative Marketing & Technology Solutions that Drive Business Values","description":"Official Website","publisher":{"@id":"https:\/\/admazes.com\/zh-hans\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/admazes.com\/zh-hans\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":"Organization","@id":"https:\/\/admazes.com\/zh-hans\/#organization","name":"Admazes - Innovative Marketing & Technology Solutions that Drive Business Values","url":"https:\/\/admazes.com\/zh-hans\/","logo":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/admazes.com\/zh-hans\/#\/schema\/logo\/image\/","url":"https:\/\/35.220.245.118\/wp-content\/uploads\/2024\/05\/Admazes_Logo_outline-1.png","contentUrl":"https:\/\/35.220.245.118\/wp-content\/uploads\/2024\/05\/Admazes_Logo_outline-1.png","width":7200,"height":2000,"caption":"Admazes - Innovative Marketing & Technology Solutions that Drive Business Values"},"image":{"@id":"https:\/\/admazes.com\/zh-hans\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/admazes","https:\/\/www.linkedin.com\/company\/admazes","https:\/\/www.instagram.com\/admazes\/"]}]}},"_links":{"self":[{"href":"https:\/\/admazes.com\/zh-hans\/wp-json\/wp\/v2\/blog\/6604","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/admazes.com\/zh-hans\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/admazes.com\/zh-hans\/wp-json\/wp\/v2\/types\/blog"}],"version-history":[{"count":0,"href":"https:\/\/admazes.com\/zh-hans\/wp-json\/wp\/v2\/blog\/6604\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/admazes.com\/zh-hans\/wp-json\/wp\/v2\/media\/6830"}],"wp:attachment":[{"href":"https:\/\/admazes.com\/zh-hans\/wp-json\/wp\/v2\/media?parent=6604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/admazes.com\/zh-hans\/wp-json\/wp\/v2\/categories?post=6604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/admazes.com\/zh-hans\/wp-json\/wp\/v2\/tags?post=6604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}