Spanner
Kubemq gcp-spanner target connector allows services using kubemq server to access google spanner server.
Prerequisites
The following are required to run the gcp-spanner target connector:
kubemq cluster
gcp-spanner set up
kubemq-source deployment
Configuration
spanner target connector configuration properties:
Properties Key | Required | Description | Example |
db | yes | gcp spanner db name | "/mydb" should conform to pattern "^projects/(?P+)/instances/(?P+)/databases/(?P+)$" |
credentials | yes | gcp credentials files | "<google json credentials" |
Example:
Usage
Query Request
create query request.
Query metadata setting:
Metadata Key | Required | Description | Possible values |
method | yes | type of method | "query" |
query | yes | the query body | "select * from table" |
Example:
Read Table Request by columns
read table by table_name
Read Table metadata setting:
Metadata Key | Required | Description | Possible values |
method | yes | type of method | "read" |
table_name | yes | table name to read from | "" |
Example:
Insert Or Update Table
insert or update a table
Insert Or Update metadata setting:
Metadata Key | Required | Description | Possible values |
method | yes | type of method | "insert","update","insert_or_update" |
Example:
Last updated