Google Cloud BatchDml
CertifiedExecute multiple DML statements atomically
Google Cloud BatchDml
Execute multiple DML statements atomically
Executes multiple INSERT, UPDATE, or DELETE statements in a single read-write transaction.
type: io.kestra.plugin.gcp.spanner.BatchDmlExamples
Execute batch DML statements
id: spanner_batch_dml
namespace: company.team
tasks:
- id: batch_update
type: io.kestra.plugin.gcp.spanner.BatchDml
projectId: "{{ secret('GCP_PROJECT_ID') }}"
instanceId: my-instance
databaseId: my-database
statements:
- "UPDATE users SET active = true WHERE signup_date > '2023-01-01'"
- "DELETE FROM temp_sessions WHERE expires_at < CURRENT_TIMESTAMP()"
Properties
databaseId *Requiredstring
The Spanner database ID
instanceId *Requiredstring
The Spanner instance ID
projectId *Requiredstring
The GCP project ID
statements *Requiredarray
The list of SQL DML statements to execute
Statements are executed sequentially without parameter bindings. Parameterized batch DML is not supported.
emulatorHost string
Spanner emulator host (host: port), for local testing only
When set, the task connects to a local Spanner emulator instead of the real Spanner service.
impersonatedServiceAccount string
The GCP service account to impersonate
pluginDefaultsRef Non-dynamicstring
Reference (ref) of the pluginDefaults to apply to this task.
scopes array
The GCP scopes to be used
serviceAccount string
The GCP service account
Outputs
affectedRows array
List of counts of affected rows for each statement
totalAffectedRows integer
Total number of rows affected by all statements combined
