CODEWITHSUNDEEP
google-cloud-platformgoogle-cloud-spanner
Balkan
Balkan

Reputation: 711

Is there a gcloud command to export a spanner database?

I would like to automate exports of our Spanner database to Google Cloud Storage. Is this possible using the gcloud SDK? I could not find a command for this.

Is there any other recommended way to back up Spanner databases?

Upvotes: 1

Views: 1356

Answers (2)

Biswa Nag
Biswa Nag

Reputation: 141

Yes, it is possible to do this using gcloud, but it is not a direct Cloud Spanner command. The detailed documentation is here.

Essentially you use gcloud to run a Cloud Dataflow job to export or backup your data to GCS using a command like the following:

gcloud dataflow jobs run [JOB_NAME] \
--gcs-location='gs://dataflow-templates/latest/Cloud_Spanner_to_GCS_Avro' \
--region=[DATAFLOW_REGION] \
--parameters='instanceId=[YOUR_INSTANCE_ID],databaseId=[YOUR_DATABASE_ID],outputDir=[YOUR_GCS_DIRECTORY]

Upvotes: 1

RedPandaCurios
RedPandaCurios

Reputation: 2324

The export and Import pipelines are Dataflow templates that can be started using the Gcloud command.

See the third paragraph in: https://cloud.google.com/spanner/docs/export And how to run the template in: https://cloud.google.com/dataflow/docs/guides/templates/provided-templates#cloud_spanner_to_gcs_avro (Select the Gcloud tab in the executing the template section).

Upvotes: 1

Related Questions