Query

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

Examples

yaml
id: vectorwise_query
namespace: company.team

tasks:
  - id: query
    type: io.kestra.plugin.jdbc.vectorwise.Query
    url: jdbc:vectorwise://url:port/base
    username: "{{ secret('VECTORWISE_USERNAME') }}"
    password: "{{ secret('VECTORWISE_PASSWORD') }}"
    sql: select * from vectorwise_types
    fetchType: FETCH_ONE

Properties

url *string

fetchSize integerstring

Default 10000

fetchType string

Default NONE

Possible Values

STOREFETCHFETCH_ONENONE

parameters object

password string

sql string

timeZoneId string

username string

Outputs

row object

rows array

SubType object

size integer

uri string

Format uri

​Query

Query