Select
yaml
type: "io.kestra.plugin.supabase.select"
Examples
yaml
id: supabase_select_all
namespace: company.team
tasks:
- id: select_users
type: io.kestra.plugin.supabase.Select
url: https://your-project.supabase.com
apiKey: "{{ secret('SUPABASE_API_KEY') }}"
table: users
yaml
id: supabase_select_filtered
namespace: company.team
tasks:
- id: select_active_users
type: io.kestra.plugin.supabase.Select
url: https://your-project.supabase.com
apiKey: "{{ secret('SUPABASE_API_KEY') }}"
table: users
select: "id,name,email,created_at"
filter: "status=eq.active"
order: "created_at.desc"
limit: 50
yaml
id: supabase_select_paginated
namespace: company.team
tasks:
- id: select_users_page
type: io.kestra.plugin.supabase.Select
url: https://your-project.supabase.com
apiKey: "{{ secret('SUPABASE_API_KEY') }}"
table: users
limit: 25
offset: 50
Properties
apiKey *Requiredstring
table *Requiredstring
url *Requiredstring
filter string
limit integerstring
offset integerstring
options Non-dynamicHttpConfiguration
Default
{
"followRedirects": "true",
"allowFailed": "false",
"defaultCharset": "UTF-8"
}
order string
schema string
Default
public
select string
Outputs
code integer
headers object
SubType array
rawResponse string
rows array
SubType object
size integer
uri string
Format
uri
Definitions
io.kestra.core.http.client.configurations.TimeoutConfiguration
connectTimeout string
Format
duration
readIdleTimeout string
Default
PT5M
Format
duration
io.kestra.core.http.client.configurations.BasicAuthConfiguration
type *Requiredobject
password string
username string
java.nio.charset.Charset
io.kestra.core.http.client.configurations.HttpConfiguration
allowFailed booleanstring
Default
false
allowedResponseCodes array
SubType integer
defaultCharset Charsetstring
Default
UTF-8
followRedirects booleanstring
Default
true
logs array
SubType string
Possible Values
REQUEST_HEADERS
REQUEST_BODY
RESPONSE_HEADERS
RESPONSE_BODY
proxy ProxyConfiguration
ssl SslOptions
timeout TimeoutConfiguration
io.kestra.core.http.client.configurations.ProxyConfiguration
address string
password string
port integerstring
type string
Default
DIRECT
Possible Values
DIRECT
HTTP
SOCKS