API Index for ksqlDB for Confluent Platform

This API index lists every SQL statement, function, and operator in ksqlDB, organized by category, with links to detailed reference pages.

SQL quick reference

• SQL Quick Reference

Functions and operators

• Aggregate Functions

• Operators

• Scalar Functions

• Table Functions

• Type Coercion

Streams and tables

• CREATE STREAM AS SELECT

• CREATE STREAM

• CREATE TABLE AS SELECT

• CREATE TABLE

• DESCRIBE

• DROP STREAM

• DROP TABLE

• INSERT INTO

• INSERT VALUES

• PRINT

Queries

• SELECT (Pull Query)

• SELECT (Push Query)

• EXPLAIN

• PAUSE

• RESUME

• TERMINATE

Connectors

• CREATE CONNECTOR

• DESCRIBE CONNECTOR

• DROP CONNECTOR

• SHOW CONNECTORS

Custom types

• CREATE TYPE

• DROP TYPE

• SHOW TYPES

Metadata

• DESCRIBE FUNCTION

• SHOW FUNCTIONS

• SHOW PROPERTIES

• SHOW QUERIES

• SHOW STREAMS

• SHOW TABLES

• SHOW TOPICS

• SPOOL

Execution

• RUN SCRIPT

• ALTER SYSTEM

Assertions

• ASSERT SCHEMA

• ASSERT TOPIC