Query

Query a Couchbase database with N1QL.

yaml
type: "io.kestra.plugin.couchbase.Query"

Send a N1QL query to a Couchbase database.

yaml
id: "query"
type: "io.kestra.plugin.couchbase.Query"
connectionString: couchbase://localhost
username: couchbase_user
password: couchbase_passwd
query: SELECT * FROM `COUCHBASE_BUCKET`(.`COUCHBASE_SCOPE`.`COUCHBASE_COLLECTION`)
fetchType: FETCH

Dynamic YES

Min length 1

Connection string used to locate the Couchbase cluster.

Dynamic YES

Min length 1

Plaintext authentication password.

Dynamic YES

Min length 1

N1QL query to execute on Couchbase database.

Dynamic YES

Min length 1

Plaintext authentication username.

Dynamic YES

Default STORE

Possible Values

STOREFETCHFETCH_ONENONE

The way you want to fetch and/or store the data.

FETCH_ONE - output just the first row. FETCH - output all the rows. STORE - store all the rows in a file. NONE - do nothing.

SubType string

Dynamic YES

Query parameters, can be positional or named parameters.

See Couchbase documentation about Prepared Statements for query syntax. This should be supplied with a parameter map if using named parameters, or an array for positional ones.

Map containing the first row of fetched data.

Only populated if using FETCH_ONE.

SubType object

List containing the fetched data.

Only populated if using FETCH.

The number of rows to be fetched.

Only populated if fetchType is 'FETCH' or 'STORE'.

Format uri

The URI of the stored result in Kestra's internal storage.

Only populated if using STORE.

​Query

Query