Spanner Connection
Use this connection to access data in Spanner.
Property | Macro Enabled? | Description |
---|---|---|
Name | No | Required. Name of the connection. Connection names must be unique in a namespace. Connection names can only include letters, numbers, underscores, and hyphens. |
Description | No | Optional. Description of the connection. |
Project ID | No | Required. Google Cloud Project ID, which uniquely identifies a project. It can be found on the Dashboard in the Google Cloud Platform Console. Default is auto-detect. |
Service Account Type | Yes | Required. Select one of the following options:
|
Service Account File Path | Yes | Required. Path on the local file system of the service account key used for authorization. Can be set to 'auto-detect' when running on a Dataproc cluster. When running on other clusters, the file must be present on every node in the cluster. Default is auto-detect. |
Service Account JSON | Yes | Required. Content of the service account. |
Path of the connection
To browse, get a sample from, or get the specification for this connection through Pipeline Microservices, the path
property is required in the request body. It can be in the following form:
/{instance}/{database}/{table}
This path indicates a table. A table is the only one that can be sampled. Browse on this path to return the specified table./{instance}/{database}
This path indicates a database. A database cannot be sampled. Browse on this path to get all the tables under this database./{instance}
This path indicates a instance. A instance cannot be sampled. Browse on this path to get all the databases under this instance./
This path indicates the root. A root cannot be sampled. Browse on this path to get all the instances visible through this connection.
Created in 2020 by Google Inc.