Skip to main content

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 [schema_name.]source_name;

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.

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 rw_schema.rw_source;

Help us make this doc better!