What Is a Reader Account in Snowflake and How It Works
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.
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;
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 Accountis 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.
