DETACH PIPELINE
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 books;SHOW PIPELINES;
+-------------------------+----------+
| Pipelines_in_testdb | State |
+-------------------------+----------+
| books | Detached |
+-------------------------+----------+START PIPELINES;SHOW PIPELINES;
+-------------------------+---------+
| Pipelines_in_testdb | State |
+-------------------------+---------+
| books | Running |
+-------------------------+---------+Last modified: January 9, 2023