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;

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.

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;