0 0
Read Time:1 Minute, 49 Second

During this post we will discuss about Transferring Pipe Ownership. In our current Account majority of PIPES are owned by ACCOUNTADMIN role. As part of maintenance, this becomes a painful task for AccountAdmin role. As per discussion with Business, it was decided to transfer some responsibility from ADMIN to other Role. After the mutual agreement it was confirm that we would transfer the PIPE ownership from ACCOUNTADMIN role to new Role.

As per below screenshot, we see SALES PIPE is available in DEMO_DB database own by ACCOUNTADMIN Role

Show Pipe

Transferring the PIPE ownership requires the following steps to be perform.

  • SET PIPE_EXECUTION_PAUSED = TRUE : It is must Pipe to be in paused state while transferring ownership of the pipe to another role. Transferring the ownership without Pausing PIPE will generate the following error.
PIPE Ownership Error


Grant ownership
  • Verify the Owner of PIPE, it has been change to SUPER_ROLE.

PIPE Ownership change

  • Now Verify the status of PIPE, it is in RUNNING state.
PIPE Status
  • Try to upload the file into destination directory which invokes SQS notification and execute the PIPE.
  • Verify the data in CUST_SALES table which gets upload by SNOWPIPE.
Table output


You may face the below issue during the Snowpipe execution. The probable reason for failure is  STAGE and FILE FORMAT use in PIPE Copy definition are not grant to the SUPER_ROLE. So please ensure during the PIPE OWNERSHIP transfer, dependencies object (Table, Stage, File Format) to be grant to the new Role.

PIPE Error

Average Rating

5 Star
4 Star
3 Star
2 Star
1 Star

Leave a Reply

Your email address will not be published. Required fields are marked *