Skip to main content
Version: Latest-3.3

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