DROP CATALOG#

Synopsis#

DROP CATALOG catalog_name

Description#

Drops an existing catalog. Dropping a catalog does not interrupt any running queries that use it, but makes it unavailable to any new queries.

Note

The DROP CATALOG SQL statement is available as a public preview in Starburst Enterprise. Contact Starburst Support with questions or feedback.

Warning

Some connectors are known not to release all resources when dropping a catalog that uses such connector. This includes all connectors that can read data from HDFS, S3, GCS, or Azure, which are Hive connector, Iceberg connector, Delta Lake connector, and Hudi connector.

Note

This command requires the catalog management type to be set to dynamic.

Examples#

Drop the catalog example:

DROP CATALOG example;

See also#