Stay organized with collections
Save and categorize content based on your preferences.
Spanner Data Boost is a fully managed, serverless service that provides
independent compute resources for supported Spanner workloads.
Data Boost lets you execute analytics queries and data exports
with near-zero impact to existing workloads on the provisioned
Spanner instance. The service consists of Spanner
clusters that Google manages at the region level. For eligible queries that
request Data Boost, Spanner routes the workload to
these servers transparently. Eligible queries are those for which the first
operator in the query execution plan is a distributed union. These queries don't
have to change to take advantage of Data Boost.
Data Boost is most impactful in the following scenarios where you
want to avoid negative impacts to the existing transactional system due to
resource contention:
Ad hoc or infrequent queries that involve processing large amounts of data.
A typical example is a federated
query
from BigQuery to Spanner.
Reporting or data export jobs. An example is a Dataflow job to
export Spanner data to Cloud Storage.
The following diagram illustrates how Data Boost coordinates with
the Spanner instance to provide independent compute resources.
Benefits
Data Boost offers the following benefits:
Provides workload isolation. You can run supported queries against the
latest data with near-zero impact on existing transactional workloads
regardless of query complexity or amount of data processed.
Provides equal or better latency.
Prevents over-provisioning of Spanner instances just to
support occasional analytics queries.
Offers a high degree of scalability with greater query parallelism that
scales elastically with burst loads.
Provides comprehensive metrics, which let administrators identify the most
expensive queries and determine the cost component to optimize.
Administrators can then verify the impact of their optimizations by
monitoring the query's serverless processing unit consumption in its next
execution.
Requires no additional operational overhead. There is no extra service to
manage, no capacity planning or provisioning, no need to wait for scaling,
and no maintenance.
Permissions
Any principal that runs a query or export that requests Data Boost
must have the spanner.databases.useDataBoost Identity and Access Management (IAM)
permission. We recommend that you use the
Cloud Spanner Database Reader With DataBoost (roles/spanner.databaseReaderWithDataBoost)
IAM role.
Billing and quotas
You pay only for actual processing units used by queries that run on
Data Boost. Administrators can set limits on usage to avoid cost
overruns.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-28 UTC."],[],[],null,["# Data Boost overview\n\nSpanner Data Boost is a fully managed, serverless service that provides\nindependent compute resources for supported Spanner workloads.\nData Boost lets you execute analytics queries and data exports\nwith near-zero impact to existing workloads on the provisioned\nSpanner instance. The service consists of Spanner\nclusters that Google manages at the region level. For eligible queries that\nrequest Data Boost, Spanner routes the workload to\nthese servers transparently. Eligible queries are those for which the first\noperator in the query execution plan is a distributed union. These queries don't\nhave to change to take advantage of Data Boost.\n\nData Boost is most impactful in the following scenarios where you\nwant to avoid negative impacts to the existing transactional system due to\nresource contention:\n\n- Ad hoc or infrequent queries that involve processing large amounts of data. A typical example is a [federated\n query](/bigquery/docs/spanner-federated-queries) from BigQuery to Spanner.\n- Reporting or data export jobs. An example is a Dataflow job to export Spanner data to Cloud Storage.\n\nThe following diagram illustrates how Data Boost coordinates with\nthe Spanner instance to provide independent compute resources.\n\nBenefits\n--------\n\nData Boost offers the following benefits:\n\n- Provides workload isolation. You can run supported queries against the latest data with near-zero impact on existing transactional workloads regardless of query complexity or amount of data processed.\n- Provides equal or better latency.\n- Prevents over-provisioning of Spanner instances just to support occasional analytics queries.\n- Offers a high degree of scalability with greater query parallelism that scales elastically with burst loads.\n- Provides comprehensive metrics, which let administrators identify the most expensive queries and determine the cost component to optimize. Administrators can then verify the impact of their optimizations by monitoring the query's serverless processing unit consumption in its next execution.\n- Requires no additional operational overhead. There is no extra service to manage, no capacity planning or provisioning, no need to wait for scaling, and no maintenance.\n\nPermissions\n-----------\n\nAny principal that runs a query or export that requests Data Boost\nmust have the `spanner.databases.useDataBoost` Identity and Access Management (IAM)\npermission. We recommend that you use the\n`Cloud Spanner Database Reader With DataBoost` (`roles/spanner.databaseReaderWithDataBoost`)\nIAM role.\n\nBilling and quotas\n------------------\n\nYou pay only for actual processing units used by queries that run on\nData Boost. Administrators can set limits on usage to avoid cost\noverruns.\n\nWhat's next\n-----------\n\n- [Run federated queries with Data Boost](/spanner/docs/databoost/databoost-run-queries)\n- [Export data with Data Boost](/spanner/docs/databoost/databoost-export)\n- [Use Data Boost in your applications](/spanner/docs/databoost/databoost-applications)\n- [Monitor Data Boost usage](/spanner/docs/databoost/databoost-monitor)\n- [Monitor and manage Data Boost quota usage](/spanner/docs/databoost/databoost-quotas)"]]
