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