kar Sir
kar Sir

Reputation: 45

How to move SNOWPIPE from one schema to another?

how can i move snowpipe from one schema to another ? Does it replace if i use the following command?

Create or replace pipe <target_schema>.<mypipe_name> as

I couldn't find an alter statement to rename pipe or change schema.

Upvotes: 0

Views: 328

Answers (1)

patrick_at_snowflake
patrick_at_snowflake

Reputation: 453

You do a clone, there are some considerations wrt to how you have defined the pipe source, fully qualified name versus just the pipe name.

https://docs.snowflake.com/en/user-guide/object-clone.html#cloning-and-pipes

Upvotes: 1

Related Questions