Query 
Query
yaml
type: "io.kestra.plugin.jdbc.dremio.Query"Examples
yaml
id: dremio_query
namespace: company.team
tasks:
- id: query
type: io.kestra.plugin.jdbc.dremio.Query
url: jdbc:dremio:direct=sql.dremio.cloud:443;ssl=true;PROJECT_ID=sampleProjectId;
username: dremio_token
password: samplePersonalAccessToken
sql: select * FROM source.database.table
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
username string
Outputs
row object
rows array
SubTypeobject
size integer
uri string
Format
uriMetrics
fetch.size counter
Unit
rows
