How-to Guides for ksqlDB for Confluent Platform

Follow compact lessons that help you work with common ksqlDB functionality.

• Query Structured Data: Process and query structured data types like structs, maps, and arrays.
• Convert a Changelog to a Table: Create a table representing the latest values in a stream.
• Manage Connectors: Source and sink data from external systems.
• Update a Running Persistent Query: Change a running persistent query with no downtime.
• Create a User-defined Function: Extend ksqlDB and invoke your custom code.
• Control the Case of Identifiers: Specify the exact capitalization of object names.
• Use a Custom Timestamp Column: Perform time-based operations using a timestamp in each record.
• Test SQL Statements: Build test suites to assert correct program behavior.
• Variable Substitution: Change the content of a query based on variables.
• Use Lambda Functions: Transform columns of structured data without user-defined functions.