Skip to main content

DETACH PIPELINE

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 PIPELINE clause to reattach a detached pipeline.

  • Use the SHOW PIPELINES clause to see the pipeline's state.

  • For more information on altering a table, see ALTER TABLE.

  • See 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 |
+-------------------------+---------+