Select
Select data from a Supabase table using the REST API.
Select data from a Supabase table using the REST API.
Select data from a Supabase table using the REST API.
This task queries data from a Supabase table using the REST API with support for filtering, ordering, and pagination.
type: "io.kestra.plugin.supabase.Select"Examples
Select all records from a table.
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
Select specific columns with filtering and ordering.
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
Select with pagination.
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
The Supabase API key
The API key for authenticating with Supabase -- use the anon key for client-side operations or the service_role key for server-side operations with elevated privileges.
table*Requiredstring
The name of the table to select from
The name of the table in your Supabase database
url*Requiredstring
The Supabase project URL
The URL of your Supabase project (e.g., https://your-project.supabase.com)
filterstring
Filter conditions
Filter conditions using PostgREST syntax (e.g., 'status=eq.active', 'age=gte.18')
limitintegerstring
Limit the number of rows returned
Maximum number of rows to return
offsetintegerstring
Offset for pagination
Number of rows to skip for pagination
optionsNon-dynamic
{
"followRedirects": "true",
"allowFailed": "false",
"defaultCharset": "UTF-8"
}io.kestra.core.http.client.configurations.HttpConfiguration
falseIf true, allow a failed response code (response code >= 400)
List of response code allowed for this request
The authentification to use.
io.kestra.core.http.client.configurations.BasicAuthConfiguration
The password for HTTP basic authentication.
The username for HTTP basic authentication.
io.kestra.core.http.client.configurations.BearerAuthConfiguration
The token for bearer token authentication.
The password for HTTP basic authentication. Deprecated, use auth property with a BasicAuthConfiguration instance instead.
The username for HTTP basic authentication. Deprecated, use auth property with a BasicAuthConfiguration instance instead.
durationdurationThe time an idle connection can remain in the client's connection pool before being closed.
UTF-8The default charset for the request.
java.nio.charset.Charset
trueWhether redirects should be followed automatically.
ALLTRACEDEBUGINFOWARNERROROFFNOT_SPECIFIEDThe log level for the HTTP client.
REQUEST_HEADERSREQUEST_BODYRESPONSE_HEADERSRESPONSE_BODYThe enabled log.
The maximum content length of the response.
The proxy configuration.
io.kestra.core.http.client.configurations.ProxyConfiguration
DIRECTDIRECTHTTPSOCKSThe address of the proxy server.
The password for proxy authentication.
The port of the proxy server.
DIRECTHTTPSOCKSThe type of proxy to use.
The username for proxy authentication.
durationdurationThe maximum time allowed for reading data from the server before failing.
The SSL request options
io.kestra.core.http.client.configurations.SslOptions
Whether to disable checking of the remote SSL certificate.
Only applies if no trust store is configured. Note: This makes the SSL connection insecure and should only be used for testing. If you are using a self-signed certificate, set up a trust store instead.
The timeout configuration.
io.kestra.core.http.client.configurations.TimeoutConfiguration
durationThe time allowed to establish a connection to the server before failing.
PT5MdurationThe time allowed for a read connection to remain idle before closing it.
orderstring
Order by clause
Order by clause using PostgREST syntax (e.g., 'created_at.desc', 'name.asc')
schemastring
publicThe schema to use
The database schema to use for operations -- defaults to 'public'.
selectstring
Columns to select
Comma-separated list of columns to select. If not specified, all columns (*) will be selected.
Outputs
codeinteger
The HTTP status code of the response
headersobject
The headers of the response
rawResponsestring
The raw response body
rowsarray
The selected rows from the table
sizeinteger
The number of rows returned
uristring
uriThe URI of the executed request
