Snowflake Data Sharing, Properly decoupled compute and storage

DataGeeks
4 min readJan 4, 2023

A modern database includes several cutting-edge features and is fully capable of separating computing from database storage. Data sharing between many Snowflake accounts is one of them.

In this article, we’ll examine how simple it is to share data between Snowflake accounts.

What is Data Sharing?

Secure Data Sharing allows you to share certain database items with other Snowflake accounts.

No actual data is copied or moved across accounts using Secure Data Sharing. All sharing is made possible through the unique services layer and metadata store of Snowflake. This is a crucial idea because shared data doesn’t consume any space in a consumer’s account and doesn’t contribute to the consumer’s monthly data storage fees. Consumers are only charged for the compute resources (i.e., virtual warehouses) needed to query the shared data.

As no data is moved over the network, secure data sharing to too fast and easy to implement. you need to execute a few SQL commands in snowflake and afterward, a consumer can consume the data in their Snowflake account.

Which data objects can be shared through Data Sharing?

--

--

DataGeeks

A data couple, Having 15 years of combined experience in data and love to share the knowledge about Data