Queries
yaml
type: "io.kestra.plugin.jdbc.mariadb.queries"
Examples
yaml
id: send_multiple_queries
namespace: test.queries
tasks:
- id: test_queries_insert
type: io.kestra.plugin.jdbc.mariadb.Queries
fetchType: FETCH
url: jdbc:mariadb://mariadb:3306/kestra
username: "${{secret('MARIADB_USERNAME')}}"
password: "${{secret('MARIADB_PASSWORD')}}"
sql: "{{ read('populate.sql') }}"
- id: test_queries_select
type: io.kestra.plugin.jdbc.mariadb.Queries
fetchType: FETCH
url: jdbc:mariadb://mariadb:3306/kestra
username: root
password: mariadb_passwd
sql: |
SELECT firstName, lastName FROM employee;
SELECT brand FROM laptop;
Properties
url *Requiredstring
fetchSize integerstring
Default
10000
fetchType string
Default
NONE
Possible Values
STORE
FETCH
FETCH_ONE
NONE
inputFile string
parameters object
password string
sql string
timeZoneId string
transaction booleanstring
Default
true
username string
Definitions
io.kestra.plugin.jdbc.AbstractJdbcBaseQuery-Output
row object
rows array
SubType object
size integer
uri string
Format
uri