Page 40 - Demo

The user is provided a readout confirmation of the share, sale_s.
4. Grant the distributor access to the share (it is assumed the distributor is also a modern cloud-built data warehouse user):
5. To see your share: show shares;
As the preceding example demonstrates, data providers can easily share data, while controlling data consumers’ access to data with a secure view. Sensitive data is protected, and data consumers gain access to non-sensitive data for their own analytics, without the need to copy or move data.
With unlimited data sharing and multi-tenancy capabilities, modern cloud data sharing extends the capabilities of a built- for-the-cloud data warehouse, enabling organizations to easily forge one-to-one, one-to-many, and many-to-many relation- ships to share data in new and imaginative ways.
alter share sales_s add
accounts=<distributor_name>;
34 Data Sharing For Dummies, Snowflake Special Edition
These materials are © 2018 John Wiley & Sons, Inc. Any dissemination, distribution, or unauthorized use is strictly prohibited.