DROP SOURCE

Use the DROP SOURCE command to remove a source if you no longer need the data inflow from the source.

Before you can remove a source, you must use DROP MATERIALIZED VIEW to remove all its dependent materialized views.

Syntax

DROP SOURCE [ IF EXISTS ] [schema_name.]source_name [ CASCADE ];

Parameters

Parameter	Description
schema_name	The schema of the source that you want to remove. You can use SHOW SCHEMAS to get a list of all available schemas. If you don’t specify a schema, the specified source in the default schema public will be removed.
source_name	The name of the source to remove.
CASCADE option	If this option is specified, all objects (such as materialized views) that depend on the source, and in turn all objects that depend on those objects will be dropped.

Examples

This statement removes the rw_source source in the default schema (public) from the database:

DROP SOURCE rw_source;

This statement removes the rw_source source in the rw_schema schema from the database:

DROP SOURCE IF EXISTS rw_schema.rw_source;

Hanging or long running DROP SOURCE

If your DROP SOURCE command takes a long time to run, it could be due to high barrier latency. DROP commands need to be synchronized with barriers currently. To let DROP take effect immediately, you can use the RECOVER command in a separate session.

See also

CREATE SOURCE

Create a source