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)

Reference (ref) of the pluginDefaults to apply to this task.

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

Liquibase
Liquibase

Tasks that run Liquibase change management commands.

Data

2 tasks

PostgreSQL
PostgreSQL

Tasks that connect to PostgreSQL via JDBC to run queries and loads.

Data

6 tasks

25 blueprints