Stay organized with collections
Save and categorize content based on your preferences.
Updates a Cloud Spanner database. The returned long-running operation
can be used to track the progress of updating the database. If the named
database does not exist, returns NOT_FOUND. While the operation is
pending: * The database's reconciling field is set to true. * Cancelling
the operation is best-effort. If the cancellation succeeds, the
operation metadata's cancel_time is set, the updates are reverted, and
the operation terminates with a CANCELLED status. * New UpdateDatabase
requests will return a FAILED_PRECONDITION error until the pending
operation is done (returns successfully or with error). * Reading the
database via the API continues to give the pre-request values. Upon
completion of the returned operation: * The new values are in effect and
readable via the API. * The database's reconciling field becomes false.
The returned long-running operation will have a name of the format
projects//instances//databases//operations/ and can be used to track
the database modification. The metadata field type is
UpdateDatabaseMetadata. The response field type is Database, if
successful.
This method waits—the workflow execution is paused—until the operation is
complete, fails, or times out. The default timeout value is 1800 seconds (30
minutes) and can be changed to a maximum value of 31536000 seconds (one year)
for long-running operations using the connector_params field.
The connector uses polling to monitor the long-running operation, which might
generate additional billable steps. The polling policy for the long-running
operation can be configured. For example, if you set skip_polling to True,
the connector invocation call is non-blocking if the initial request succeeds;
otherwise, retries might occur.
For more information about connector-specific parameters (connector_params),
see Invoke a connector call.
For more information about retries and long-running operations, see
Understand connectors.
Arguments
Parameters
name
string
Required. The name of the database. Values are of the form projects//instances//databases/, where ` is as specified in theCREATE DATABASE` statement. This name can be passed to other API methods to identify the database.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-28 UTC."],[],[],null,["# Method: googleapis.spanner.v1.projects.instances.databases.patch\n\nUpdates a Cloud Spanner database. The returned long-running operation\ncan be used to track the progress of updating the database. If the named\ndatabase does not exist, returns `NOT_FOUND`. While the operation is\npending: \\* The database's reconciling field is set to true. \\* Cancelling\nthe operation is best-effort. If the cancellation succeeds, the\noperation metadata's cancel_time is set, the updates are reverted, and\nthe operation terminates with a `CANCELLED` status. \\* New UpdateDatabase\nrequests will return a `FAILED_PRECONDITION` error until the pending\noperation is done (returns successfully or with error). \\* Reading the\ndatabase via the API continues to give the pre-request values. Upon\ncompletion of the returned operation: \\* The new values are in effect and\nreadable via the API. \\* The database's reconciling field becomes false.\nThe returned long-running operation will have a name of the format\n`projects//instances//databases//operations/` and can be used to track\nthe database modification. The metadata field type is\nUpdateDatabaseMetadata. The response field type is Database, if\nsuccessful.\n\nThis method waits---the workflow execution is paused---until the operation is\ncomplete, fails, or times out. The default timeout value is `1800` seconds (30\nminutes) and can be changed to a maximum value of `31536000` seconds (one year)\nfor long-running operations using the `connector_params` field.\n\nThe connector uses polling to monitor the long-running operation, which might\ngenerate additional billable steps. The polling policy for the long-running\noperation can be configured. For example, if you set `skip_polling` to `True`,\nthe connector invocation call is non-blocking if the initial request succeeds;\notherwise, retries might occur.\n\nFor more information about connector-specific parameters (`connector_params`),\nsee [Invoke a connector call](/workflows/docs/reference/googleapis#invoke_a_connector_call).\n\nFor more information about retries and long-running operations, see\n[Understand connectors](/workflows/docs/connectors).\n\nArguments\n---------\n\nRaised exceptions\n-----------------\n\nResponse\n--------\n\nIf successful, the response contains an instance of [`Operation`](https://cloud.google.com/workflows/docs/reference/googleapis/spanner/v1/Overview#Operation).\n\nSubworkflow snippet\n-------------------\n\nSome fields might be optional or required.\nTo identify required fields, refer to the [API documentation](https://cloud.google.com/spanner/docs/reference/rest/v1/projects.instances.databases/patch). \n\n### YAML\n\n```yaml\n- patch:\n call: googleapis.spanner.v1.projects.instances.databases.patch\n args:\n name: ...\n updateMask: ...\n body:\n enableDropProtection: ...\n name: ...\n result: patchResult\n```\n\n### JSON\n\n```json\n[\n {\n \"patch\": {\n \"call\": \"googleapis.spanner.v1.projects.instances.databases.patch\",\n \"args\": {\n \"name\": \"...\",\n \"updateMask\": \"...\",\n \"body\": {\n \"enableDropProtection\": \"...\",\n \"name\": \"...\"\n }\n },\n \"result\": \"patchResult\"\n }\n }\n]\n```"]]