Bird
Raised Fist0
SnowflakeConceptBeginner · 3 min read

What Is a Reader Account in Snowflake and How It Works

A Reader Account in Snowflake is a special type of account created by a data provider to securely share data with consumers who do not have their own Snowflake account. It allows the consumer to access shared data without needing to set up or manage a full Snowflake account.
⚙️

How It Works

Imagine you have a library of books (your data) and you want to lend some books to a friend who doesn't have a library card (Snowflake account). Instead of making them get a card, you create a special guest pass just for them. This guest pass is like a Reader Account in Snowflake.

The data provider creates this Reader Account linked to their main Snowflake account. They share specific data with this account, and the consumer can log in and view the data securely. The provider controls what data is shared and manages the account, so the consumer doesn't need to worry about setup or billing.

This setup makes sharing easy and safe, like giving a guest a key to a specific room instead of the whole house.

💻

Example

This example shows how a Snowflake data provider creates a Reader Account and shares a database with it.

sql
CREATE READER ACCOUNT reader_account_name;

-- Grant usage on the shared database to the reader account
GRANT IMPORTED PRIVILEGES ON DATABASE shared_database TO READER ACCOUNT reader_account_name;

-- The consumer uses the reader account credentials to connect and query the shared data
SELECT * FROM shared_database.schema.table_name;
Output
Reader account 'reader_account_name' created. Privileges granted on 'shared_database'. Query returns data from shared table.
🎯

When to Use

Use a Reader Account when you want to share data with someone who does not have a Snowflake account and you want to control the entire experience. It is ideal for:

  • Sharing data with external partners or customers without requiring them to create or manage their own Snowflake accounts.
  • Maintaining full control over data access, security, and billing since the provider manages the reader account.
  • Quickly enabling data consumers to access shared data without setup delays.

This is useful in business scenarios like providing analytics data to clients, sharing datasets with vendors, or distributing reports securely.

✅

Key Points

  • A Reader Account is created and managed by the data provider.
  • Consumers access shared data without needing their own Snowflake account.
  • Provider controls data access, security, and billing.
  • Ideal for secure, easy data sharing with external users.
✅

Key Takeaways

A Reader Account lets data providers share data with users who don't have Snowflake accounts.
The provider manages the Reader Account, controlling access and billing.
It simplifies secure data sharing with external partners or customers.
Consumers can query shared data immediately without setup.
Reader Accounts are best when you want full control over shared data access.