Snowflake Share
Consume data on Dewey using Snowflake Share
Privileges Needed
- ACCOUNTADMIN Role: Required to create databases from shares.
- IMPORTED PRIVILEGES: Grant this privilege on shared databases to roles in your account.
Steps to Consume Shared Data
- View Available Shares: Use Snowsight or SQL (
SHOW SHARES
) to list available shares.

- Create Database from Share:
- Snowsight: Go to Data Products » Private Sharing, and select a share to create a database.
- SQL: Execute
CREATE DATABASE <name> FROM SHARE <provider_account>.<share_name>
. - Grant Access: Assign IMPORTED PRIVILEGES to appropriate roles.
Usage
- Querying: Same as querying any other database.
- Limitations: Shared databases are read-only and cannot be cloned or re-shared.
For more detailed information, refer to the Snowflake Documentation.
Updated 5 days ago