How can I share data with users in my own Snowflake account?
There are two ways to share data with users in your own Snowflake account:
Create a direct share: A direct share is a way to share specific database objects with another user in your account. To create a direct share, you need to specify the user that you want to share the data with, the database objects that you want to share, and the permissions that you want to grant the user.
Create a secure view: A secure view is a way to share data with another user without giving them direct access to the underlying data. To create a secure view, you need to specify the data that you want to share, the filters that you want to apply to the data, and the permissions that you want to grant the user.
Here are the steps on how to create a direct share:
1. Sign in to Snowsight.
2. In the navigation menu, select Data » Private Sharing.
3. Select Share » Create a Direct Share.
4. In the Share Data dialog, specify the following information:
User: The user that you want to share the data with.
Database objects: The database objects that you want to share.
Permissions: The permissions that you want to grant the user.
5. Click Share.
Here are the steps on how to create a secure view:
1. Sign in to Snowsight.
2. In the navigation menu, select Data » Private Sharing.
3. Select Share » Create a Secure View.
4. In the Share Data dialog, specify the following information:
Data: The data that you want to share.
Filters: The filters that you want to apply to the data.
Permissions: The permissions that you want to grant the user.
5. Click Share.
Once you have created a direct share or a secure view, the user that you shared the data with will be able to access the data in the specified database objects. The user's permissions will determine what they can do with the data.
Here are some additional things to keep in mind when sharing data with users in your own Snowflake account:
- You can only share data with users who have been granted the ACCOUNTADMIN role or the CREATE ACCOUNT global privilege.
- You can share data with users in other accounts by creating a data exchange.
- You can revoke access to shared data at any time.
By following these steps, you can easily share data with users in your own Snowflake account.