Google Cloud Execute

Google Cloud Execute

Certified

Execute a DML or DDL statement

Executes an INSERT, UPDATE, DELETE statement, or schema change DDL statement.

yaml
type: io.kestra.plugin.gcp.spanner.Execute

Execute DML to update records

yaml
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

The Spanner database ID

The Spanner instance ID

The GCP project ID

The SQL statement to execute

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.

The GCP service account to impersonate

Defaultfalse

Whether the statement is a DDL statement

Query parameters (only applicable to DML)

SubTypestring

The GCP scopes to be used

The GCP service account

The number of rows affected by the statement (DML only)

More Plugins in this Category

VMware (EE)
VMware
Enterprise

Tasks that automate VMware vSphere operations within Kestra workflows.

Infrastructure

33 tasks

3 blueprints

Canonical (EE)
Canonical
Enterprise

Tasks to interact with Canonical services, enabling automation and infrastructure management through API-driven workflows.

CloudInfrastructure

5 tasks