Queries
yaml
type: "io.kestra.plugin.jdbc.snowflake.queries"
Examples
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
url *Requiredstring
database string
fetchSize integerstring
Default
10000
fetchType string
Default
NONE
Possible Values
STORE
FETCH
FETCH_ONE
NONE
parameters object
password string
privateKey string
privateKeyPassword string
role string
schema string
sql string
timeZoneId string
transaction booleanstring
Default
true
username string
warehouse string
Definitions
io.kestra.plugin.jdbc.AbstractJdbcBaseQuery-Output
row object
rows array
SubType object
size integer
uri string
Format
uri