Queries

yaml
type: "io.kestra.plugin.jdbc.vectorwise.Queries"

Examples

yaml
id: vectorwise_queries
namespace: company.team

tasks:
  - id: queries
    type: io.kestra.plugin.jdbc.vectorwise.Queries
    url: jdbc:vectorwise://url:port/base
    username: "{{ secret('VECTORWISE_USERNAME') }}"
    password: "{{ secret('VECTORWISE_PASSWORD') }}"
    sql: select count(*) from employee; select count(*) from laptop;
    fetchType: FETCH_ONE

Properties

sql*string

url*string

afterSQLstring

fetchSizeintegerstring

Default10000

fetchTypestring

DefaultNONE

Possible Values

STOREFETCHFETCH_ONENONE

parametersobject

passwordstring

timeZoneIdstring

transactionbooleanstring

Defaulttrue

usernamestring

Outputs

outputsarray

Definitions

io.kestra.plugin.jdbc.AbstractJdbcBaseQuery-Output

rowobject

rowsarray

SubTypeobject

sizeinteger

uristring

Formaturi

Metrics

fetch.sizecounter

Unitrows