Query
type: "io.kestra.plugin.couchbase.Query"
Query a Couchbase database with N1QL.
Examples
Send a N1QL query to a Couchbase Database
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: STORE
Properties
connectionString
- Type: string
- Dynamic: ✔️
- Required: ✔️
- Min length:
1
Connection string used to locate the Couchbase cluster.
fetchType
- Type: string
- Dynamic: ❌
- Required: ✔️
- Default:
STORE
- Possible Values:
STORE
FETCH
FETCH_ONE
NONE
The way you want to store the data
FETCH_ONE output the first row FETCH output all the row STORE store all row in a file NONE do nothing
password
- Type: string
- Dynamic: ✔️
- Required: ✔️
- Min length:
1
Plaintext authentication password
query
- Type: string
- Dynamic: ✔️
- Required: ✔️
- Min length:
1
N1QL query to execute.
username
- Type: string
- Dynamic: ✔️
- Required: ✔️
- Min length:
1
Plaintext authentication username
parameters
- Type:objectarray
- SubType: string
- Dynamic: ✔️
- Required: ❌
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
Outputs
row
- Type: object
Map containing the first row of fetched data
Only populated if using FETCH_ONE
.
rows
- Type: array
- SubType: object
List containing the fetched data
Only populated if using FETCH
.
size
- Type: integer
The amount of rows fetched
uri
- Type: string
The uri of the stored result
Only populated if using STORE