API
  • API Index
  • Batch API
  • Content Negotiation
  • Dynamic Paths
  • Hierarchy API
  • List API
  • Quick Reference
  • Time Series API
  • Views
    • Configuration
  • Overview
  • Application Configuration
  • Documentation Configuration
  • Spec Configuration
    • Features
  • API Testing
  • Asynchronous Processing
  • Cassandra Time-Series Engine
  • Cassandra Integration
  • Default Controller Customisation
  • Documentation
  • Geospatial Filtering
  • Model Documentation
  • PostgreSQL Integration
  • Excel Spreadsheet Format
    • Tutorials
  • Step-by-Step Guide
  • Archetype Setup
  • Logging
  • Prometheus
  • Sentry Logging
    • UI Customisation
  • UI Customisation
  • SASS Build Chain
  • Shared Layout
  • API Documentation
  • Model Documentation
  • Results
  • sapi-nt v current

    Cassandra Integration

    This document contains some information about integrating sapi-nt with a Cassandra database. See here for more notes on time series.

    Data Source

    You can configure a data source which accepts CQL queries and sends them to a Cassandra data store.

    Time series endpoints can use a Cassandra database as their data source.

    Cassandra data source specs have a type value of cassandraDataSource and can have the following properties:

    Property Meaning  Default
    contactPoints A list of address of the nodes to be contacted initially before node discovery  
    keyspace A keyspace in Cassandra is a namespace that defines data replication on nodes. A cluster contains one keyspace per node dev
    port A port on which to connect 9042
    authenticationMode Set the authentication mode. none
    connectTimeout Timeout for establishing connection to cassandra, in milliseconds 5000
    readTimeout Timeout for completing a read query, in milliseconds 5000

    Example

    name     : defaultDataSource
    type     : cassandraDataSource
    contactPoints:
      - localhost
    port     : 9142
    keyspace : dev