Queries
Certified
Execute multiple SQL statements against Snowflake
Queries
Certified
Execute multiple SQL statements against Snowflake
yaml
type: io.kestra.plugin.jdbc.snowflake.QueriesExamples
yaml
id: snowflake_queries
namespace: company.team
tasks:
- id: select
type: io.kestra.plugin.jdbc.snowflake.Queries
url: jdbc:snowflake://<account_identifier>.snowflakecomputing.com
username: "{{ secret('SNOWFLAKE_USERNAME') }}"
password: "{{ secret('SNOWFLAKE_PASSWORD') }}"
sql: select * from demo_db.public.customers; select * from demo_db.public.emplyees;
fetchType: FETCH
Properties
sql *Requiredstring
url *Requiredstring
afterSQL string
database string
fetchSize integerstring
Default
10000fetchType string
Default
NONEPossible Values
STOREFETCHFETCH_ONENONEoutputFiles array
SubTypestring
parameters object
password string
privateKey string
privateKeyPassword string
queryTag string
role string
schema string
timeZoneId string
transaction booleanstring
Default
trueusername string
warehouse string
Outputs
outputs array
Definitions
io.kestra.plugin.jdbc.AbstractJdbcBaseQuery-Output
rowobject
rowsarray
SubTypeobject
sizeinteger
uristring
Format
uriMetrics
fetch.size counter
Unit
rows
