Cloud Spanner is a Google RDBMS that provides a global transactional database. This issue requests the creation of a new node or nodes for Cloud Spanner interaction.
At first blush, it appears that we want a node that will execute SQL statements supplied in string format. While the statements are supplied as String SQL, we need two configuration parameters at the node level. These appear to be:
The key to the story is the database.run() function call documented here.
There are a rich set of additional options to Spanner but these are currently not in scope. Items in this list would include
transactions
streaming
table creation
meta data retrieval
... more
Node spec
Node name: Spanner Run
Configuration parameters:
instance name - A single line text entry field.
database name - A single line text entry field.
SQL statements - A multi line text box.
Execution
When the node is reached, if a value is present in "SQL statements", the execution will use that value. If not present, the execution will use the value contained in msg.payload. On completion, the output will be found in msg.payload. The actual output will depend on the statements executes but for a query will be an array of records.
Cloud Spanner is a Google RDBMS that provides a global transactional database. This issue requests the creation of a new node or nodes for Cloud Spanner interaction.
At first blush, it appears that we want a node that will execute SQL statements supplied in string format. While the statements are supplied as String SQL, we need two configuration parameters at the node level. These appear to be:
The high level access code looks to be:
The key to the story is the
database.run()
function call documented here.There are a rich set of additional options to Spanner but these are currently not in scope. Items in this list would include
Node spec
Node name:
Spanner Run
Configuration parameters:
Execution When the node is reached, if a value is present in "SQL statements", the execution will use that value. If not present, the execution will use the value contained in
msg.payload
. On completion, the output will be found inmsg.payload
. The actual output will depend on the statements executes but for a query will be an array of records.References