cassandra sink 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. Set the value to one of these options - ANY, ONE, TWO, THREE, QUORUM, ALL, LOCAL_QUORUM, EACH_QUORUM, SERIAL, LOCAL_SERIAL, or LOCAL_ONE.

string

ANY

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

Usage

This section describes how you can use the cassandra-sink.

Knative sink

You can use the cassandra-sink Kamelet as a Knative sink by binding it to a Knative object.

cassandra-sink-binding.yaml
apiVersion: camel.apache.org/v1alpha1
kind: KameletBinding
metadata:
  name: cassandra-sink-binding
spec:
  source:
    ref:
      kind: Channel
      apiVersion: messaging.knative.dev/v1
      name: mychannel
  sink:
    ref:
      kind: Kamelet
      apiVersion: camel.apache.org/v1alpha1
      name: cassandra-sink
    properties:
      connectionHost: localhost
      connectionPort: "9042"
      keyspace: customers
      query: The Query

Prerequisite

You have Camel K installed on the cluster.

Procedure for using the cluster CLI

  1. Save the cassandra-sink-binding.yaml file to your local drive, and then edit it as needed for your configuration.

  2. Run the sink by using the following command:

    kubectl apply -f cassandra-sink-binding.yaml

Procedure for using the Kamel CLI

Configure and run the sink by using the following command:

kamel bind cassandra-sink -p "sink.connectionHost=localhost" -p "sink.connectionPort=9042" -p "sink.keyspace=customers" -p "sink.query=The Query" channel:mychannel

This command creates the KameletBinding in the current namespace on the cluster.

Kafka sink

You can use the cassandra-sink Kamelet as a Kafka sink by binding it to a Kafka topic.

cassandra-sink-binding.yaml
apiVersion: camel.apache.org/v1alpha1
kind: KameletBinding
metadata:
  name: cassandra-sink-binding
spec:
  source:
    ref:
      kind: KafkaTopic
      apiVersion: kafka.strimzi.io/v1beta1
      name: my-topic
  sink:
    ref:
      kind: Kamelet
      apiVersion: camel.apache.org/v1alpha1
      name: cassandra-sink
    properties:
      connectionHost: localhost
      connectionPort: "9042"
      keyspace: customers
      query: The Query

Prerequisites

  • You’ve installed Strimzi.

  • You’ve created a topic named my-topic in the current namespace.

  • You have Camel K installed on the cluster.

Procedure for using the cluster CLI

  1. Save the cassandra-sink-binding.yaml file to your local drive, and then edit it as needed for your configuration.

  2. Run the sink by using the following command:

    kubectl apply -f cassandra-sink-binding.yaml

Procedure for using the Kamel CLI

Configure and run the sink by using the following command:

kamel bind cassandra-sink -p "sink.connectionHost=localhost" -p "sink.connectionPort=9042" -p "sink.keyspace=customers" -p "sink.query=The Query" kafka.strimzi.io/v1beta1:KafkaTopic:my-topic

This command creates the KameletBinding in the current namespace on the cluster.

Kamelet source file

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

Back to top