Stream Data from Couchbase Capella
- Capella Columnar
- how-to
To continuously update Capella Columnar with data hosted on a Couchbase Capella operational cluster, create a remote link and collection.
For an example, see Create Remote beer-sample Collections. |
Requirements for Couchbase Capella Links
The Capella operational cluster must be in the same organization as your Capella Columnar cluster. You must have RBAC access to the operational database to be able to create a link to it. See Eventing Role-Based Access Control (RBAC).
Your Columnar account must have either the Project Owner
or Project Manager
role to be able to create a link and its associated collection.
Create a Link to Couchbase Capella
To create a remote link to a Couchbase Capella operational cluster:
-
In the Capella UI, select the Columnar tab.
-
Click a cluster name. The workbench opens.
-
Use the explorer to explore the existing databases, scopes, and collections. You can add a database and scope to hold the collection for the streamed data if necessary: see Manage Capella Columnar Services Databases.
-
Select
. The Create Link for <cluster name> Cluster dialog opens. -
Select Couchbase Server/Capella then click Continue.
-
Under Link Type, select Couchbase Capella.
-
In the Couchbase Link Name field, enter a name for the link.
-
In the Source Database list, select the source Capella operational cluster.
-
Click Save & Continue. Capella Columnar creates the link.
You can now create a collection associated with that link.
Create a Collection for a Couchbase Data Service
To create a remote collection to receive data from a Couchbase Capella operational cluster:
-
In the Create Link for <cluster name> Cluster dialog, click Create Linked Collection. The Create Collection Linked to <link name> dialog opens.
If you closed the Create Link for <cluster name> Cluster dialog by clicking Complete Later, then under LINKS move your pointer over the name of the link and choose . -
In the Collection Name field, enter a name for your Capella Columnar collection.
-
In the Configure Data Details fields, select the names of the Bucket, Scope, and Collection you want to shadow.
-
Optionally, enter an expression in the WHERE clause field to filter the documents in the source collection. Do not include the
WHERE
keyword, and supply only a deterministic expression. For example,activity = "eat"
. -
Click Create Collection. Your collection appears in the explorer’s Data section underneath its database and scope.