A guide to automating ksqlDB query deployments using bash scripts and REST endpoints, with examples for local and Confluent Cloud.
A guide on connecting to managed ksqlDB in Confluent Cloud using the REST API and CLI, covering API key creation and setup.
A technical guide on using ksqlDB to process and transform complex JSON data from ActiveMQ via Kafka Connect, including array splitting.
A technical guide on using Kafka tombstone messages with Kafka Connect and ksqlDB to handle logical deletions from a PostgreSQL source to Elasticsearch.
Tutorial on streaming geolocation data from Kafka to Elasticsearch, covering mapping and data formatting using ksqlDB.
Explains how to model variable fields in ksqlDB using MAP instead of STRUCT for nested data, with practical examples.
A curated collection of Apache Kafka and ksqlDB talks, including recordings, slides, and code examples for building streaming data pipelines.
A technical guide on setting up ksqlDB with embedded Kafka Connect to ingest CDC events from MS SQL Server using the Debezium connector via Docker Compose.
Explores methods to count messages in a Kafka topic, comparing kafkacat commands with wc to ksqlDB for more detailed, grouped aggregations.
Explains the difference between JSON and JSON Schema serialization in Kafka Connect, showing the extra bytes in the wire format using hexdump.
A technical tutorial demonstrating how to access and query nested JSON arrays in ksqlDB using array indexing and the EXPLODE function.
A tutorial on building a Telegram bot using Apache Kafka and ksqlDB to process, query, and respond to real-time data streams.
ksqlDB 0.7 adds support for primitive data types as message keys, simplifying data joins and reducing the need for pre-processing.
A technical guide to monitoring Sonos device health by streaming diagnostics data through Kafka, ksqlDB, InfluxDB, and visualizing with Grafana.
A technical exploration of ksqlDB window start times, including creating streams, inserting test data, and querying windowed aggregations.
A technical guide on using ksqlDB and MongoDB to analyze network syslog data from UniFi devices, including Kafka stream processing.
A technical guide on using ksqlDB and Kafka Connect to ingest and analyze Syslog data for detecting SSH attacks.
A workaround technique for exploding arrays in ksqlDB using manual indexing, simulating EXPLODE/UNNEST functionality.
A technical tutorial on using CASE statements in ksqlDB to pivot and aggregate event stream data, similar to SQL PIVOT operations.
Guide on configuring KSQL to connect to a secured Confluent Cloud Schema Registry, including Docker setup and error troubleshooting.
