Reader accounts for non-Snowflake users - Mini Project: Build & Apply

Reader accounts for non-Snowflake users

📖 Scenario: You are a data engineer at a company that uses Snowflake for data warehousing. Your company wants to securely share data with a partner organization that does not have Snowflake accounts. To enable this, you will create a Reader account in Snowflake. This special account allows the partner to access shared data without needing their own Snowflake login.

🎯 Goal: Build a Snowflake Reader account setup that shares a database with a non-Snowflake user partner. You will create the Reader account, share a database, and grant the necessary privileges so the partner can query the shared data securely.

📋 What You'll Learn

Create a Reader account named partner_reader_account in Snowflake

Create a database named shared_data_db

Create a share named partner_share in the main account

Add the shared_data_db to the partner_share

Grant usage privileges on the database and schema to the share

Grant select privileges on all tables in the schema to the share

Associate the Reader account with the share

💡 Why This Matters

🌍 Real World

Companies often need to share data securely with partners who do not have Snowflake accounts. Reader accounts provide a simple, secure way to do this without requiring new user licenses.

💼 Career

Data engineers and cloud architects use Reader accounts to enable external data sharing, a common task in data collaboration and governance.

1

Create the Reader account

Write a Snowflake SQL command to create a Reader account named partner_reader_account with the comment 'Reader account for partner organization'.

Snowflake

-- Your code here to create the Reader account

Need a hint?

Use the CREATE READER ACCOUNT statement with the exact account name and comment.

2

Create the shared database

Write a Snowflake SQL command to create a database named shared_data_db.

Snowflake

CREATE READER ACCOUNT partner_reader_account COMMENT = 'Reader account for partner organization';
-- Your code here to create the database

Need a hint?

Use the CREATE DATABASE command.

3

Create a share and add the database

Write Snowflake SQL commands to create a share named partner_share in your main account and add the database shared_data_db to this share.

Snowflake

CREATE READER ACCOUNT partner_reader_account COMMENT = 'Reader account for partner organization';
CREATE DATABASE shared_data_db;
-- Your code here to create the share and add the database

Need a hint?

Use CREATE SHARE to make the share, then ALTER SHARE ... ADD DATABASE to add the database.

4

Grant privileges and associate Reader account with the share

Write Snowflake SQL commands to grant usage on the database shared_data_db and its schema public to the share partner_share. Also grant select on all tables in the public schema to the share. Finally, associate the Reader account partner_reader_account with the share partner_share.

Snowflake

CREATE READER ACCOUNT partner_reader_account COMMENT = 'Reader account for partner organization';
CREATE DATABASE shared_data_db;
CREATE SHARE partner_share;
ALTER SHARE partner_share ADD DATABASE shared_data_db;
-- Your code here to grant privileges and associate the Reader account

Need a hint?

Grant usage on database and schema, select on all tables, then link the Reader account to the share.