SQL Statements
SQL statements are commands used to interact with Redpanda SQL. These statements let you query data, manage catalog connections, and export results.
Redpanda SQL operates in read-only mode. Data mutation operations (INSERT, UPDATE, DELETE) and bulk import (COPY FROM) are not available. Data is ingested into Redpanda topics and made queryable through catalog mappings.
|
The following table summarizes the statements supported by Redpanda SQL:
| Statement | Description |
|---|---|
Modifies connection properties of an existing Redpanda catalog. |
|
Modifies credentials or configuration of an existing storage connection. |
|
Modifies options of a catalog table mapped to a Redpanda topic. |
|
Creates a named connection to a Redpanda cluster. |
|
Creates a connection to external object storage. |
|
Maps a Redpanda topic to a SQL table through a catalog. |
|
Removes a catalog table mapping. Does not delete the underlying Redpanda topic. |
|
Removes a Redpanda catalog connection. |
|
Removes a named storage definition. |
|
Retrieves data from a table. |
|
Exports query results or table data to CSV files. |
|
Configures or displays session-level settings such as time zone and search path. |
|
Lists catalogs in the cluster. Variants list only Redpanda catalogs or only Iceberg catalogs. |
|
Displays currently running execution tasks across the cluster. |
|
Displays the current state of nodes in a distributed cluster. |
|
Displays currently running queries on the cluster. |
|
Lists tables mapped from Redpanda topics and Iceberg tables registered in the local catalog. |
|
Shows detailed information about columns in a table, tables within a database, or catalog contents. |
