Reputation: 45
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
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