yaml
type: "io.kestra.plugin.jdbc.sqlserver.Queries"
yaml
id: sqlserver_query
namespace: company.team

tasks:
  - id: select
    type: io.kestra.plugin.jdbc.sqlserver.Queries
    url: jdbc:sqlserver://localhost:41433;trustServerCertificate=true
    username: "{{ secret('SQL_USERNAME') }}"
    password: "{{ secret('SQL_PASSWORD') }}"
    sql: select * from employee; select * from laptop;
    fetchType: FETCH
Properties
Default10000
DefaultNONE
Possible Values
STOREFETCHFETCH_ONENONE
Defaulttrue
Definitions
rowobject
rowsarray
SubTypeobject
sizeinteger
uristring
Formaturi
Unitrows