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.

  • 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

Was this article helpful?