Cloudflare RawQuery
CertifiedRun a raw SQL statement against a Cloudflare D1 database
Cloudflare RawQuery
Run a raw SQL statement against a Cloudflare D1 database
Executes a SQL statement using the /raw endpoint, which returns column names and row values as separate arrays instead of per-row objects. Useful for bulk export scenarios where column-oriented layout is preferred.
type: io.kestra.plugin.cloudflare.d1.RawQueryExamples
Run a raw query and get column/row arrays
id: d1_raw_query
namespace: company.team
tasks:
- id: raw
type: io.kestra.plugin.cloudflare.d1.RawQuery
apiToken: "{{ secret('CLOUDFLARE_API_TOKEN') }}"
accountId: "your_account_id"
databaseId: "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
sql: "SELECT id, name FROM users LIMIT 100"
Properties
accountId *string
Account ID
Cloudflare account identifier
apiToken *string
Cloudflare API token
Your Cloudflare API token. Create one in the Cloudflare dashboard with the permissions required by the resources you manage (e.g. DNS, Workers, D1, cache, WAF, zones).
databaseId *string
Database ID
UUID of the D1 database to query
sql *string
SQL statement
SQL statement to execute; use ? as positional placeholders
baseUrl string
https://api.cloudflare.com/client/v4Cloudflare API base URL
Base URL for Cloudflare API. Usually you don't need to change this.
options
HTTP client options
Optional advanced HTTP settings like timeouts or proxy.
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 authentication 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.
io.kestra.core.http.client.configurations.DigestAuthConfiguration
The password for HTTP Digest authentication.
The username for HTTP Digest authentication.
UTF-8The default charset for the request.
java.nio.charset.Charset
trueWhether to enable TCP Keep-Alive extended socket options (TCP_KEEPIDLE, TCP_KEEPINTERVAL, TCP_KEEPCOUNT).
Set to false when running on Windows workers, as these extended socket options are not supported by the Windows JDK and will cause connection failures.
trueWhether redirects should be followed automatically.
REQUEST_HEADERSREQUEST_BODYRESPONSE_HEADERSRESPONSE_BODYThe enabled log.
The proxy configuration.
io.kestra.core.http.client.configurations.ProxyConfiguration
The address of the proxy server.
The password for proxy authentication.
The port of the proxy server.
DIRECTDIRECTHTTPSOCKSThe type of proxy to use.
The username for proxy authentication.
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
The time allowed to establish a connection to the server before failing.
PT5MThe time allowed for a read connection to remain idle before closing it.
params array
Query parameters
Ordered list of positional parameter values for the ? placeholders in the SQL statement
Outputs
columns array
Column names
Ordered list of column names from the result set
meta
Query metadata
Execution metadata returned by D1
io.kestra.plugin.cloudflare.d1.Query-QueryMeta
rows array
Rows
Result rows as ordered arrays of values, aligned to the column list
size integer
0Row count
Number of rows returned
