All Cloud Spanner code samples

Use the Dataflow connector to read data from multiple tables at the same point in time to ensure data consistency by performing all of the reads in a single transaction.

Java

View sample

View in documentation

Using the Dataflow connector

Dataflow write group

Use the Dataflow connector to write data by using a MutationGroup class to ensure that a group of mutations is applied atomically.

Java

View sample

View in documentation

Using the Dataflow connector

Dataflow write with mutations

Use the Dataflow connector to write data by using mutations.

Java

View sample

View in documentation

Using the Dataflow connector

Delete backup

Delete a database backup.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Backing up and Restoring Databases using Client Libraries

Delete data

Delete individual rows from a table.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Inserting, updating, and deleting data using mutations

DML delete data

Delete rows that match a WHERE condition by using DML.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Inserting, updating, and deleting data using Data Manipulation Language

DML update commit timestamp

Write a commit timestamp by using a DML statement.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Inserting, updating, and deleting data using Data Manipulation Language

DML update data

Update data using DML.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Inserting, updating, and deleting data using Data Manipulation Language

DML update data with STRUCT

Update data by using DML with a STRUCT object.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

DML write data

Write data by using DML.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

DML write single row

Insert a single row by using DML.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Inserting, updating, and deleting data using Data Manipulation Language

DML write then read

Insert data and then read the inserted data.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Inserting, updating, and deleting data using Data Manipulation Language

Field access on a STRUCT

Query data using field access on a STRUCT.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Working with STRUCT objects

Field access on nested STRUCT

Query data using field access on a nested STRUCT.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Working with STRUCT objects

Functions

Connect by using functions.

C++ Go Java Node.js Python

View sample

View in documentation

Using Cloud Spanner with Cloud Functions

Hibernate generated IDs

Create a hibernate UUID.

Java

View sample

Hibernate inheritance

Use hibernate inheritance and UUIDs to save a payment record in a database.

Java

View sample

Hibernate table name

Specify a table name by using hibernate.

Java

View sample

JDBC batch transaction

Make a batch transaction by using JDBC.

Java

View sample

View in documentation

Using the open-source JDBC driver

JDBC connection with query options

Set connection query options by using JDBC.

Java

View sample

View in documentation

Managing the query optimizer

JDBC create table

Create a table by using JDBC.

Java

View sample

View in documentation

Using the open-source JDBC driver

JDBC insert

Insert data by using JDBC.

Java

View sample

View in documentation

Using the open-source JDBC driver

JDBC query

Run a query by using JDBC.

Java

View sample

View in documentation

Using the open-source JDBC driver

JDBC set statement for query options

Use the SET statement to specify query options by using JDBC.

Java

View sample

View in documentation

Managing the query optimizer

List backup operations

List all create backup operations running on the database and list the percentage complete for each operation.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Backing up and Restoring Databases using Client Libraries

List backups

List all backups and access backup data using filters and paging.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Backing up and Restoring Databases using Client Libraries

List database operations

List all operations running on the database and list the percentage complete for each operation.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Backing up and Restoring Databases using Client Libraries

Mutations update data

Update data by using mutations.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Mutations update data with NUMERIC

Update data in NUMERIC column by using mutations.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Working with NUMERIC data

Mutations update data with TIMESTAMP

Update data in a table containing a TIMESTAMP column by using mutations.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Commit timestamps

Mutations write data

Insert several rows of data into a table by using mutations.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Mutations write data for STRUCT queries

Insert data used for STRUCT queries.

C# C++ Go Java Node.js PHP Python Ruby

View sample

Mutations write data types data

Insert data into a table with example data types by using mutations.

C# C++ Go Java Node.js PHP Python Ruby

View sample

Mutations write data with TIMESTAMP column

Write data into a table containing a TIMESTAMP column by using mutations.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Commit timestamps

Query data

Query data.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Query data from a new column

Query data from a new column.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Query data with array of STRUCT

Query data by using an array of STRUCT objects.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Working with STRUCT objects

Query data with commit timestamp

Query data from a table containing a commit TIMESTAMP column.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Commit timestamps

Query data with index

Query data by using an index.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Secondary indexes

Query data with parameter

Query data by using a parameter.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Query data with STRUCT

Query data by using a STRUCT object.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Working with STRUCT objects

Query with ARRAY parameter

Query data by using an ARRAY parameter.

C# C++ Go Java Node.js PHP Python Ruby

View sample

Query with BOOL parameter

Query data by using a BOOL parameter.

C# C++ Go Java Node.js PHP Python Ruby

View sample

Query with BYTES parameter

Query data by using a BYTES parameter.

C# C++ Go Java Node.js PHP Python Ruby

View sample

Query with DATE parameter

Query data by using a DATE parameter.

C# C++ Go Java Node.js PHP Python Ruby

View sample

Query with FLOAT parameter

Query data by using a FLOAT parameter.

C# C++ Go Java Node.js PHP Python Ruby

View sample

Query with INT parameter

Query data by using an INT parameter.

C# C++ Go Java Node.js PHP Python Ruby

View sample

Query with NUMERIC parameter

Query data by using a NUMERIC parameter.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Working with NUMERIC data

Query with query options

Specify query options.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Managing the query optimizer

Query with STRING parameter

Query data by using a STRING parameter.

C# C++ Go Java Node.js PHP Python Ruby

View sample

Query with TIMESTAMP parameter

Query data by using a TIMESTAMP parameter.

C# C++ Go Java Node.js PHP Python Ruby

View sample

Quickstart

Use a basic SELECT query.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Read data

Read data.

C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Read data in parallel

Read data in parallel by dividing the query into smaller pieces, or partitions, and fetching the partitions in parallel.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Reads

Read data in parallel—execute query partition

Use a transaction to execute a query partition for reading data in parallel.

Node.js

View sample

View in documentation

Reads

Read data with index

Read data by using an index.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Read stale data

Read stale data.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Reads

Read-only transaction

Use a read-only transaction.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Read/write transaction

Use a read/write transaction.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Read/write transaction—retry strategy

Use an example retry strategy.

C#

View sample

View in documentation

Getting started with Cloud Spanner in C#

Restore database from backup

Restore a database from a backup.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Set custom timeout and retry

Set custom timeout and retry for request settings.

C# Go Java Node.js Ruby

View sample

View in documentation

Configuring custom timeouts and retries

Update backup

Update a backup by retrieving the expiry time of a backup and extending it.

C# C++ Go Java Node.js PHP Python Ruby

View sample

View in documentation

Backing up and Restoring Databases using Client Libraries