We launched Cloud Spanner to basic availability final 12 months, and lots of of you shared in our pleasure: You explored it, began proof-of-concept trials, and deployed apps. Maybe most significantly, you gave us suggestions alongside the best way. We heard you, and we started working. At the moment, we’re completely happy to announce we’ve launched certainly one of your mostly requested options: importing and exporting knowledge.
Import/export utilizing Avro
You requested for simpler methods to maneuver knowledge. You’ve bought it. Now you can import and export knowledge simply within the Cloud Spanner Console:
- Export any Cloud Spanner database right into a Google Cloud Storage (GCS) bucket.
- Import information from a GCS bucket into a brand new Cloud Spanner database.
These database exports and imports use Apache Avro information, transferred with our just lately launched Apache Beam-based Cloud Dataflow connector.
Including imports and exports opens up much more potentialities on your Cloud Spanner knowledge, together with:
- Catastrophe restoration: Export your database at any time and retailer it in a GCS location of your alternative as a backup, which will be imported into a brand new Cloud Spanner database to revive knowledge.
- Testing: Export a database after which import it into Cloud Spanner as a dev/check database to make use of for integration assessments or different experiments.
- Shifting databases: Export a database and import it again into Cloud Spanner in a brand new/totally different occasion with the console’s easy, push-button performance.
- Ingest for analytics: Use database exports to ingest your operational knowledge to different companies reminiscent of BigQuery, for analytics. BigQuery can routinely ingest knowledge in Avro format from a GCS bucket, which suggests it can turn into simpler so that you can run analytics in your operational knowledge.
Able to strive it out? See our documentation on the right way to import and export knowledge. Study extra about Cloud Spanner right here, and get began with a free trial. For technical assist and gross sales, please contact us.
We’re excited to see the ways in which Cloud Spanner—making utility improvement extra environment friendly, simplifying database administration and administration, and offering the advantages of each relational and scale-out, non-relational databases—will proceed that can assist you ship higher apps, quicker.
