DETACH PIPELINE
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
The DETACH PIPELINE clause is similar to the STOP PIPELINE clause with the difference being ALTER TABLE can be performed on a detached pipeline for the table that is currently being referenced by the pipeline.
Syntax
DETACH PIPELINE [IF EXISTS] <pipeline_name>;
Remarks
-
Use the
START PIPELINEclause to reattach a detached pipeline. -
Use the
SHOW PIPELINESclause to see the pipeline's state. -
For more information on altering a table, see ALTER TABLE.
-
Refer to the Permission Matrix for the required permission.
Examples
DETACH PIPELINE IF EXISTS books;SHOW PIPELINES;
+-------------------------+----------+
| Pipelines_in_testdb | State |
+-------------------------+----------+
| books | Detached |
+-------------------------+----------+START PIPELINES;SHOW PIPELINES;
+-------------------------+---------+
| Pipelines_in_testdb | State |
+-------------------------+---------+
| books | Running |
+-------------------------+---------+Last modified: June 3, 2025