Google Cloud Execute
CertifiedExecute a DML or DDL statement
Google Cloud Execute
Execute a DML or DDL statement
Executes an INSERT, UPDATE, DELETE statement, or schema change DDL statement.
type: io.kestra.plugin.gcp.spanner.ExecuteExamples
Execute DML to update records
id: spanner_execute_dml
namespace: company.team
tasks:
- id: update
type: io.kestra.plugin.gcp.spanner.Execute
projectId: "{{ secret('GCP_PROJECT_ID') }}"
instanceId: my-instance
databaseId: my-database
sql: "UPDATE orders SET status = 'processed' WHERE processed_at IS NULL"
Properties
databaseId *string
The Spanner database ID
instanceId *string
The Spanner instance ID
projectId *string
The GCP project ID
sql *string
The SQL statement to execute
assets
Assets this task consumes as inputs or produces as outputs, for lineage tracking and the asset graph (Enterprise Edition). A flow declaring this property on a task is rejected in the open-source edition.
io.kestra.core.models.assets.AssetsDeclaration
IGNOREFAILWARNAsset failure behavior
Behavior applied to the task state when a declared asset fails to render, emit, or be persisted (e.g. a lock conflict): FAIL escalates it to FAILED, WARN (default) warns it if it would otherwise succeed, IGNORE leaves the state untouched.
Whether to auto-register assets referenced dynamically at runtime that are not statically declared in inputs or outputs.
The assets consumed as inputs.
io.kestra.core.models.assets.AssetIdentifier
1The assets produced as outputs.
io.kestra.plugin.ee.assets.Dataset
1150{}1150io.kestra.plugin.ee.assets.File
1150{}1150io.kestra.plugin.ee.assets.Table
1150{}1150io.kestra.plugin.ee.assets.VM
1150{}1150io.kestra.core.models.assets.External
1150{}1150io.kestra.core.models.assets.Custom
11501Custom asset type
{}1150emulatorHost 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
isDdl booleanstring
falseWhether the statement is a DDL statement
parameters object
Query parameters (only applicable to DML)
scopes array
The GCP scopes to be used
serviceAccount string
The GCP service account
Outputs
affectedRows integer
The number of rows affected by the statement (DML only)
