Import
Certified
Import a SQL file into a Cloudflare D1 database
Import
Certified
Import a SQL file into a Cloudflare D1 database
yaml
type: io.kestra.plugin.cloudflare.d1.ImportExamples
yaml
id: import_d1_database
namespace: company.team
tasks:
- id: export
type: io.kestra.plugin.cloudflare.d1.Export
apiToken: "{{ secret('CLOUDFLARE_API_TOKEN') }}"
accountId: "your_account_id"
databaseId: "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
- id: import
type: io.kestra.plugin.cloudflare.d1.Import
apiToken: "{{ secret('CLOUDFLARE_API_TOKEN') }}"
accountId: "your_account_id"
databaseId: "yyyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyyyyy"
from: "{{ outputs.export.uri }}"
yaml
id: import_inline_sql
namespace: company.team
tasks:
- id: import
type: io.kestra.plugin.cloudflare.d1.Import
apiToken: "{{ secret('CLOUDFLARE_API_TOKEN') }}"
accountId: "your_account_id"
databaseId: "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
sql: |
CREATE TABLE IF NOT EXISTS events (id INTEGER PRIMARY KEY, name TEXT);
INSERT INTO events (name) VALUES ('deploy');
Properties
accountId *Requiredstring
apiToken *Requiredstring
databaseId *Requiredstring
baseUrl string
Default
https://api.cloudflare.com/client/v4from string
maxDuration string
Default
PT5Moptions Non-dynamic
Definitions
io.kestra.core.http.client.configurations.HttpConfiguration
allowFailedbooleanstring
Default
falseallowedResponseCodesarray
SubTypeinteger
auth
io.kestra.core.http.client.configurations.BasicAuthConfiguration
type*Requiredobject
passwordstring
usernamestring
io.kestra.core.http.client.configurations.BearerAuthConfiguration
type*Requiredobject
tokenstring
io.kestra.core.http.client.configurations.DigestAuthConfiguration
type*Requiredobject
passwordstring
usernamestring
basicAuthPasswordDeprecatedstring
basicAuthUserDeprecatedstring
connectTimeoutDeprecatedstring
Format
durationconnectionPoolIdleTimeoutDeprecatedstring
Format
durationdefaultCharsetstring
Default
UTF-8java.nio.charset.Charset
followRedirectsbooleanstring
Default
truelogLevelDeprecatedstring
Possible Values
ALLTRACEDEBUGINFOWARNERROROFFNOT_SPECIFIEDlogsarray
SubTypestring
Possible Values
REQUEST_HEADERSREQUEST_BODYRESPONSE_HEADERSRESPONSE_BODYmaxContentLengthDeprecatedinteger
proxy
io.kestra.core.http.client.configurations.ProxyConfiguration
addressstring
passwordstring
portintegerstring
typestring
Default
DIRECTPossible Values
DIRECTHTTPSOCKSusernamestring
proxyAddressDeprecatedstring
proxyPasswordDeprecatedstring
proxyPortDeprecatedinteger
proxyTypeDeprecatedstring
Possible Values
DIRECTHTTPSOCKSproxyUsernameDeprecatedstring
readIdleTimeoutDeprecatedstring
Format
durationreadTimeoutDeprecatedstring
Format
durationssl
io.kestra.core.http.client.configurations.SslOptions
insecureTrustAllCertificatesbooleanstring
timeout
io.kestra.core.http.client.configurations.TimeoutConfiguration
connectTimeoutstring
readIdleTimeoutstring
Default
PT5Msql string
Outputs
etag string
filename string
finalBookmark string
meta
Definitions
io.kestra.plugin.cloudflare.d1.Query-QueryMeta
changedboolean
changesinteger
durationnumber
last_row_idinteger
rows_readinteger
rows_writteninteger