Google Cloud Platform Blog
Product updates, customer stories, and tips and tricks on Google Cloud Platform
Cloud Spanner adds import/export functionality to ease data movement
Tuesday, July 17, 2018
By Deepti Srivastava, Product Manager, Cloud Spanner
We launched Cloud Spanner to
general availability last year
, and many of you shared in our excitement: You explored it, started proof-of-concept trials, and deployed apps. Perhaps most importantly, you gave us feedback along the way. We heard you, and we got to work. Today, we’re happy to announce we’ve launched one of your most commonly requested features: importing and exporting data.
Import/export using Avro
You asked for easier ways to move data. You’ve got it. You can now import and export data easily in the
Cloud Spanner Console
:
Export any Cloud Spanner database into a
Google Cloud Storage
(GCS) bucket.
Import files from a GCS bucket into a new Cloud Spanner database.
These database exports and imports use
Apache Avro
files, transferred with our recently released
Apache Beam
-based Cloud Dataflow
connector
.
Adding imports and exports opens up even more possibilities for your Cloud Spanner data, including:
Disaster recovery
: Export your database at any time and store it in a GCS location of your choice as a backup, which can be imported into a new Cloud Spanner database to restore data.
Testing
: Export a database and then import it into Cloud Spanner as a dev/test database to use for integration tests or other experiments.
Moving databases
: Export a database and import it back into Cloud Spanner in a new/different instance with the console’s simple, push-button functionality.
Ingest for analytics
: Use database exports to ingest your operational data to other services such as BigQuery, for analytics.
BigQuery
can automatically ingest data in Avro format from a GCS bucket, which means it will become easier for you to run analytics on your operational data.
Ready to try it out? See our documentation on how to
import
and
export
data. Learn more about
Cloud Spanner here
, and get started with a
free trial
. For technical support and sales, please
contact us
.
We're excited to see the ways that Cloud Spanner—making application development more efficient, simplifying database administration and management, and providing the benefits of both relational and scale-out, non-relational databases—will continue to help you ship better apps, faster.
Free Trial
GCP Blogs
Big Data & Machine Learning
Kubernetes
GCP Japan Blog
Firebase Blog
Apigee Blog
Popular Posts
Understanding Cloud Pricing
World's largest event dataset now publicly available in BigQuery
A look inside Google’s Data Center Networks
New in Google Cloud Storage: auto-delete, regional buckets and faster uploads
Enter the Andromeda zone - Google Cloud Platform’s latest networking stack
Labels
Announcements
193
Big Data & Machine Learning
134
Compute
271
Containers & Kubernetes
92
CRE
27
Customers
107
Developer Tools & Insights
151
Events
38
Infrastructure
44
Management Tools
87
Networking
43
Open
1
Open Source
135
Partners
102
Pricing
28
Security & Identity
85
Solutions
24
Stackdriver
24
Storage & Databases
164
Weekly Roundups
20
Feed
Subscribe by email
Demonstrate your proficiency to design, build and manage solutions on Google Cloud Platform.
Learn More
Technical questions? Check us out on
Stack Overflow
.
Subscribe to
our monthly newsletter
.
Google
on
Follow @googlecloud
Follow
Follow
Follow