Query
Certified
Execute a single SQL query against Amazon Redshift
Query
Certified
Execute a single SQL query against Amazon Redshift
yaml
type: io.kestra.plugin.jdbc.redshift.QueryExamples
yaml
id: redshift_query
namespace: company.team
tasks:
- id: select
type: io.kestra.plugin.jdbc.redshift.Query
url: jdbc:redshift://123456789.eu-central-1.redshift-serverless.amazonaws.com:5439/dev
username: "{{ secret('REDSHIFT_USERNAME') }}"
password: "{{ secret('REDSHIFT_PASSWORD') }}"
sql: SELECT * FROM redshift_types
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
