Write Back to Couchbase
- concept
From Operational Insights, you can write the results of an analytical query to a Capella or Couchbase Server collection.
To provide access from Operational Insights to a Capella operational database, you use a remote link to supply credentials. See Stream Data from Remote Sources.
You can designate either an empty collection or a collection with pre-existing documents as the destination for the result of an analytical query. If the Couchbase collection already has documents in it, the operation overwrites any document with a matching document key with the new incoming documents.
Use Cases
Example uses of this feature include:
-
Transferring any Operational Insights collection in its entirety to Capella or Couchbase Server. Some examples of the data that an Operational Insights collection might contain include:
-
Operational data shadowed through a Kafka pipeline
-
Operational data shadowed from a Capella or Couchbase Server collection
-
Archives, logs, and other resources in multiple formats stored on Amazon S3
-
-
Moving the results of analytical queries completed in Operational Insights—including complex joins and functions—to operational databases for use by adaptive applications.
-
Using the ability of Operational Insights to parse data in other formats into JSON documents for downstream use in your Couchbase Server.
COPY TO Statements
You use a SQL++ for Operational Insights COPY TO statement to write Operational Insights results to a Capella or Couchbase Server collection. When you copy to Capella or Couchbase Server, you specify a remote link, the source and destination collections, and a document key. Optionally, you can specify a WITH clause.