DROP PIPELINE
On this page
The DROP PIPELINE clause deletes a pipeline from your SingleStore cluster.
Syntax
DROP PIPELINE [IF EXISTS] pipeline_name;
Remarks
-
After a pipeline has been dropped, any data related to the pipeline will also be deleted from the
information_tables associated with the Pipelines feature.schema -
This command causes implicit commits.
Refer to COMMIT for more information. -
The background tasks of a pipeline runs in its resource pool.
Therefore, a resource pool used by a pipeline cannot be dropped. For more information on resource pools, see Set Resource Limits.
-
Refer to the Permission Matrix for the required permission.
Caution
If a pipeline is dropped and recreated, the pipeline will start reading from the earliest offset in the data source, once the pipeline is started.
Example
SHOW PIPELINES;
+-------------------------+---------+
| Pipelines_in_mydatabase | State |
+-------------------------+---------+
| quickstart_kafka | Running |
+-------------------------+---------+DROP PIPELINE quickstart_kafka;Query OK, 0 rows affected (0.00 sec)
SHOW PIPELINES;Empty set (0.00 sec)
Last modified: November 14, 2023