Spanner documentation
Spanner is a fully managed, mission-critical database service that brings together relational, graph, key-value, and search. It offers transactional consistency at global scale, automatic, synchronous replication for high availability, and support for two SQL dialects: GoogleSQL (ANSI 2011 with extensions) and PostgreSQL.
Not sure what database option is right for you? Learn more about our database services.
Start your next project with $300 in free credit
Build and test a proof of concept with the free trial credits and free monthly usage of 20+ products.
Documentation resources
Guides
-
Quickstart: Create and query a database by using the Google Cloud console
-
Create and manage instances
-
Choose GoogleSQL or PostgreSQL Google Cloud console
-
Import and export data in CSV format
-
Create and manage foreign key relationships
-
Insert, update, and delete data using Data Manipulation Language (DML)
-
Insert, update, and delete data using mutations
-
Use the Dataflow connector
-
Set up and query Spanner Graph using the Google Cloud console
-
Monitor instances with Cloud Monitoring
-
Emulate Spanner locally
-
Troubleshoot performance regressions
Resources
Related resources
Related videos
Gen AI databases: speed, scale and security
Ready to get started? → https://goo.gle/4icxI12 How do you choose the right database for generative AI? Learn about speed, scale, and security with AlloyDB, Spanner, Firestore, and Cloud SQL. Discover how to handle massive data, complex queries, and
Vector-enabled databases: unlock semantic search!
Enroll today! → https://goo.gle/4icxI12 Unlock the power of generative AI! Learn how vector embeddings and Google Cloud databases (AlloyDB, Spanner, Cloud SQL, BigQuery, Firestore) revolutionize data handling for AI applications. Discover how to
Transactional vs. analytical workloads
Which database is right for you? → https://goo.gle/4icxI12 Confused about database workloads? Learn the difference between transactional (OLTP) and analytical (OLAP) workloads and how to choose the right Google Cloud database. We'll explore Cloud
Relational vs. NoSQL: databases explained simply
Ready to learn more? → https://goo.gle/4icxI12 Demystifying databases! Learn the core differences between relational and NoSQL databases on Google Cloud. We'll cover Cloud SQL, Spanner, Firestore, Bigtable, and more. Understand when to use each for
Stop guessing! Choose the right Google Cloud database
Enroll today! → https://goo.gle/4icxI12 Tired of database confusion? Learn to confidently select the right Google Cloud database for ANY application! This course breaks down Cloud SQL, AlloyDB, Spanner, Bigtable, Firestore, and Memorystore. Plus, get
New Way Now: Dojo is a payments powerhouse, delivering 60% faster transactions with Spanner
*Featured in this video:* Rob Howes, SVP of technology at Dojo *Executive summary:* With Google Cloud, Dojo is enabling millions of secure, reliable, and ultra-fast payment experiences daily, empowering businesses to serve more customers, cash up
No-Fuss AI Database Connections with GenAI Toolbox
Building AI agents? Stop wrestling with databases! GenAI Toolbox connects your AI to databases including Postgres, AlloyDB, & Spanner with WAY less boilerplate. Check out this demo with a hotel booking agent on AlloyDB data, and then try it out
New Way Now: Wayfair furnishes a new era of developer productivity with Google Cloud's AI
𝗦𝘂𝗺𝗺𝗮𝗿𝘆: Niraj Nagrani, VP and GM for Consumer and Supplier Technologies at Wayfair, shares how the global home furnishings giant is partnering with Google Cloud to supercharge its technology transformation. Discover how Wayfair is using Google
Intelligent Search at scale with Spanner
Full-text search overview → https://goo.gle/3XtaXOq Google Cloud Spanner’s new search features builds on Google’s decades of experience and expertise in search and delivers highly scalable text search and advanced search capability that captures user
New Way Now: Electronic Arts is powering up Ultimate Team infrastructure with Google Cloud
𝗦𝘂𝗺𝗺𝗮𝗿𝘆: Wilson Chan, senior principal architect at Electronic Arts (EA), shares how Google Cloud is helping the leading game developer bring its interactive live gaming experiences to the next level. EA pulled off a seamless migration of its global
Gmail's Spanner Revolution - How Planet-Scale Infra Transformed Silently
Learn how Google silently migrated billions of users, trillions of emails, and exabytes of data to Spanner – without anyone noticing! Join Developer Advocate Priyanka Vergadia as she sits down with Google Workspace Engineering Manager Sudev Bohra,
Introducing Spanner ANN: fast and scalable vector search
Learn about how easy it is to use Spanner’s new fast and scalable ANN vector search based on ScaNN, Google Research’s highly efficient vector similarity search algorithm adapted for Spanner’s distributed architecture. Spanner is Google Cloud's fully
Credit Karma's database transformation: From sharded MySQL to Spanner
MySQL is the most widely used open-source relational database. However, it was designed to scale up using larger machines. When you need to scale out, you’re often faced with manual sharding. Sharding introduces operational challenges, hinders
Spanner for relational and NoSQL Workloads
Spanner under the hood - Learn more about the always-on and most scalable database that supports relational, and key-value models to simplify application modernization. See how Spanner can transform your database landscape. Watch more: All sessions
Non-relational databases design patterns: How Shopify leverages them to power their business
When your data outgrows the confines of traditional relational models, Google Cloud's databases offer the solution. This session will explore how to harness the power of distributed architectures and flexible schemas to handle massive datasets. We'll
Delivering win after win: How Bandai Namco launches games on Google Cloud
Launching a game is hard, but the pressure intensifies when your players are also fans of beloved franchises, such as Dragon Ball, Tekken, and My Hero. Delivering a perfect experience from day one requires a robust and scalable cloud infrastructure.
The future of databases and generative AI
Join us for an insightful session that explores the exciting future of Google Cloud‘s managed databases, including Cloud SQL, AlloyDB, and Spanner. Vector search capabilities deeply integrated into operational databases enable powerful enterprise
Cloud SQL, Cloud Spanner, or Firestore?
Be a Cloud Digital Leader! https://goo.gle/CDL What's the difference between Cloud SQL, Cloud Spanner, and Firestore, and how do you know when to choose one over the other? This video breaks it down to help you on your journey to become Cloud Digital
New Way Now: Macquarie Bank is building a new way of interacting with financial services
Luis Uguina, Chief Digital Officer of Macquarie Bank, shares how Google Cloud is helping the financial services group remove traditional roadblocks and embrace the AI era. Macquarie Bank has gone all-in on cloud, utilizing Google Cloud services like
Supercharge vector search with Spanner
Spanner KNN documentation → https://goo.gle/3IRespO Try Spanner Vector Search yourself → https://goo.gle/4a6ytVm Spanner is Google Cloud's fully managed distributed database service that combines horizontal scalability with relational semantics,
Data sharing done right: Spanner Data Boost
Explore Spanner documentation → https://goo.gle/48gQijI Read about Spanner → https://goo.gle/48BHNzs Data Boost overview → https://goo.gle/3voiNgV Create a scalable, highly available, globally distributed Spanner database powered by Data Boost to
Building next-generation databases at Google: Cloud Spanner under the hood
Learn about Google Cloud’s differentiated architecture and how it’s designed to solve customer use cases for the digitized economy. Discover common architectural patterns that Google Ads and Gmail solve to achieve infinite scale, developer
Run impact-less ad hoc queries and data exports on Cloud Spanner
Learn how you can run ad hoc batch queries or export terabytes of data on demand from your Cloud Spanner database without impacting your business-critical applications. This session will go over how world renowned Deutsche Bank partnered with Google
Driving digital transformation with Google databases
Today, digital transformation is key to enabling companies to become more future-proof. In this session, we’ll go over the latest innovations from our portfolio of transformative databases that can help you on this journey. Our premier partner
Learn how CERC has disrupted the exchange receivables market with new Spanner innovations
Financial Services innovators rely on Spanner for its unmatched scalability and hands-free management. Learn about the latest innovations in AI, operational analytics, and distributed SQL that make Spanner more powerful and accessible for banks,
What is Cloud Spanner Data Boost?
With Cloud Spanner Data Boost, developers can execute heavy analytical queries with near-zero impact to existing workloads on their Spanner instance. Watch along and see how you can enable Data Boost without impacting your application and user
How Character.ai uses Google Cloud databases to scale its growing Gen AI platform
With generative AI’s unprecedented growth, Character.AI needed to quickly make their platform more scalable and reliable for its users. Since migrating to AlloyDB, Character.AI serves five times the query volume at half the query latency. They also
Database deployment options in GKE
Connect to Cloud SQL from GKE → https://goo.gle/Connect_GKE_Cloud_SQL Deploy an app using GKE and Cloud Spanner → https://goo.gle/Connect_GKE_Cloud_Spanner This video describes your database options when deploying stateful applications on Google
How Google Photos scales to store 4 trillion photos and videos
How Google Photos scaled rapidly on Spanner → https://goo.gle/44HbYDL You can download, view, or edit your photos on Google Photos from anywhere in the world, anytime. How does Google offer such a reliable service for billions of users globally? In
Cloud Next 2023, Google research program, and more!
What’s new with Google Cloud? Welcome to our weekly series where we serve you the lowest latency news. This week, we’re talking about the Google Cloud Research Innovators program, Scaling Google Photos with spanner, and getting ready for Next 2023!