Stay organized with collections
Save and categorize content based on your preferences.
Returns the schema of a Cloud Spanner database as a list of formatted
DDL statements. This method does not show pending schema updates, those
may be queried using the Operations API.
For more information about retries and long-running operations, see
Understand connectors.
Arguments
Parameters
database
string
Required. The database whose schema we wish to get. Values are of the form projects//instances//databases/
Raised exceptions
Exceptions
ConnectionError
In case of a network problem (such as DNS failure or refused connection).
HttpError
If the response status is >= 400 (excluding 429 and 503).
TimeoutError
If a long-running operation takes longer to finish than the specified timeout limit.
TypeError
If an operation or function receives an argument of the wrong type.
ValueError
If an operation or function receives an argument of the right type but an inappropriate value. For example, a negative timeout.
[[["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-09-04 UTC."],[],[],null,["# Method: googleapis.spanner.v1.projects.instances.databases.getDdl\n\nReturns the schema of a Cloud Spanner database as a list of formatted\nDDL statements. This method does not show pending schema updates, those\nmay be queried using the Operations API.\n\nFor more information about retries and long-running operations, see\n[Understand connectors]().\n\nArguments\n---------\n\nRaised exceptions\n-----------------\n\nResponse\n--------\n\nIf successful, the response contains an instance of [`GetDatabaseDdlResponse`](https://cloud.google.com/workflows/docs/reference/googleapis/spanner/v1/Overview#GetDatabaseDdlResponse).\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/getDdl). \n\n### YAML\n\n```yaml\n- getDdl:\n call: googleapis.spanner.v1.projects.instances.databases.getDdl\n args:\n database: ...\n result: getDdlResult\n```\n\n### JSON\n\n```json\n[\n {\n \"getDdl\": {\n \"call\": \"googleapis.spanner.v1.projects.instances.databases.getDdl\",\n \"args\": {\n \"database\": \"...\"\n },\n \"result\": \"getDdlResult\"\n }\n }\n]\n```"]]