How to clone a database object along with the existing grants of the underlying table in Snowflake ?
I have a requirement where i need to clone tables for backup purposes. Once i create a clone i need to manually give grant to the cloned table. Is there a way or command to automatically create a clone along with the existing grants of the underline table ?
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds