Cloud

DROP REDPANDA CATALOG

The DROP REDPANDA CATALOG statement removes a Redpanda catalog connection. You must drop all tables within a catalog before dropping the catalog itself.

In Redpanda Cloud, the storage connection and Iceberg catalog used to query Iceberg-enabled topics are configured and managed automatically when you enable Redpanda SQL on a cluster that has an Iceberg REST catalog configured. You don’t run these statements yourself for that workflow. This page documents the statement’s syntax and options so you can understand what Redpanda Cloud configures. See Query Iceberg-enabled topics.

Syntax

DROP REDPANDA CATALOG [IF EXISTS] catalog_name;

  • catalog_name: Name of the catalog to remove.

  • IF EXISTS: Optional. Prevents an error if the catalog does not exist.

Examples

First, drop all tables in the catalog:

DROP TABLE production_redpanda=>user_events;
DROP TABLE production_redpanda=>transactions;

Then drop the catalog:

DROP REDPANDA CATALOG production_redpanda;