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.
|
SQL Studio in Cloud Console adds its own limit on which statements you can run in the editor. See SQL Studio.
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. |
