Queries
Queries
yaml
type: "io.kestra.plugin.jdbc.clickhouse.Queries"Examples
yaml
id: clickhouse_queries
namespace: company.team
tasks:
- id: queries
type: io.kestra.plugin.jdbc.clickhouse.Queries
url: jdbc:clickhouse://127.0.0.1:56982/
username: "{{ secret('CLICKHOUSE_USERNAME') }}"
password: "{{ secret('CLICKHOUSE_PASSWORD') }}"
sql: select * from employee; select * from laptop;
fetchType: STORE
Properties
sql*Requiredstring
url*Requiredstring
afterSQLstring
fetchSizeintegerstring
Default
10000fetchTypestring
Default
NONEPossible Values
STOREFETCHFETCH_ONENONEparametersobject
passwordstring
timeZoneIdstring
transactionbooleanstring
Default
trueusernamestring
Outputs
outputsarray
Definitions
io.kestra.plugin.jdbc.AbstractJdbcBaseQuery-Output
rowobject
rowsarray
SubTypeobject
sizeinteger
uristring
Format
uriMetrics
fetch.sizecounter
Unit
rows