OPERATE. In Snowflake, to pause or resume a pipe, the OPERATE privilege is required on the pipe object.
The OPERATE privilege allows users to perform operational tasks on specific objects such as pipes, tasks, and streams. Specifically, for a pipe, the OPERATE privilege enables the user to execute the ALTER PIPE
... SET PIPE_EXECUTION_PAUSED=TRUE or ALTER PIPE ... SET
PIPE_EXECUTION_PAUSED=FALSE commands, which are used to pause or resume the pipe, respectively.
Here's a step-by-step explanation and reference:
* Understanding Pipe Operations: Pipes in Snowflake are used for continuous data loading from staging areas into Snowflake tables. Managing pipes involves operations such as creating, monitoring, pausing, and resuming.
* Privileges for Pipe Operations: The OPERATE privilege is essential for pausing and resuming pipes.
This privilege is more specific than general object access privileges like SELECT or USAGE and is tailored for operational control.
* Granting the OPERATE Privilege: To grant the OPERATE privilege on a pipe, an administrator or a user with the necessary grants can execute the SQL command:
GRANT OPERATE ON PIPE <pipe_name> TO ROLE <role_name>;
* Pausing and Resuming Pipes: Once the OPERATE privilege is granted, the user or role can pause the pipe using:
ALTER PIPE <pipe_name> SET PIPE_EXECUTION_PAUSED=TRUE;
To resume the pipe, they use:
ALTER PIPE <pipe_name> SET PIPE_EXECUTION_PAUSED=FALSE;
Reference: For more information on pipe operations and privileges, you can refer to Snowflake's official documentation on pipes and security access control:
https://docs.snowflake.com/en/sql-reference/sql/grant-privilege.html and
https://docs.snowflake.com/en/user-guide/data-pipelines-intro.html#managing-pipes