ScyllaDB University LIVE, FREE Virtual Training Event | March 21
Register for Free
ScyllaDB Documentation Logo Documentation
  • Server
  • Cloud
  • Tools
    • ScyllaDB Manager
    • ScyllaDB Monitoring Stack
    • ScyllaDB Operator
  • Drivers
    • CQL Drivers
    • DynamoDB Drivers
  • Resources
    • ScyllaDB University
    • Community Forum
    • Tutorials
Download
ScyllaDB Docs ScyllaDB Enterprise Getting Started Scylla Integrations and Connectors Integrate Scylla with Kafka Shard-Aware Kafka Connector for Scylla Kafka Sink Connector Configuration

Caution

You're viewing documentation for a previous version. Switch to the latest stable version.

Kafka Sink Connector Configuration¶

Topic: Kafka Sink Connector configuration properties

Learn: How to configure the Scylla Kafka Sink Connector

Audience: Scylla application developers

Synopsis¶

This document contains Kafka Sink Connector configuration properties and descriptions.

Usage¶

To use this connector, specify the name of the connector class in the connector.class configuration property.

connector.class=io.connect.scylladb.ScyllaDbSinkConnector

Connection¶

scylladb.contact.points¶

Specifies which Scylla hosts to connect to. Scylla nodes use this list of hosts to find each other and learn the topology of the ring. You must change this if you are running multiple nodes. It’s essential to put at least two hosts in case of bigger clusters for high availability purposes. If you are using a docker image, connect to the host it uses.

  • Type: List

  • Importance: High

  • Default Value: [localhost]

scylladb.port¶

Specifies the port that the Scylla hosts are listening on. For example, when using a docker image, connect to the port it uses (use docker ps).

  • Type: Int

  • Importance: Medium

  • Default Value: 9042

  • Valid Values: ValidPort{start=1, end=65535}

scylladb.loadbalancing.localdc¶

Specifies the local Data Center name (case-sensitive) that is local to the machine on which the connector is running.

  • Type: string

  • Default: “”

  • Importance: high

scylladb.security.enabled¶

Enables security while loading the sink connector and connecting to Scylla.

  • Type: Boolean

  • Importance: High

  • Default Value: False

scylladb.username¶

Specifies the username to use to connect to Scylla. Set scylladb.security.enable = true when using this parameter.

  • Type: String

  • Importance: High

  • Default Value: cassandra

scylladb.password¶

Specifies the password to use to connect to Scylla. Set scylladb.security.enable = true when using this parameter.

  • Type: Password

  • Importance: High

  • Default Value: cassandra

scylladb.compression¶

Specifies the compression algorithm to use when connecting to Scylla.

  • Type: string

  • Default: NONE

  • Valid Values: [NONE, SNAPPY, LZ4]

  • Importance: low

scylladb.ssl.enabled¶

Specifies if SSL should be enabled when connecting to Scylla.

  • Type: boolean

  • Default: false

  • Importance: high

SSL¶

scylladb.ssl.truststore.path¶

Specifies the path to the Java Truststore.

  • Type: string

  • Default: “”

  • Importance: medium

scylladb.ssl.truststore.password¶

Specifies the password to use to access the Java Truststore.

  • Type: password

  • Default: [hidden]

  • Importance: medium

scylladb.ssl.provider¶

Specifies the SSL Provider to use when connecting to Scylla.

  • Type: string

  • Default: JDK

  • Valid Values: [JDK, OPENSSL, OPENSSL_REFCNT]

  • Importance: low

Keyspace¶

scylladb.keyspace¶

Specifies the keyspace to write to. This keyspace is like a database in the Scylla cluster.

  • Type: String

  • Importance: High

scylladb.keyspace.create.enabled¶

Determines if the keyspace should be created if it does not exist.

Note

An error will result if a new keyspace (which already exists) has to be created, and this parameter is set to false.

  • Type: Boolean

  • Importance: High

  • Default Value: true

scylladb.keyspace.replication.factor¶

Specifies the replication factor to use if a keyspace is created by the connector. The Replication Factor (RF) is equivalent to the number of nodes where data (rows and partitions) are replicated. Data is replicated to multiple (RF=N) nodes

  • Type: int

  • Default: 3

  • Valid Values: [1,…]

  • Importance: high

Table¶

scylladb.table.manage.enabled¶

Determines if the connector should manage the table.

  • Type: Boolean

  • Importance: High

  • Default Value: true

scylladb.table.create.compression.algorithm¶

Specifies the compression algorithm to use when the table is created.

  • Type: string

  • Default: NONE

  • Valid Values: [NONE, SNAPPY, LZ4, DEFLATE]

  • Importance: medium

scylladb.offset.storage.table¶

The table within the Scylla keyspace to store the offsets that have been read from Apache Kafka. This is used once to enable delivery to Scylla.

  • Type: String

  • Importance: Low

  • Default: kafka_connect_offsets

Write¶

scylladb.consistency.level¶

The requested consistency level to use when writing to Scylla. The Consistency Level (CL) determines how many replicas in a cluster that must acknowledge read or write operations before it is considered successful.

  • Type: String

  • Importance: High

  • Default Value: LOCAL_QUORUM

  • Valid Values: ANY, ONE, TWO, THREE, QUORUM, ALL, LOCAL_QUORUM, EACH_QUORUM, SERIAL, LOCAL_SERIAL, LOCAL_ONE

scylladb.deletes.enabled¶

Determines if the connector should process deletes. The Kafka records with a Kafka record value as null will result in the deletion of the Scylla record with the primary key present in the Kafka record key.

  • Type: boolean

  • Default: true

  • Importance: high

scylladb.execute.timeout.ms¶

The timeout for executing a Scylla statement.

  • Type: Long

  • Importance: Low

  • Default Value: 30000

scylladb.ttl¶

The retention period for the data in Scylla. After this interval elapses, Scylla will remove these records. If this configuration is not provided, the Sink Connector will perform insert operations in Scylla without the TTL setting.

  • Type: Int

  • Importance: Medium

  • Default Value: null

scylladb.offset.storage.table.enable¶

If true, Kafka consumer offsets will be stored in the Scylla table. If false, the connector will skip writing offset information into Scylla (this might imply duplicate writes into Scylla when a task restarts).

  • Type: Boolean

  • Importance: Medium

  • Default Value: True

scylladb.max.batch.size.kb¶

Maximum size(in kilobytes) of a single batch consisting of Scylla operations. Should be equal to batch_size_warn_threshold_in_kb and 1/10th of the batch_size_fail_threshold_in_kb configured in scylla.yaml. The default value is set to 5kb, any change in this configuration should be accompanied by a change in scylla.yaml.

  • Type: int

  • Default: 5

  • Valid Values: [1,…]

  • Importance: high

Confluent Platform configurations¶

tasks.max¶

Specifies the maximum number of tasks to use for the connector that helps in parallelism.

  • Type:int

  • Importance: high

topics¶

Specifies the name of the topics to consume data from and write to Scylla.

  • Type: list

  • Importance: high

confluent.topic.bootstrap.servers¶

A list of host/port pairs to use for establishing the initial connection to the Kafka cluster used for licensing. All servers in the cluster will be discovered from the initial connection. This list should be in the form host1:port1,host2:port2,…. Since these servers are just used for the initial connection to discover the full cluster membership (which may change dynamically), this list need not contain the full set of servers (you may want more than one, though, in case a server is down).

  • Type: list

  • Importance: high

Additional References¶

  • Kafka Sink Connector Quickstart

Was this page helpful?

PREVIOUS
Kafka Sink Connector Quickstart
NEXT
Scylla CDC Source Connector
  • Create an issue

On this page

  • Kafka Sink Connector Configuration
    • Synopsis
    • Usage
    • Connection
      • scylladb.contact.points
      • scylladb.port
      • scylladb.loadbalancing.localdc
      • scylladb.security.enabled
      • scylladb.username
      • scylladb.password
      • scylladb.compression
      • scylladb.ssl.enabled
    • SSL
      • scylladb.ssl.truststore.path
      • scylladb.ssl.truststore.password
      • scylladb.ssl.provider
    • Keyspace
      • scylladb.keyspace
      • scylladb.keyspace.create.enabled
      • scylladb.keyspace.replication.factor
    • Table
      • scylladb.table.manage.enabled
      • scylladb.table.create.compression.algorithm
      • scylladb.offset.storage.table
    • Write
      • scylladb.consistency.level
      • scylladb.deletes.enabled
      • scylladb.execute.timeout.ms
      • scylladb.ttl
      • scylladb.offset.storage.table.enable
      • scylladb.max.batch.size.kb
    • Confluent Platform configurations
      • tasks.max
      • topics
      • confluent.topic.bootstrap.servers
    • Additional References
ScyllaDB Enterprise
  • 2024.1
    • 2024.2
    • 2024.1
    • 2023.1
    • 2022.2
  • Getting Started
    • Install ScyllaDB Enterprise
      • ScyllaDB Web Installer for Linux
      • Install ScyllaDB Without root Privileges
      • Air-gapped Server Installation
      • ScyllaDB Housekeeping and how to disable it
      • ScyllaDB Developer Mode
      • Launch ScyllaDB on AWS
      • Launch ScyllaDB on GCP
      • Launch ScyllaDB on Azure
    • Configure ScyllaDB
    • ScyllaDB Configuration Reference
    • ScyllaDB Requirements
      • System Requirements
      • OS Support by Linux Distributions and Version
      • Cloud Instance Recommendations
      • ScyllaDB in a Shared Environment
    • Migrate to ScyllaDB
      • Migration Process from Cassandra to Scylla
      • Scylla and Apache Cassandra Compatibility
      • Migration Tools Overview
    • Integration Solutions
      • Integrate Scylla with Spark
      • Integrate Scylla with KairosDB
      • Integrate ScyllaDB with Presto
      • Integrate Scylla with Elasticsearch
      • Integrate Scylla with Kubernetes
      • Integrate Scylla with the JanusGraph Graph Data System
      • Integrate Scylla with DataDog
      • Integrate Scylla with Kafka
      • Integrate Scylla with IOTA Chronicle
      • Integrate Scylla with Spring
      • Shard-Aware Kafka Connector for Scylla
      • Install Scylla with Ansible
      • Integrate Scylla with Databricks
      • Integrate Scylla with Jaeger Server
      • Integrate Scylla with MindsDB
    • Tutorials
  • ScyllaDB for Administrators
    • Administration Guide
    • Procedures
      • Cluster Management
      • Backup & Restore
      • Change Configuration
      • Maintenance
      • Best Practices
      • Benchmarking Scylla
      • Migrate from Cassandra to Scylla
      • Disable Housekeeping
    • Security
      • ScyllaDB Security Checklist
      • Enable Authentication
      • Enable and Disable Authentication Without Downtime
      • Creating a Custom Superuser
      • Generate a cqlshrc File
      • Reset Authenticator Password
      • Enable Authorization
      • Grant Authorization CQL Reference
      • Certificate-based Authentication
      • Role Based Access Control (RBAC)
      • ScyllaDB Auditing Guide
      • Encryption: Data in Transit Client to Node
      • Encryption: Data in Transit Node to Node
      • Generating a self-signed Certificate Chain Using openssl
      • Encryption at Rest
      • LDAP Authentication
      • LDAP Authorization (Role Management)
    • Admin Tools
      • Nodetool Reference
      • CQLSh
      • REST
      • Tracing
      • Scylla SStable
      • Scylla Types
      • SSTableLoader
      • cassandra-stress
      • SSTabledump
      • SSTable2json
      • SSTableMetadata
      • Scylla Logs
      • Seastar Perftune
      • Virtual Tables
      • SELECT * FROM MUTATION_FRAGMENTS() Statement
    • ScyllaDB Monitoring Stack
    • ScyllaDB Operator
    • ScyllaDB Manager
    • Upgrade Procedures
      • ScyllaDB Versioning
      • ScyllaDB Enterprise
      • ScyllaDB Open Source to ScyllaDB Enterprise
      • ScyllaDB Image
    • System Configuration
      • System Configuration Guide
      • scylla.yaml
      • ScyllaDB Snitches
    • Benchmarking ScyllaDB
    • ScyllaDB Diagnostic Tools
  • ScyllaDB for Developers
    • Learn To Use ScyllaDB
      • ScyllaDB University
      • Course catalog
      • ScyllaDB Essentials
      • Basic Data Modeling
      • Advanced Data Modeling
      • MMS - Learn by Example
      • Care-Pet an IoT Use Case and Example
    • Scylla Alternator
    • Scylla Features
      • Scylla Open Source Features
      • Scylla Enterprise Features
    • Scylla Drivers
      • Scylla CQL Drivers
      • Scylla DynamoDB Drivers
    • Workload Attributes
  • CQL Reference
    • CQLSh: the CQL shell
    • Appendices
    • Compaction
    • Consistency Levels
    • Consistency Level Calculator
    • Data Definition
    • Data Manipulation
      • SELECT
      • INSERT
      • UPDATE
      • DELETE
      • BATCH
    • Data Types
    • Definitions
    • Global Secondary Indexes
    • Expiring Data with Time to Live (TTL)
    • Functions
    • Wasm support for user-defined functions
    • JSON Support
    • Materialized Views
    • Non-Reserved CQL Keywords
    • Reserved CQL Keywords
    • ScyllaDB CQL Extensions
  • ScyllaDB Architecture
    • ScyllaDB Ring Architecture
    • ScyllaDB Fault Tolerance
    • Consistency Level Console Demo
    • ScyllaDB Anti-Entropy
      • Scylla Hinted Handoff
      • Scylla Read Repair
      • Scylla Repair
    • SSTable
      • ScyllaDB SSTable - 2.x
      • ScyllaDB SSTable - 3.x
    • Compaction Strategies
    • Raft Consensus Algorithm in ScyllaDB
  • Troubleshooting ScyllaDB
    • Errors and Support
      • Report a Scylla problem
      • Error Messages
      • Change Log Level
    • ScyllaDB Startup
      • Ownership Problems
      • Scylla will not Start
      • Scylla Python Script broken
    • Upgrade
      • Inaccessible configuration files after ScyllaDB upgrade
    • Cluster and Node
      • Failed Decommission Problem
      • Cluster Timeouts
      • Node Joined With No Data
      • SocketTimeoutException
      • NullPointerException
      • Failed Schema Sync
    • Data Modeling
      • Scylla Large Partitions Table
      • Scylla Large Rows and Cells Table
      • Large Partitions Hunting
    • Data Storage and SSTables
      • Space Utilization Increasing
      • Disk Space is not Reclaimed
      • SSTable Corruption Problem
      • Pointless Compactions
      • Limiting Compaction
    • CQL
      • Time Range Query Fails
      • COPY FROM Fails
      • CQL Connection Table
    • ScyllaDB Monitor and Manager
      • Manager and Monitoring integration
      • Manager lists healthy nodes as down
  • Knowledge Base
    • Upgrading from experimental CDC
    • Compaction
    • Consistency in ScyllaDB
    • Counting all rows in a table is slow
    • CQL Query Does Not Display Entire Result Set
    • When CQLSh query returns partial results with followed by “More”
    • Run Scylla and supporting services as a custom user:group
    • Customizing CPUSET
    • Decoding Stack Traces
    • Snapshots and Disk Utilization
    • DPDK mode
    • Debug your database with Flame Graphs
    • Efficient Tombstone Garbage Collection in ICS
    • How to Change gc_grace_seconds for a Table
    • Gossip in Scylla
    • Increase Permission Cache to Avoid Non-paged Queries
    • How does Scylla LWT Differ from Apache Cassandra ?
    • Map CPUs to Scylla Shards
    • Scylla Memory Usage
    • NTP Configuration for Scylla
    • Updating the Mode in perftune.yaml After a ScyllaDB Upgrade
    • POSIX networking for Scylla
    • Scylla consistency quiz for administrators
    • Recreate RAID devices
    • How to Safely Increase the Replication Factor
    • Scylla and Spark integration
    • Increase Scylla resource limits over systemd
    • Scylla Seed Nodes
    • How to Set up a Swap Space
    • Scylla Snapshots
    • Scylla payload sent duplicated static columns
    • Stopping a local repair
    • System Limits
    • How to flush old tombstones from a table
    • Time to Live (TTL) and Compaction
    • Scylla Nodes are Unresponsive
    • Update a Primary Key
    • Using the perf utility with Scylla
    • Configure Scylla Networking with Multiple NIC/IP Combinations
  • Reference
    • AWS Images
    • Configuration Parameters
    • Glossary
    • ScyllaDB Enterprise vs. Open Source Matrix
  • ScyllaDB University
  • ScyllaDB FAQ
  • Contribute to ScyllaDB
  • Alternator: DynamoDB API in Scylla
    • Getting Started With ScyllaDB Alternator
    • ScyllaDB Alternator for DynamoDB users
    • Alternator-specific APIs
Docs Tutorials University Contact Us About Us
© 2025, ScyllaDB. All rights reserved. | Terms of Service | Privacy Policy | ScyllaDB, and ScyllaDB Cloud, are registered trademarks of ScyllaDB, Inc.
Last updated on 09 Apr 2025.
Powered by Sphinx 7.4.7 & ScyllaDB Theme 1.8.6