Queries
Execute multiple SQL statements against Microsoft SQL Server
Queries
Execute multiple SQL statements against Microsoft SQL Server
yaml
type: io.kestra.plugin.jdbc.sqlserver.QueriesExamples
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
sql *Requiredstring
url *Requiredstring
afterSQL string
encrypt string
Default
FALSEPossible Values
TRUEFALSESTRICTOPTIONALfetchSize integerstring
Default
10000fetchType string
Default
NONEPossible Values
STOREFETCHFETCH_ONENONEhostNameInCertificate string
parameters object
password string
timeZoneId string
transaction booleanstring
Default
truetrustServerCertificate booleanstring
Default
falsetrustStore string
trustStorePassword string
username string
Outputs
outputs array
Definitions
io.kestra.plugin.jdbc.AbstractJdbcBaseQuery-Output
rowobject
rowsarray
SubTypeobject
sizeinteger
uristring
Format
uriMetrics
fetch.size counter
Unit
rows