Queries
yaml
type: "io.kestra.plugin.jdbc.arrowflight.queries"Examples
yaml
id: arrow_flight_sql_queries
namespace: company.team
tasks:
- id: query
type: io.kestra.plugin.jdbc.arrowflight.Queries
url: jdbc:arrow-flight-sql://localhost:31010/?useEncryption=false
username: "{{ secret('ARROWFLIGHT_USERNAME') }}"
password: "{{ secret('ARROWFLIGHT_PASSWORD') }}"
sql: SELECT * FROM employee; SELECT * FROM laptop;
fetchType: FETCH
Properties
url *Requiredstring
fetchSize integerstring
Default
10000fetchType string
Default
NONE Possible Values
STOREFETCHFETCH_ONENONEparameters object
password string
sql string
timeZoneId string
transaction booleanstring
Default
trueusername string
Definitions
io.kestra.plugin.jdbc.AbstractJdbcBaseQuery-Output
row object
rows array
SubType object
size integer
uri string
Format
uri