How To Access And Query Snowflake Data Shares

HOW TO GET STARTED WITH SNOWFLAKE

Go to Data Products -> Private Sharing -> Shared With You
Click on one of the shares. I will be using the “Sonarverse Stacks Trial Share” as an example.
Click “Get”

Denote the database name and which roles can access that share. E.g. if you grant the RESEARCH_ANALYST_ROLE permission to access this database, any user with the RESEARCH_ANALYST_ROLE can access the database.

Repeat steps 1-4 for the any other provisioned shares.
Open a worksheet and run the query “show databases;” to view the databases that are automatically created from these shares. From there you can create your own tables from the databases.

HOW TO PROVISION A NEW USER IN SNOWFLAKE

Customers should share the same Snowflake Account. That way they can share the same infrastructure and consolidated billing, if need be. You can do so by CREATE USER command or via the UI from:

Admin -> Users & Roles

HOW TO GRANT ACCESS/PRIVILEGES FOR SNOWFLAKE USERS

Here is a series of useful scripts to help you get started on Snowflake.

Creates a READER_ROLE to access Snowflake data
Creates a READ_WH to run compute on Snowflake
Grants permission on READ_WH to the new READER_ROLE
Grants IMPORTED PRIVILEGES on data shares to READER_ROLE
Grants READER_ROLE to Users

use role accountadmin;

-- Create Reader Role 
create role reader_role; 
grant role reader_role to role sysadmin;

-- Create Warehouse for Compute 
create warehouse read_wh 
with warehouse_size = 'X-SMALL' 
auto_suspend = 60 
auto_resume = true;

-- Grant Permission on Warehouse 
grant usage, operate, monitor, modify 
on warehouse read_wh to role reader_role;

-- Grant Data Share to Role 
grant imported privileges on database sonarverse_solana_trial_share to role reader_role; 
grant imported privileges on database sonarverse_solana_raw_trial_share to role reader_role; 
grant imported privileges on database sonarverse_xrp_trial_share to role reader_role; 
grant imported privileges on database sonarverse_xrp_raw_trial_share to role reader_role;

-- Grant Reader Role to User: change to your usernames 
grant role reader_role to user x; 
grant role reader_role to user y;

Once this is done, you can now switch to READER_ROLE and you’ll see the data shares to query. Be sure to set your Role, Warehouse, and Database/Schema context on a Worksheet to run your queries in Snowflake.