BatchDml

BatchDml
Certified
Execute multiple DML statements atomically.

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

Examples

yaml
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 *string

instanceId *string

projectId *string

statements *array

SubTypestring

emulatorHost string

impersonatedServiceAccount string

scopes array

SubTypestring

serviceAccount string

Outputs

affectedRows array

SubTypeinteger

totalAffectedRows integer

CloudQuery

Tasks that run CloudQuery commands to sync data through the CLI.

Data

Docker

Docker tasks for building images, running containers, and managing artifacts from Kestra workflows.

CoreInfrastructure

BatchDmlCertifiedExecute multiple DML statements atomically.

More Plugins in this Category

CloudQuery

Docker

BatchDml
Certified
Execute multiple DML statements atomically.