Search code examples
google-cloud-platformcommand-line-interfacegoogle-cloud-spanner

How to specify fully identified database qualifier in Google Spanner


https://cloud.google.com/sdk/gcloud/reference/spanner/databases/execute-sql says that the database positional parameter in an execute-sql command can be "ID of the database or fully qualified identifier for the database".

I can't find the syntax for such a fully qualified identifier. Looked/searched anywhere I could think of in the documentation.

Trying standard separators (slash, dot, colon, etc) produces random error messages.

Any ideas?


Solution

  • The fully qualified name of a Cloud Spanner database takes the following format:

    projects/<project-id>/instances/<instance-id>/databases/<database-id>