database_operations

Creates, updates, deletes, gets or lists a database_operations resource.

Overview

Name	database_operations
Type	Resource
Id	google.spanner.database_operations

Fields

Name	Datatype	Description
name	string	The server-assigned name, which is only unique within the same service that originally returns it. If you use the default HTTP mapping, the name should be a resource name ending with operations/{unique_id}.
done	boolean	If the value is false, it means the operation is still in progress. If true, the operation is completed, and either error or response is available.
error	object	The Status type defines a logical error model that is suitable for different programming environments, including REST APIs and RPC APIs. It is used by gRPC. Each Status message contains three pieces of data: error code, error message, and error details. You can find out more about this error model and how to work with it in the API Design Guide.
metadata	object	Service-specific metadata associated with the operation. It typically contains progress information and common metadata such as create time. Some services might not provide such metadata. Any method that returns a long-running operation should document the metadata type, if any.
response	object	The normal, successful response of the operation. If the original method returns no data on success, such as Delete, the response is google.protobuf.Empty. If the original method is standard Get/Create/Update, the response should be the resource. For other methods, the response should have the type XxxResponse, where Xxx is the original method name. For example, if the original method name is TakeSnapshot(), the inferred response type is TakeSnapshotResponse.

Methods

Name	Accessible by	Required Params	Description
projects_instances_database_operations_list	SELECT	instancesId, projectsId	Lists database longrunning-operations. A database operation has a name of the form projects//instances//databases//operations/. The long-running operation metadata field type metadata.type_url describes the type of the metadata. Operations returned include those that have completed/failed/canceled within the last 7 days, and pending operations.

SELECT examples

Lists database longrunning-operations. A database operation has a name of the form projects//instances//databases//operations/. The long-running operation metadata field type metadata.type_url describes the type of the metadata. Operations returned include those that have completed/failed/canceled within the last 7 days, and pending operations.

SELECT
name,
done,
error,
metadata,
response
FROM google.spanner.database_operations
WHERE instancesId = '{{ instancesId }}'
AND projectsId = '{{ projectsId }}';