Sunday, March 27, 2022

How does secure data sharing work in snowflake ?

               Are you looking for the details about how data sharing works in snowflake? Are you also interested in knowing what are things we can share in snowflake? If so, then you reached the right place. In this article, we will explore data sharing in Snowflake. Let's start.

A] What are the database objects we can share?

              The following snowflake database objects can be shared -

              a) External tables 

              b) Tables 

              c) Secure views 

              d) Secure UDFs

              e) Secure materialized views

             The objects which are shared are in Read-only. i.e we cannot add, update or delete data or objects.

B] How does secure data sharing work? 

             Secure data sharing is a feature of snowflake using which data is shared with consuming systems.

            Following are important points about secure data sharing.

           1. No actual data is copied or transferred

           2. Sharing achieved using snowflake unique services layer and metadata store 

           3. No storage is needed on the consumer side

           4. No monthly charges to the consumer for storage 

           5. Consumers need to pay for  executing queries i.e for using compute resources 

       How does Data Sharing work in Snowflake? 

           a) Secure data share comes with the provider and consumer concepts.

           b) Provider creates a shared database and grants access to specific objects in the database 

           c) Provider has capabilities to share from multiple databases if these databases are from the same account 

          d) The read-only database is created on the consumer side from the share. Access to this database is configurable using standard role-based access control.

Learn more about snowflake here -

Cloudflare: An In-depth Look at Its Advantages and Disadvantages

 Cloudflare is a prominent American web infrastructure and website security company that offers a range of services to enhance website perfo...