Queries 
Execute multiple SQL statements against Vertica
Queries
Execute multiple SQL statements against Vertica
yaml
type: "io.kestra.plugin.jdbc.vertica.Queries"Examples
yaml
id: vertica_queries
namespace: company.team
tasks:
- id: queries
type: io.kestra.plugin.jdbc.vertica.Queries
url: jdbc:vertica://127.0.0.1:56982/db
username: "{{ secret('VERTICA_USERNAME') }}"
password: "{{ secret('VERTICA_PASSWORD') }}"
sql: SELECT * FROM customer
fetchType: FETCH_ONE
Properties
sql *Requiredstring
url *Requiredstring
afterSQL string
fetchSize integerstring
Default
10000fetchType string
Default
NONEPossible Values
STOREFETCHFETCH_ONENONEparameters object
password string
timeZoneId string
transaction booleanstring
Default
trueusername string
Outputs
outputs array
Definitions
io.kestra.plugin.jdbc.AbstractJdbcBaseQuery-Output
rowobject
rowsarray
SubTypeobject
sizeinteger
uristring
Format
uriMetrics
fetch.size counter
Unit
rows
