Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

About Capella Columnar

  • Capella Columnar
  • concept
    +
    Capella Columnar is the Couchbase cloud database-as-a-service (DBaaS). Use it to bring data from multiple sources together and run complex analytical queries to get timely insights from data.

    Capella Columnar brings the power of NoSQL to the world of analytics. This service integrates seamlessly with the Couchbase Capella cloud platform, enabling the creation of real-time, adaptive applications.

    Traditionally, analyzing JSON data in NoSQL databases requires complex transformations (like flattening) to prepare it for analytics, causing delays and hindering real-time insights. Capella Columnar eliminates these ETL complexities by unifying operational and analytical data stores into a single platform. This enables Zero ETL, reducing costs, complexity, and improving time to insight.

    architecture

    Capella Columnar offers the following features:

    • A column-oriented, Log-Structured Merge (LSM) plus B-tree structured storage engine built to expand the analytic performance and capacity of Capella. Its data is stored in AWS S3, and separated from computation features.

    • An enhanced MPP-based computation engine, allowing for real-time calculations regardless of data size.

    • Zero ETL and real-time ingestion capabilities powered by Confluent Kafka and Amazon Manage Streaming for Apache Kafka (MSK), which provide the ability to connect, capture, and extract data from nearly any database or application. This process also transforms the extracted data into developer-friendly JSON structures while in transit.

    • File-based reads, imports and exports for data stored in AWS S3 including JSON, Parquet, Avro, CSV, and other text formats.

    • Conversational coding using Capella iQ, to allow developers to use the power of a large language model (LLM) for SQL++ development.

    • Native support for Tableau and PowerBI for analytic development and visualization.

    Capella Columnar SDKs

    Columnar SDKs for the Java, Node.js, and Python platforms are available here.

    Next Steps

    If you have not already created an account, create an account for Couchbase Capella and return to the Columnar documentation for next steps. You do not have to deploy a Couchbase operational database or App Services trial to use Capella Columnar.

    Get Started
    Analyze