Syntax

DROP PIPELINE [IF EXISTS] pipeline_name;

Remarks

• After a pipeline has been dropped, any data related to the pipeline will also be deleted from the information_schema tables associated with the Pipelines feature.

• This command causes implicit commits. Refer to COMMIT for more information.

• The background tasks of a pipeline runs in its resource pool. Therefore, a resource pool used by a pipeline cannot be dropped.

  For more information on resource pools, see Set Resource Limits.

• Refer to the Permission Matrix for the required permissions.

Example

SHOW PIPELINES;

+-------------------------+---------+
| Pipelines_in_mydatabase | State   |
+-------------------------+---------+
| quickstart_kafka        | Running |
+-------------------------+---------+

DROP PIPELINE quickstart_kafka;
Query OK, 0 rows affected (0.00 sec)

SHOW PIPELINES;
Empty set (0.00 sec)