1. Data Sharing in Snowflake: Snowflake utilises data sharing to distribute the latest details to all Snowflake accounts: Dataset and Data on account usage The term "secure data sharing" refers to the fact that no relevant figures are copied or converted between accounts. Because all communication is done through Snowflake's distinctive services layer as well as metadata store, shared data doesn't really take up any data storage in a consumer account and thus does not make a contribution to the consumer's quarterly data storage charges. 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: 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,

2. 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.). 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. Contact us +91-9989971070. Register now for Snowflake Online Training Visit: https://www.visualpath.in/snowflake-online-training.html