Connect or Disconnect a Remote Link
- Capella Columnar
- how-to
This topic describes how you start and stop data event streaming from a remote data source through a link.
You incur charges when you connect a remote link.
Connect a Remote Link
-
In the Capella UI, select the Columnar tab.
-
Click a cluster name. The workbench opens.
-
Use the explorer to locate the link you want to connect. Each link’s status displays next to its name.
-
Move your cursor over the name of the link and then choose
.
Capella Columnar begins setting up the required infrastructure for the connection. Automatic data ingestion from the connected data source to all linked collections begins as soon as set up is complete. If more than one collection uses the link, data ingestion begins for all of them. The link’s status changes to connected.
After you connect the link and your initial data ingest is complete, you can run ANALYZE COLLECTION
on each collection associated with the link.
The ANALYZE
statement samples data in the collection so that cost-based optimization (CBO) can be applied instead of rule-based optimization.
As data in the collections changes, you can run ANALYZE COLLECTION
periodically to refresh the samples.
See Cost-Based Optimizer for Capella Columnar Services.
You can also use an SQL++ for Capella columnar statement to connect a remote link. See CONNECT Statements.
Get Data Event Stream Status
To verify that a remote collection is receiving data through a connected link, you can compare the count of documents in the collection at different points in time.
-
In the workbench, use the Query Context lists to specify the database and scope for the collection.
-
Get the current count of documents in the Capella Columnar collection:
SELECT count(*) FROM airline;
-
Repeat the previous step to see the number of documents received into this collection increase.
Stop Data Event Streaming
You can stop a data event stream from continuously updating the collection or collections associated with a link, and then restart it at a later time.
-
In the Capella UI, select the Columnar tab.
-
Click a cluster name. The workbench opens.
-
Use the explorer to locate the link you want to disconnect. Each link’s status appears next to its name.
-
Move your cursor over the name of the link and then choose
.
You can also use an SQL++ for Capella columnar statement to disconnect a remote link. See DISCONNECT Statements.
After you disconnect a link, you can restart data event streaming by connecting again.