Query

Query
Certified
Execute a Spanner SQL query.

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

Examples

yaml
id: spanner_query
namespace: company.team

inputs:
  - id: min_age
    type: INT
    defaults: 18

tasks:
  - id: query
    type: io.kestra.plugin.gcp.spanner.Query
    projectId: "{{ secret('GCP_PROJECT_ID') }}"
    instanceId: my-instance
    databaseId: my-database
    sql: "SELECT * FROM users WHERE age >= @minAge"
    parameters:
      minAge: "{{ inputs.min_age }}"
    fetchType: STORE

Properties

databaseId *string

instanceId *string

projectId *string

sql *string

emulatorHost string

fetchType string

DefaultNONE

Possible Values

STOREFETCHFETCH_ONENONE

impersonatedServiceAccount string

parameters object

scopes array

SubTypestring

serviceAccount string

Outputs

row object

rows array

SubTypeobject

size integer

uri string

Formaturi

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

QueryCertifiedExecute a Spanner SQL query.

More Plugins in this Category

CloudQuery

Docker

Query
Certified
Execute a Spanner SQL query.