AWS Redshift Sink
Provided by: "Apache Software Foundation"
Support Level for this Kamelet is: "Preview"
Send data to an AWS Redshift Database.
This Kamelet expects a JSON as body. The mapping between the JSON fields and parameters is done by key, so if you have the following query:
'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
The Kamelet needs to receive as input something like:
'{ "username":"oscerd", "city":"Rome"}'
Configuration Options
The following table summarizes the configuration options available for the aws-redshift-sink
Kamelet:
Property | Name | Description | Type | Default | Example |
---|---|---|---|---|---|
Database Name |
Required The Database Name we are pointing. |
string |
|||
Password |
Required The password to use for accessing a secured AWS Redshift Database. |
string |
|||
Query |
Required The Query to execute against the AWS Redshift Database. |
string |
INSERT INTO accounts (username,city) VALUES (:#username,:#city) |
||
Server Name |
Required Server Name for the data source. |
string |
localhost |
||
Username |
Required The username to use for accessing a secured AWS Redshift Database. |
string |
|||
Server Port |
Server Port for the data source. |
string |
5439 |
Dependencies
At runtime, the aws-redshift-sink
Kamelet relies upon the presence of the following dependencies:
-
camel:jackson
-
camel:kamelet
-
camel:sql
-
mvn:com.amazon.redshift:redshift-jdbc42:2.1.0.3
-
mvn:org.apache.commons:commons-dbcp2:2.9.0
Usage
This section describes how you can use the aws-redshift-sink
.
Knative sink
You can use the aws-redshift-sink
Kamelet as a Knative sink by binding it to a Knative object.
apiVersion: camel.apache.org/v1alpha1
kind: KameletBinding
metadata:
name: aws-redshift-sink-binding
spec:
source:
ref:
kind: Channel
apiVersion: messaging.knative.dev/v1
name: mychannel
sink:
ref:
kind: Kamelet
apiVersion: camel.apache.org/v1alpha1
name: aws-redshift-sink
properties:
databaseName: The Database Name
password: The Password
query: INSERT INTO accounts (username,city) VALUES (:#username,:#city)
serverName: localhost
username: The Username
Prerequisite
You have Camel K installed on the cluster.
Procedure for using the cluster CLI
-
Save the
aws-redshift-sink-binding.yaml
file to your local drive, and then edit it as needed for your configuration. -
Run the sink by using the following command:
kubectl apply -f aws-redshift-sink-binding.yaml
Procedure for using the Kamel CLI
Configure and run the sink by using the following command:
kamel bind aws-redshift-sink -p "sink.databaseName=The Database Name" -p "sink.password=The Password" -p "sink.query=INSERT INTO accounts (username,city) VALUES (:#username,:#city)" -p "sink.serverName=localhost" -p "sink.username=The Username" channel:mychannel
This command creates the KameletBinding in the current namespace on the cluster.
Kafka sink
You can use the aws-redshift-sink
Kamelet as a Kafka sink by binding it to a Kafka topic.
apiVersion: camel.apache.org/v1alpha1
kind: KameletBinding
metadata:
name: aws-redshift-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: aws-redshift-sink
properties:
databaseName: The Database Name
password: The Password
query: INSERT INTO accounts (username,city) VALUES (:#username,:#city)
serverName: localhost
username: The Username
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
-
Save the
aws-redshift-sink-binding.yaml
file to your local drive, and then edit it as needed for your configuration. -
Run the sink by using the following command:
kubectl apply -f aws-redshift-sink-binding.yaml
Procedure for using the Kamel CLI
Configure and run the sink by using the following command:
kamel bind aws-redshift-sink -p "sink.databaseName=The Database Name" -p "sink.password=The Password" -p "sink.query=INSERT INTO accounts (username,city) VALUES (:#username,:#city)" -p "sink.serverName=localhost" -p "sink.username=The Username" kafka.strimzi.io/v1beta1:KafkaTopic:my-topic
This command creates the KameletBinding in the current namespace on the cluster.