How-to Guides for ksqlDB for Confluent Platform

Common ksqlDB tasks include querying structured data, managing connectors, and testing SQL statements—covered in the following guides.

• 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.