Stay organized with collectionsSave and categorize content based on your preferences.
This page explains how to use Spanner Data Boost to export Spanner
data with near-zero impact to existing workloads on the provisioned
Spanner instance.
You can export data by using theExport datapage in the
Spanner console, or by using a Dataflow
template.
Before you begin
Ensure that you have thespanner.databases.useDataBoostIdentity and Access Management (IAM)
permission. For more information, seeAccess control with IAM.
Export data by using the Spanner console
To export data in Avro format by using the Spanner console:
[[["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-09-04 UTC."],[],[],null,["# Export data with Data Boost\n\nThis page explains how to use Spanner Data Boost to export Spanner data with near-zero impact to existing workloads on the provisioned Spanner instance.\n\n\u003cbr /\u003e\n\nTo learn about Data Boost,\nsee [Data Boost overview](/spanner/docs/databoost/databoost-overview).\n\nYou can export data by using the **Export data** page in the\nSpanner console, or by using a Dataflow\ntemplate.\n\nBefore you begin\n----------------\n\nEnsure that you have the\n`spanner.databases.useDataBoost` Identity and Access Management (IAM)\npermission. For more information, see [Access control with IAM](../iam#databases).\n\nExport data by using the Spanner console\n----------------------------------------\n\nTo export data in Avro format by using the Spanner console:\n\n1. Follow the instructions in\n [Export databases from Spanner to Avro](../export).\n\n2. Select the **Use Spanner Data Boost** checkbox.\n\nTo export data in CSV format:\n\n- Use the [Spanner to Cloud Storage Text](/dataflow/docs/guides/templates/provided/cloud-spanner-to-cloud-storage) Dataflow template. See the next section.\n\nExport data by using Dataflow templates\n---------------------------------------\n\nTo run Dataflow exports with Data Boost,\nselect one of the following options: \n\n### Console\n\n1. Go to one of the following pages:\n\n - [Spanner to Cloud Storage Avro](/dataflow/docs/guides/templates/provided/cloud-spanner-to-avro)\n - [Spanner to Cloud Storage Text](/dataflow/docs/guides/templates/provided/cloud-spanner-to-cloud-storage)\n2. Follow the **Console** instructions under **Run the template**.\n\n3. On the **Create job from template** page, under **Optional parameters** ,\n enter `true` in the\n **Use Spanner Data Boost** field.\n\n### gcloud CLI\n\n1. Go to one of the following pages:\n\n - [Spanner to Cloud Storage Avro](/dataflow/docs/guides/templates/provided/cloud-spanner-to-avro)\n - [Spanner to Cloud Storage Text](/dataflow/docs/guides/templates/provided/cloud-spanner-to-cloud-storage)\n2. Follow the **gloud** instructions under **Run the template**.\n\n3. Add the following parameter to the command:\n\n dataBoostEnabled=true\n\n The following example runs the Spanner to Cloud Storage Avro\n template and specifies the use of Data Boost. \n\n ```bash\n gcloud dataflow jobs run my_export_job \\\n --gcs-location gs://dataflow-templates/latest/Cloud_Spanner_to_GCS_Avro \\\n --region us-central1 \\\n --staging-location gs://mybucket/temp \\\n --parameters \\\n instanceId=my_instance,\\\n databaseId=my_database,\\\n outputDir=gs://mybucket/export \\\n dataBoostEnabled=true\n ```\n\nWhat's next\n-----------\n\n- Learn about Data Boost in [Data Boost overview](/spanner/docs/databoost/databoost-overview).\n- [Use Data Boost in your applications](/spanner/docs/databoost/databoost-applications)"]]
