Chapter 7: Secure Data Sharing

Traditional warehouse solutions share data by extracting the data out and sending it over transport mechanisms such as FTP and email. A downside to this is that as soon as the data is extracted, it is already out of date. Snowflake overcomes this by providing a unique data-sharing solution that ensures reduced costs, reduced operational overhead, and always provides up-to-date data.

This chapter details how to share data with other Snowflake customers as well as non-Snowflake customers.

The following recipes will be covered in this chapter:

• Sharing a table with another Snowflake account
• Sharing data through a view with another Snowflake account
• Sharing a complete database with another Snowflake account and setting up future objects to be shareable
• Creating reader accounts and configuring them for non-Snowflake sharing
• Sharing an object with a non-Snowflake user
• Keeping costs in check when sharing data with non-Snowflake...