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...
