DROP SOURCE removes a source from your Materialize instances.
Materialize maintains your instances’ sources by attaching the source to its internal Differential dataflow engine. If you no longer need the source, you can drop it, which will remove it from Differential.
However, if views depend on the source you must either drop the views explicitly or use the CASCADE option.
|IF EXISTS||Do not return an error if the named source does not exist.|
|source_name||The source you want to drop. You can find available source names through
|RESTRICT||Do not drop this source if any views depend on it. (Default)|
|CASCADE||Drop all views that depend on this source.|
Before you can drop a source, you must drop all views which use it.
DROP SOURCE my_source;