Cassandra Sink

Provided by: "Apache Software Foundation"

Support Level for this Kamelet is: "Stable"

Send data to an Apache Cassandra cluster.

This Kamelet expects JSON Array formatted data. The content of the JSON Array is used as input for the CQL Prepared Statement set in the query parameter.

Configuration Options

The following table summarizes the configuration options available for the cassandra-sink Kamelet:

Property	Name	Description	Type	Default	Example
connectionHost	Connection Host	Required The hostname(s) for the Cassandra server(s). Use a comma to separate multiple hostnames.	string		localhost
connectionPort	Connection Port	Required The port number(s) of the cassandra server(s). Use a comma to separate multiple port numbers.	string		9042
keyspace	Keyspace	Required The keyspace to use.	string		customers
query	Query	Required The query to execute against the Cassandra cluster table.	string
consistencyLevel	Consistency Level	The consistency level to use. Enum values: * ANY * ONE * TWO * THREE * QUORUM * ALL * LOCAL_QUORUM * EACH_QUORUM * LOCAL_ONE	string	ANY
extraTypeCodecs	Extra Type Codecs	To use a specific comma separated list of Extra Type codecs. Enum values: * BLOB_TO_ARRAY * BOOLEAN_LIST_TO_ARRAY * BYTE_LIST_TO_ARRAY * SHORT_LIST_TO_ARRAY * INT_LIST_TO_ARRAY * LONG_LIST_TO_ARRAY * FLOAT_LIST_TO_ARRAY * DOUBLE_LIST_TO_ARRAY * TIMESTAMP_UTC * TIMESTAMP_MILLIS_SYSTEM * TIMESTAMP_MILLIS_UTC * ZONED_TIMESTAMP_SYSTEM * ZONED_TIMESTAMP_UTC * ZONED_TIMESTAMP_PERSISTED * LOCAL_TIMESTAMP_SYSTEM * LOCAL_TIMESTAMP_UTC	string
jsonPayload	JSON Payload	If we want to transform the payload in json or not.	boolean	true
password	Password	The password for accessing a secured Cassandra cluster.	string
prepareStatements	Prepare Statements	If true, specifies to use PreparedStatements as the query. If false, specifies to use regular Statements as the query.	boolean	true
username	Username	The username for accessing a secured Cassandra cluster.	string

Property

Name

Description

Type

Default

Example

connectionHost

Connection Host

Required The hostname(s) for the Cassandra server(s). Use a comma to separate multiple hostnames.

string

localhost

connectionPort

Connection Port

Required The port number(s) of the cassandra server(s). Use a comma to separate multiple port numbers.

string

9042

keyspace

Keyspace

Required The keyspace to use.

string

customers

query

Query

Required The query to execute against the Cassandra cluster table.

string

consistencyLevel

Consistency Level

The consistency level to use.

Enum values:

* ANY * ONE * TWO * THREE * QUORUM * ALL * LOCAL_QUORUM * EACH_QUORUM * LOCAL_ONE

string

ANY

extraTypeCodecs

Extra Type Codecs

To use a specific comma separated list of Extra Type codecs.

Enum values:

* BLOB_TO_ARRAY * BOOLEAN_LIST_TO_ARRAY * BYTE_LIST_TO_ARRAY * SHORT_LIST_TO_ARRAY * INT_LIST_TO_ARRAY * LONG_LIST_TO_ARRAY * FLOAT_LIST_TO_ARRAY * DOUBLE_LIST_TO_ARRAY * TIMESTAMP_UTC * TIMESTAMP_MILLIS_SYSTEM * TIMESTAMP_MILLIS_UTC * ZONED_TIMESTAMP_SYSTEM * ZONED_TIMESTAMP_UTC * ZONED_TIMESTAMP_PERSISTED * LOCAL_TIMESTAMP_SYSTEM * LOCAL_TIMESTAMP_UTC

string

jsonPayload

JSON Payload

If we want to transform the payload in json or not.

boolean

true

password

Password

The password for accessing a secured Cassandra cluster.

string

prepareStatements

Prepare Statements

If true, specifies to use PreparedStatements as the query. If false, specifies to use regular Statements as the query.

boolean

true

username

Username

The username for accessing a secured Cassandra cluster.

string

Dependencies

At runtime, the cassandra-sink Kamelet relies upon the presence of the following dependencies:

camel:jackson
camel:kamelet
camel:cassandraql
camel:core

Camel JBang usage

Prerequisites

You’ve installed JBang.
You have executed the following command:

jbang app install camel@apache/camel

Supposing you have a file named route.yaml with this content:

- route:
    from:
      uri: "kamelet:timer-source"
      parameters:
        period: 10000
        message: 'test'
      steps:
        - to:
            uri: "kamelet:cassandra-sink"

You can now run it directly through the following command

camel run route.yaml

Kamelet source file

https://github.com/apache/camel-kamelets/blob/main/kamelets/cassandra-sink.kamelet.yaml