Skip to main content
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

ParameterDescription
schema_nameThe 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_nameThe name of the source to remove.
CASCADE optionIf 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