1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

Corporate Training Job Support Become an Instructor USA Staffing and Recruitment

 Course Categories  Search course you want to learn

Community Webinars Tutorials Interview

Data Warehousing & ETL BECOME A CERTIFIED PROFESSIONAL
Questions Resumes

Home / Blogs / Data Warehousing & ETL / Snowflake Data sharing

Categories
Snowflake Data sharing
Last updated on Jul 17, 2024
AI & Machine Learning
Big Data Analytics by Gayathri

Business Intelligence &

Analytics
Snowflake Data sharing - Table of Content

Certification Courses
Cloud Computing Data Sharing in Snowflake
Cyber Security & SIEM
Data sharing with non-Snowflake users
Tools
Data Warehousing & ETL Snowflake data share
Database Management & Performing data sharing using the web UI
Administration
Data sharing using SQL Commands
DevOps
Conclusion
Digital Marketing
 Drop a Query  Request a Callback  sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 1/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

Enterprise Integration &

ERP
General Data Sharing in Snowflake:
Networking & Storage &
Virtualization Snowflake utilises data sharing to distribute the latest details to all
Operating System & Snowflake accounts:
Administration
others Dataset and
Programming & UI/UX Data on account usage
Project Management & The term "secure data sharing" refers to the fact that no relevant figures
Methodologies are copied or converted between accounts. Because all communication is
SAP done through Snowflake's distinctive services layer as well as metadata
Service Now store, shared data doesn't really take up any data storage in a consumer
Software Testing
account and thus does not make a contribution to the consumer's quarterly
data storage charges.

Become a Snowflake Certified professional by learning this

HKR Snowflake Training !

When designers generate the shares and give them a catchy name. First-
class Snowflake objects which contain all of the data necessitate the
sharing of a database.

Each share includes the following components:

 Drop a Query  Request a Callback  sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 2/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

The privileges that allow access to the database and the schema containing
the shared objects.
The permissions that allow access to specific objects (tables, secure views,
and secure UDFs).
The consumer accounts that have access to the database and its objects.
Shares are secure, configurable, and completely controlled by the provider
account (the account that is sharing the dataset)
New objects added to a share are immediately available to all consumers,
allowing them to access shared data in real time.Access to a share (or any
of its contents) can be revoked at any time.

Data sharing with non-Snowflake users:

Hardly data sharing among Snowflake accounts is endorsed. As a

database server, you might just want to share information with an end user
who still does not have a Snowflake account and/or has not yet been ready
to get to be a licenced Snowflake customer. Snowflake claims to support
suppliers in creating audience account balances in facilitating information
exchange with these consumers. Reader account holders (previously known
as "read-only accounts") offer a quick, simple, and cost-effective way to
share data without requiring the consumer to become a Snowflake
customer. Users with a reader account can query information which has
been communicated with them, but they cannot perform any DML tasks
that really are available to full account users (data loading, insert, update,
etc.).
 Drop a Query  Request a Callback  sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 3/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

Snowflake Training
 Master Your Craft  Lifetime LMS & Faculty Access
 24/7 online expert support  Real-world & Project
Based Learning

Explore Curriculum

Snowflake data share:

Snowflake data sharing actually does work because of its multi-cluster

shared information architecture, which allows any snowflake customer
(data consumer) who wishes to communicate information with someone to
grant other organisations live access to data via a secured network.
Instead of being physically transferred to the customer, the data is kept in
the provider's account and is accessible and visible to the consumer via
SQL.

, Data Warehousing & ETLs, snowflake-data-sharing-description-0,

Snowflake Data Cloud, Data Warehousing & ETLs, snowflake-data-sharing-
description-1

The data producer would only be charged for the snowflake computing
and storage resources that they use. The compute resources used to query
the data flows will be paid for by the data consumer. When an object is
shared with a data consumer, the object appears in the producer's account,
 Drop a Query  Request a Callback  sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 4/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

so the data consumers incur no storage costs for the shared data except if
those who copy the data in the table.
Get ahead in your career with our Snowflake Tutorial !

, Data Warehousing & ETLs, snowflake-data-sharing-description-0,

Snowflake Data Cloud, Data Warehousing & ETLs, snowflake-data-
sharing-description-1, , Data Warehousing & ETLs, snowflake-data-
sharing-description-2

Subscribe To Our YouTube Channel To Get New Updates..!

 Subscribe

Performing data sharing using the web UI:

Step1: Creating the share account

We must first create the person account with whom we will share the
account. In Snowflake, we can create user accounts or readers accounts as
needed:

For example, in this example, we will see how to create a Readers account.
 Drop a Query  Request a Callback  sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 5/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

, Data Warehousing & ETLs, snowflake-data-sharing-description-0,

Snowflake Data Cloud, Data Warehousing & ETLs, snowflake-data-sharing-
description-1, , Data Warehousing & ETLs, snowflake-data-sharing-
description-2, create a Readers account, Data Warehousing & ETLs,
snowflake-data-sharing-description-3

In the below form fill all the needed information as shown below.
, Data Warehousing & ETLs, snowflake-data-sharing-description-0,
Snowflake Data Cloud, Data Warehousing & ETLs, snowflake-data-sharing-
description-1, , Data Warehousing & ETLs, snowflake-data-sharing-
description-2, create a Readers account, Data Warehousing & ETLs,
snowflake-data-sharing-description-3, create account, Data Warehousing
& ETLs, snowflake-data-sharing-description-4
Now the reader account is created, next you need to create the snowflake
user account.

Step2: creating the share

If you have the ACCOUNT ADMIN role (or a role that has been granted the
CREATE SHARES privilege), you can perform most tasks related to creating
and managing shares by clicking the Shares button on the menu list in the
Snowflake web interface.

 Drop a Query  Request a Callback  sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 6/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

, Data Warehousing & ETLs, snowflake-data-sharing-description-0,

Snowflake Data Cloud, Data Warehousing & ETLs, snowflake-data-sharing-
description-1, , Data Warehousing & ETLs, snowflake-data-sharing-
description-2, create a Readers account, Data Warehousing & ETLs,
snowflake-data-sharing-description-3, create account, Data Warehousing
& ETLs, snowflake-data-sharing-description-4, Shares, Data Warehousing
& ETLs, snowflake-data-sharing-description-5
Next click on the create share option, a window will be opened , fill in all
the details.
, Data Warehousing & ETLs, snowflake-data-sharing-description-0,
Snowflake Data Cloud, Data Warehousing & ETLs, snowflake-data-sharing-
description-1, , Data Warehousing & ETLs, snowflake-data-sharing-
description-2, create a Readers account, Data Warehousing & ETLs,
snowflake-data-sharing-description-3, create account, Data Warehousing
& ETLs, snowflake-data-sharing-description-4, Shares, Data Warehousing
& ETLs, snowflake-data-sharing-description-5, Craete Share, Data
Warehousing & ETLs, snowflake-data-sharing-description-6
Once a share has already been invented in the UI, the consumer can be
added. br />A pop-up window appears, allowing you to select the accounts
with which you want to share the data.

 Drop a Query  Request a Callback  sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 7/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

, Data Warehousing & ETLs, snowflake-data-sharing-description-0,

Snowflake Data Cloud, Data Warehousing & ETLs, snowflake-data-sharing-
description-1, , Data Warehousing & ETLs, snowflake-data-sharing-
description-2, create a Readers account, Data Warehousing & ETLs,
snowflake-data-sharing-description-3, create account, Data Warehousing
& ETLs, snowflake-data-sharing-description-4, Shares, Data Warehousing
& ETLs, snowflake-data-sharing-description-5, Craete Share, Data
Warehousing & ETLs, snowflake-data-sharing-description-6, Add
Consumers, Data Warehousing & ETLs, snowflake-data-sharing-
description-7
A pop-up window appears, allowing you to select the accounts with which
you want to share the data.
, Data Warehousing & ETLs, snowflake-data-sharing-description-0,
Snowflake Data Cloud, Data Warehousing & ETLs, snowflake-data-sharing-
description-1, , Data Warehousing & ETLs, snowflake-data-sharing-
description-2, create a Readers account, Data Warehousing & ETLs,
snowflake-data-sharing-description-3, create account, Data Warehousing
& ETLs, snowflake-data-sharing-description-4, Shares, Data Warehousing
& ETLs, snowflake-data-sharing-description-5, Craete Share, Data
Warehousing & ETLs, snowflake-data-sharing-description-6, Add
Consumers, Data Warehousing & ETLs, snowflake-data-sharing-
description-7, create a Readers account, Data Warehousing & ETLs,
snowflake-data-sharing-description-8

Top 30 frequently asked snowflake interview questions & answers for

freshers & experienced professionals

 Drop a Query Data sharing

 Request a Callback using SQL Commands:
 sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 8/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

The same steps can be performed in worksheets using SQL commands.

Step 1: Make a Share.

You can follow these steps in worksheets once the accounts for the clients
with whom we need to share the data have been created.

To make a share, use CREATE SHARE. At this point, the share is merely a
container awaiting the addition of objects and accounts.

Step 2: Grant Privileges to Add Objects to the Share

GRANT privilege>... TO SHARE to grant the share the following object

privileges:

ON THE DATABASE YOU WISH TO SHARE, YOU MUST HAVE THE USAGE
PERMISSION.
You must have the USAGE privilege on each database schema that contains
the objects you want to share.
In each shared schema, use the SELECT privilege to share specific objects
(tables, secure views, and secure UDFs).
SHOW GRANTS can be used to view the share's object grants.
Step3:Add an Account or Accounts to the Share

ALTER SHARE can be used to add one or more accounts to the share.
 Drop a Query  Request a Callback  sales@hkrtrainings.com
SHOW GRANTS can be used to view the accounts that have been added to
https://hkrtrainings.com/snowflake-data-sharing 9/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

the share.

It is critical that the person sharing the DB has the DB owner rights, or else
the issue will be granted insufficient permission.

That's all! The share has become suitable for consumption by the
designated accounts.

Example:

The following illustration depicts the entire provider process as described

above.

It should be noted that the following assumptions are made in this

example:

There is a database called sales db, which has a schema called aggregates
eula and a table called aggregate 1.

Two accounts, xy12345 and yz23456, will have access to the database,
schema, and table.

USE ROLE account admin;

CREATE SHARE sales_s;

GRANT USAGE ON DATABASE sales_db TO SHARE sales_s;

 Drop a Query  Request a Callback  sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 10/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake
GRANT USAGE ON SCHEMA sales_db.aggregates_eula TO SHARE sales_s;

GRANT SELECT ON TABLE sales_db.aggregates_eula.aggregate_1 TO SHARE sa

les_s;

SHOW GRANTS TO SHARE sales_s;

ALTER SHARE sales_s ADD ACCOUNTS=xy12345, yz23456;

SHOW GRANTS OF SHARE sales_s;

Snowflake Training
Weekday / Weekend Batches

See Batch Details

Restrictions for the shared databases:

Consumers face some serious limitations when using shared databases:

Databases that are decided to share are read-only. Users with a consumer
account can view and query data but cannot insert, update, or create objects
in the database.
The actions listed below are not permitted:
Time travel for a shared database or indeed any schemas/tables within the
database.
 Drop a Query  I'm working
Request a Callback  on modifying the commentary for a shared database.
sales@hkrtrainings.com
https://hkrtrainings.com/snowflake-data-sharing 11/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

Shared databases as well as all database objects cannot be forwarded.

Conclusion:

In the above blog post we had discussed the snowflake data sharing and
steps to create the shared accounts in a detailed way. If you have any
doubts please drop them in the comments section to get them resolved.

Related Articles:

Snowflake Connector
Snowflake Documentation
Snowflake Architecture
Snowflake Clustering

Share    

About Author

Gayathri

As a senior Technical Content Writer for HKR Trainings, Gayathri
 Drop a Query  has a good
Request a Callback comprehension of the present technical innovations,
 sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 12/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

which incorporates perspectives like Business Intelligence and

Analytics. She conveys advanced technical ideas precisely and
vividly, as conceivable to the target group, guaranteeing that the
content is available to clients. She writes qualitative content in the
field of Data Warehousing & ETL, Big Data Analytics, and ERP
Tools. Connect me on LinkedIn.

Upcoming Snowflake Training Online classes

Batch 11th Jan Timings - 10:30 AM

Mon - Fri (18 Days) Weekend 
starts on 2025 IST

Batch 15th Jan Timings - 08:30

Mon & Tue (5 Days) Weekday 
starts on 2025 AM IST

Batch 19th Jan Timings - 10:30 AM

Mon - Fri (18 Days) Weekend 
starts on 2025 IST

View Details

Explore All Trainings

Recommended Trainings

 Drop a Query  Request a Callback  sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 13/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

HL7 Training Mulesoft Training Certification PySpark Training Certification Salesforce CPQ Training

Salesforce Vlocity Training SAP IBP Training SAP MM Training

Explore All Articles

Recommended Articles
Alteryx Tools Ansible Loop AWS Edge Locations Bayes Theorem in Machine Learning Cyber Security Technologies

PowerApps lookup

On Demand Popular Courses Trending Courses DMCA.com

Courses Protection Status
Altreyx Training Kronos Training
+91 9711699759 Okta Training Cyberark Training Salesforce Vlocity
+1 (818) 665 7216 Alteryx Training GoLang Training Training
HL7 Training ServiceNow Training Snowflake Training
    
Oracle CPQ Training Servicenow Training Tableau Training
Workday Training Workday Training

Professional Certification Courses

CISA Certification Training | CISM Certification Training | CISSP Certification Training | PMP Certification Training | CSM
Certification Training | Digital Marketing Certification Program | Lean Six Sigma Certification Course | ... View More
 Drop a Query  Request a Callback  sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 14/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

Job guarantee programs

Full Stack Java Developer | Data Science | Data Analytics Certification | ... View More

Master Program Courses

ServiceNow | DevOps Engineer | Data Analytics | Cloud and DevOps | ... View More

Browse By Domains
AI & Machine Learning Courses | Big Data Analytics Courses | Business Intelligence & Analytics | Certification Courses | Cloud
Computing Courses | Cyber Security & SIEM Tools courses | Data Warehousing and ETL courses | DevOps Certification Courses |
Digital Marketing Courses | Enterprise Integration & ERP Courses | Networking & Storage & Virtualization Courses | Operating
Systems & Administration Courses | Other Certification Courses | Programming & UI/UX Courses | Project Management &
Methodologies Certification Courses | SAP Certification Courses | Servicenow Courses | Software Testing Courses | ... View More

View Less

About Us | Contact Us | Blogs | Careers | Community | Webinars | Tutorials | Sample Resumes | Interview Questions |
Privacy Policy | Terms & Conditions | Refund Policy | Technical Support | Mock Interviews |

© 2023 HKR Trainings. All rights reserved.

Disclaimer
On Our Website all Courses, Technologies, logos, and certification titles we use are their respective owners' property,
Trademarks & their intellectual Property belong to respective owners. All the firm, service, or product names on our website
are solely for identification purposes. We do not own, endorse or have the copyright or officially partnered of any
 Drop a Query  Request a Callback  sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 15/16
1/7/25, 9:46 AM Snowflake Data Sharing | Guide on Data sharing in Snowflake

brand/logo/name in any manner. Few graphics on our website are freely available on public domains. we use all these just for
the purpose of training only.

 Drop a Query  Request a Callback  sales@hkrtrainings.com

https://hkrtrainings.com/snowflake-data-sharing 16/16