Data Sharing in Snowflake: Implementing Secure Data Sharing

Snowflake 2022    |    Intermediate
  • 14 Videos | 1h 48m 21s
  • Includes Assessment
  • Earns a Badge
Likes 1 Likes 1
In the traditional approach to data sharing, consumers receive a copy of the provider data, which can allow for the creation of multiple copies of data. Secure Data Sharing in Snowflake enables the secure sharing of specific database objects without data duplication between accounts. In this course, explore the motivations behind Secure Data Sharing and its implementation, as well as how to create and share a Snowflake share. Next, learn how to use Snowflake Marketplace data, the specific permissions required to create and manage shares, and how to set permissions using queries. Finally, practice implementing cross-region data replication to enable Secure Data Sharing across cloud and geographical boundaries. Upon completion, you'll be able to securely share Snowflake objects with other Snowflake users.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    identify how secure data sharing works in Snowflake
    recognize the constraints and rules of secure data sharing
    create and set up Snowflake objects to be included in a secure share
    set up a secure share of Snowflake objects between two accounts
    access shared provider data in a consumer account
    create and use reader accounts to access shared Snowflake content
  • download and use data from Snowflake Marketplace
    view the specific permissions required for data consumers
    create secure shares and grant and revoke permissions using queries
    create a Snowflake account for data replication
    copy data into a replica using cross-region data replication
    use a replicated database and sync it with the original
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 53s
    UP NEXT
  • Playable
    2. 
    Data Sharing in Snowflake
    10m 26s
  • Locked
    3. 
    Secure Sharing Constraints
    5m 45s
  • Locked
    4. 
    Creating Objects for Secure Sharing
    10m 29s
  • Locked
    5. 
    Setting Up a Secure Share
    8m 21s
  • Locked
    6. 
    Accessing Shared Data as a Consumer
    10m 30s
  • Locked
    7. 
    Creating and Sharing Data with Reader Accounts
    11m 37s
  • Locked
    8. 
    Using Snowflake Marketplace
    5m 32s
  • Locked
    9. 
    Viewing Permission Grants on Shareable Objects
    7m 44s
  • Locked
    10. 
    Defining a Secure Share Using Queries
    10m 33s
  • Locked
    11. 
    Creating a Destination Account for Replication
    7m 50s
  • Locked
    12. 
    Setting Up Cross-region Data Replication
    10m 1s
  • Locked
    13. 
    Migrating Objects to a Replica
    5m 22s
  • Locked
    14. 
    Course Summary
    2m 18s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.