Cloud Spanner API

Cloud Spanner is a managed, mission-critical, globally consistent and scalable relational database service.

Service: spanner.googleapis.com

To call this service, we recommend that you use the Google-provided client libraries. If your application needs to use your own libraries to call this service, use the following information when you make the API requests.

Discovery document

A Discovery Document is a machine-readable specification for describing and consuming REST APIs. It is used to build client libraries, IDE plugins, and other tools that interact with Google APIs. One service may provide multiple discovery documents. This service provides the following discovery document:

Service endpoint

A service endpoint is a base URL that specifies the network address of an API service. One service might have multiple service endpoints. This service has the following service endpoint and all URIs below are relative to this service endpoint:

  • https://spanner.googleapis.com

Regional service endpoint

A regional service endpoint is a base URL that specifies the network address of an API service in a single region. A service that is available in multiple regions might have multiple regional endpoints. Select a location to see its regional service endpoint for this service.


REST Resource: v1.projects.instanceConfigOperations

Methods
list GET /v1/{parent=projects/*}/instanceConfigOperations
Lists the user-managed instance configuration long-running operations in the given project.

REST Resource: v1.projects.instanceConfigs

Methods
create POST /v1/{parent=projects/*}/instanceConfigs
Creates an instance configuration and begins preparing it to be used.
delete DELETE /v1/{name=projects/*/instanceConfigs/*}
Deletes the instance configuration.
get GET /v1/{name=projects/*/instanceConfigs/*}
Gets information about a particular instance configuration.
list GET /v1/{parent=projects/*}/instanceConfigs
Lists the supported instance configurations for a given project.
patch PATCH /v1/{instanceConfig.name=projects/*/instanceConfigs/*}
Updates an instance configuration.

REST Resource: v1.projects.instanceConfigs.operations

Methods
cancel POST /v1/{name=projects/*/instanceConfigs/*/operations/*}:cancel
Starts asynchronous cancellation on a long-running operation.
delete DELETE /v1/{name=projects/*/instanceConfigs/*/operations/*}
Deletes a long-running operation.
get GET /v1/{name=projects/*/instanceConfigs/*/operations/*}
Gets the latest state of a long-running operation.
list GET /v1/{name=projects/*/instanceConfigs/*/operations}
Lists operations that match the specified filter in the request.

REST Resource: v1.projects.instances

Methods
create POST /v1/{parent=projects/*}/instances
Creates an instance and begins preparing it to begin serving.
delete DELETE /v1/{name=projects/*/instances/*}
Deletes an instance.
get GET /v1/{name=projects/*/instances/*}
Gets information about a particular instance.
getIamPolicy POST /v1/{resource=projects/*/instances/*}:getIamPolicy
Gets the access control policy for an instance resource.
list GET /v1/{parent=projects/*}/instances
Lists all instances in the given project.
move POST /v1/{name=projects/*/instances/*}:move
Moves an instance to the target instance configuration.
patch PATCH /v1/{instance.name=projects/*/instances/*}
Updates an instance, and begins allocating or releasing resources as requested.
setIamPolicy POST /v1/{resource=projects/*/instances/*}:setIamPolicy
Sets the access control policy on an instance resource.
testIamPermissions POST /v1/{resource=projects/*/instances/*}:testIamPermissions
Returns permissions that the caller has on the specified instance resource.

REST Resource: v1.projects.instances.backupOperations

Methods
list GET /v1/{parent=projects/*/instances/*}/backupOperations
Lists the backup long-running operations in the given instance.

REST Resource: v1.projects.instances.backups

Methods
copy POST /v1/{parent=projects/*/instances/*}/backups:copy
Starts copying a Cloud Spanner Backup.
create POST /v1/{parent=projects/*/instances/*}/backups
Starts creating a new Cloud Spanner Backup.
delete DELETE /v1/{name=projects/*/instances/*/backups/*}
Deletes a pending or completed Backup.
get GET /v1/{name=projects/*/instances/*/backups/*}
Gets metadata on a pending or completed Backup.
getIamPolicy POST /v1/{resource=projects/*/instances/*/backups/*}:getIamPolicy
Gets the access control policy for a database or backup resource.
list GET /v1/{parent=projects/*/instances/*}/backups
Lists completed and pending backups.
patch PATCH /v1/{backup.name=projects/*/instances/*/backups/*}
Updates a pending or completed Backup.
setIamPolicy POST /v1/{resource=projects/*/instances/*/backups/*}:setIamPolicy
Sets the access control policy on a database or backup resource.
testIamPermissions POST /v1/{resource=projects/*/instances/*/backups/*}:testIamPermissions
Returns permissions that the caller has on the specified database or backup resource.

REST Resource: v1.projects.instances.backups.operations

Methods
cancel POST /v1/{name=projects/*/instances/*/backups/*/operations/*}:cancel
Starts asynchronous cancellation on a long-running operation.
delete DELETE /v1/{name=projects/*/instances/*/backups/*/operations/*}
Deletes a long-running operation.
get GET /v1/{name=projects/*/instances/*/backups/*/operations/*}
Gets the latest state of a long-running operation.
list GET /v1/{name=projects/*/instances/*/backups/*/operations}
Lists operations that match the specified filter in the request.

REST Resource: v1.projects.instances.databaseOperations

Methods
list GET /v1/{parent=projects/*/instances/*}/databaseOperations
Lists database longrunning-operations.

REST Resource: v1.projects.instances.databases

Methods
addSplitPoints POST /v1/{database=projects/*/instances/*/databases/*}:addSplitPoints
Adds split points to specified tables and indexes of a database.
changequorum POST /v1/{name=projects/*/instances/*/databases/*}:changequorum
ChangeQuorum is strictly restricted to databases that use dual-region instance configurations.
create POST /v1/{parent=projects/*/instances/*}/databases
Creates a new Spanner database and starts to prepare it for serving.
dropDatabase DELETE /v1/{database=projects/*/instances/*/databases/*}
Drops (aka deletes) a Cloud Spanner database.
get GET /v1/{name=projects/*/instances/*/databases/*}
Gets the state of a Cloud Spanner database.
getDdl GET /v1/{database=projects/*/instances/*/databases/*}/ddl
Returns the schema of a Cloud Spanner database as a list of formatted DDL statements.
getIamPolicy POST /v1/{resource=projects/*/instances/*/databases/*}:getIamPolicy
Gets the access control policy for a database or backup resource.
list GET /v1/{parent=projects/*/instances/*}/databases
Lists Cloud Spanner databases.
patch PATCH /v1/{database.name=projects/*/instances/*/databases/*}
Updates a Cloud Spanner database.
restore POST /v1/{parent=projects/*/instances/*}/databases:restore
Create a new database by restoring from a completed backup.
setIamPolicy POST /v1/{resource=projects/*/instances/*/databases/*}:setIamPolicy
Sets the access control policy on a database or backup resource.
testIamPermissions POST /v1/{resource=projects/*/instances/*/databases/*}:testIamPermissions
Returns permissions that the caller has on the specified database or backup resource.
updateDdl PATCH /v1/{database=projects/*/instances/*/databases/*}/ddl
Updates the schema of a Cloud Spanner database by creating/altering/dropping tables, columns, indexes, etc.

REST Resource: v1.projects.instances.databases.backupSchedules

Methods
create POST /v1/{parent=projects/*/instances/*/databases/*}/backupSchedules
Creates a new backup schedule.
delete DELETE /v1/{name=projects/*/instances/*/databases/*/backupSchedules/*}
Deletes a backup schedule.
get GET /v1/{name=projects/*/instances/*/databases/*/backupSchedules/*}
Gets backup schedule for the input schedule name.
getIamPolicy POST /v1/{resource=projects/*/instances/*/databases/*/backupSchedules/*}:getIamPolicy
Gets the access control policy for a database or backup resource.
list GET /v1/{parent=projects/*/instances/*/databases/*}/backupSchedules
Lists all the backup schedules for the database.
patch PATCH /v1/{backupSchedule.name=projects/*/instances/*/databases/*/backupSchedules/*}
Updates a backup schedule.
setIamPolicy POST /v1/{resource=projects/*/instances/*/databases/*/backupSchedules/*}:setIamPolicy
Sets the access control policy on a database or backup resource.
testIamPermissions POST /v1/{resource=projects/*/instances/*/databases/*/backupSchedules/*}:testIamPermissions
Returns permissions that the caller has on the specified database or backup resource.

REST Resource: v1.projects.instances.databases.databaseRoles

Methods
list GET /v1/{parent=projects/*/instances/*/databases/*}/databaseRoles
Lists Cloud Spanner database roles.
testIamPermissions POST /v1/{resource=projects/*/instances/*/databases/*/databaseRoles/*}:testIamPermissions
Returns permissions that the caller has on the specified database or backup resource.

REST Resource: v1.projects.instances.databases.operations

Methods
cancel POST /v1/{name=projects/*/instances/*/databases/*/operations/*}:cancel
Starts asynchronous cancellation on a long-running operation.
delete DELETE /v1/{name=projects/*/instances/*/databases/*/operations/*}
Deletes a long-running operation.
get GET /v1/{name=projects/*/instances/*/databases/*/operations/*}
Gets the latest state of a long-running operation.
list GET /v1/{name=projects/*/instances/*/databases/*/operations}
Lists operations that match the specified filter in the request.

REST Resource: v1.projects.instances.databases.sessions

Methods
adaptMessage POST /v1/{name=projects/*/instances/*/databases/*/sessions/*}:adaptMessage
Handles a single message from the client and returns the result as a stream.
adapter POST /v1/{parent=projects/*/instances/*/databases/*}/sessions:adapter
Creates a new session to be used for requests made by the adapter.
batchCreate POST /v1/{database=projects/*/instances/*/databases/*}/sessions:batchCreate
Creates multiple new sessions.
batchWrite POST /v1/{session=projects/*/instances/*/databases/*/sessions/*}:batchWrite
Batches the supplied mutation groups in a collection of efficient transactions.
beginTransaction POST /v1/{session=projects/*/instances/*/databases/*/sessions/*}:beginTransaction
Begins a new transaction.
commit POST /v1/{session=projects/*/instances/*/databases/*/sessions/*}:commit
Commits a transaction.
create POST /v1/{database=projects/*/instances/*/databases/*}/sessions
Creates a new session.
delete DELETE /v1/{name=projects/*/instances/*/databases/*/sessions/*}
Ends a session, releasing server resources associated with it.
executeBatchDml POST /v1/{session=projects/*/instances/*/databases/*/sessions/*}:executeBatchDml
Executes a batch of SQL DML statements.
executeSql POST /v1/{session=projects/*/instances/*/databases/*/sessions/*}:executeSql
Executes an SQL statement, returning all results in a single reply.
executeStreamingSql POST /v1/{session=projects/*/instances/*/databases/*/sessions/*}:executeStreamingSql
Like ExecuteSql, except returns the result set as a stream.
get GET /v1/{name=projects/*/instances/*/databases/*/sessions/*}
Gets a session.
list GET /v1/{database=projects/*/instances/*/databases/*}/sessions
Lists all sessions in a given database.
partitionQuery POST /v1/{session=projects/*/instances/*/databases/*/sessions/*}:partitionQuery
Creates a set of partition tokens that can be used to execute a query operation in parallel.
partitionRead POST /v1/{session=projects/*/instances/*/databases/*/sessions/*}:partitionRead
Creates a set of partition tokens that can be used to execute a read operation in parallel.
read POST /v1/{session=projects/*/instances/*/databases/*/sessions/*}:read
Reads rows from the database using key lookups and scans, as a simple key/value style alternative to ExecuteSql.
rollback POST /v1/{session=projects/*/instances/*/databases/*/sessions/*}:rollback
Rolls back a transaction, releasing any locks it holds.
streamingRead POST /v1/{session=projects/*/instances/*/databases/*/sessions/*}:streamingRead
Like Read, except returns the result set as a stream.

REST Resource: v1.projects.instances.instancePartitionOperations

Methods
list GET /v1/{parent=projects/*/instances/*}/instancePartitionOperations
Lists instance partition long-running operations in the given instance.

REST Resource: v1.projects.instances.instancePartitions

Methods
create POST /v1/{parent=projects/*/instances/*}/instancePartitions
Creates an instance partition and begins preparing it to be used.
delete DELETE /v1/{name=projects/*/instances/*/instancePartitions/*}
Deletes an existing instance partition.
get GET /v1/{name=projects/*/instances/*/instancePartitions/*}
Gets information about a particular instance partition.
list GET /v1/{parent=projects/*/instances/*}/instancePartitions
Lists all instance partitions for the given instance.
patch PATCH /v1/{instancePartition.name=projects/*/instances/*/instancePartitions/*}
Updates an instance partition, and begins allocating or releasing resources as requested.

REST Resource: v1.projects.instances.instancePartitions.operations

Methods
cancel POST /v1/{name=projects/*/instances/*/instancePartitions/*/operations/*}:cancel
Starts asynchronous cancellation on a long-running operation.
delete DELETE /v1/{name=projects/*/instances/*/instancePartitions/*/operations/*}
Deletes a long-running operation.
get GET /v1/{name=projects/*/instances/*/instancePartitions/*/operations/*}
Gets the latest state of a long-running operation.
list GET /v1/{name=projects/*/instances/*/instancePartitions/*/operations}
Lists operations that match the specified filter in the request.

REST Resource: v1.projects.instances.operations

Methods
cancel POST /v1/{name=projects/*/instances/*/operations/*}:cancel
Starts asynchronous cancellation on a long-running operation.
delete DELETE /v1/{name=projects/*/instances/*/operations/*}
Deletes a long-running operation.
get GET /v1/{name=projects/*/instances/*/operations/*}
Gets the latest state of a long-running operation.
list GET /v1/{name=projects/*/instances/*/operations}
Lists operations that match the specified filter in the request.