What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?
What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?
To share a newly created object in a Snowflake database with consumers, the correct action to take is to use the GRANT privilege ... TO SHARE command. This command is specifically designed to grant the necessary privileges to the shared object, allowing consumers to access it. This approach ensures that the object is explicitly added to the share, making it available to the intended users.
To make a new object available to consumers, you must use the GRANT <privilege> … TO SHARE command to explicitly add the object to the share.
https://docs.snowflake.com/en/user-guide/data-sharing-gs