Skip to main content

ALTER PIPE

Description​

Alters the settings of the properties of a pipe. This command is supported from v3.2 onwards.

Syntax​

ALTER PIPE [db_name.]<pipe_name> 
SET PROPERTY
(
    "<key>" = <value>[, "<key>" = "<value>" ...]
)

Parameters​

db_name​

The name of the database to which the pipe belongs.

pipe_name​

The name of the pipe.

PROPERTIES​

The properties whose settings you want to alter for the pipe. Format: "key" = "value". For more information about the properties supported, see CREATE PIPE.

Examples​

Change the setting of the AUTO_INGEST property to FALSE for the pipe named user_behavior_replica in the database named mydatabase:

USE mydatabase;
ALTER PIPE user_behavior_replica
SET
(
    "AUTO_INGEST" = "FALSE"
);

References​