Snowflake Global Data Sharing (Part 2)

Marcin Kulakowski
4 min readJan 9, 2022

--

Which data sharing pattern fits my organization?

In part 1 we went over how we can setup a simple Data Sharing in Snowflake example with two Snowflake Accounts, but this is limited to only sharing the data with the accounts that are known to us. What about if we want to collaborate within our organization across business units and/or make it privately or publicly discoverable?

With traditional data sharing, business units may be emailing or moving data across environments to share with one another and there maybe little transparency into what data is actually available across organization.

Snowflake Data Exchange

You can use Snowflake Data Exchange to break down data silos, collaborate across your organization and make data discoverable privately with your business partners.

A data exchange is powered by secure data sharing, allows you to administer group sharing and data discovery across your business units and business partners.

This means that you can:

Administers who can access and publish the data within the Data Exchange.

Monitor data usage to see what resources are most valuable.

Make data discoverable across business units and in other cloud regions.

Guide how the data is being used via rich meta-data listings that include sample use cases and queries.

Reduce data integration costs with direct access to live, ready to query data.

Snowflake Data Marketplace

Snowflake Data Marketplace on the other hand enables customers to discover publicly third-party data and data services, as well as market their own data products across the Data Cloud. Snowflake customers can discover and access insightful third-party data and services from over hundreds of providers, across many industries.

Marketplace also enables all Snowflake customers with an opportunity to become data providers, list and publish their data products, services, easily market them across the Data Cloud and monetize.

The ecosystem of the Marketplace providers is always expanding rapidly. With data available from over 300 providers across 18 categories, organizations across industries are tapping into the Snowflake Data Marketplace for use cases ranging from personalized customer experience, to optimizing supply-chains, to improving investment decisions.

So having all these different options on hand, which Data Sharing pattern fits your organization?

Intra Company

Example: Sharing between business units or your partners. Each business unit/partner must be a separate account.

Pattern: Typically, direct data sharing. If the consortium of companies collaborating on multiple data sets that can be discoverable by others, use Data Exchange

Value: Break down internal data silos to improve operational efficiency.

Cross Company

Example: Sharing data to and from a small number of external vendors/partners.

Pattern: Typically, direct data sharing. If the consortium of companies collaborating on multiple data sets that can be discoverable by others, use Data Exchange

Value: Exchange data with other organizations to improve collaboration and open up monetization opportunities.

Super Provider

Example: Your company providing data to customers, but each customer sees own data.

Pattern: Direct data sharing for custom solutions, Data Exchange for listing data privately and making it discoverable, Data Marketplace for listing data publicly, making it discoverable.

Value: Monetize and share data at scale with your customers.

Super Consumer

Example: Your company receiving data from suppliers. Sharing data with several suppliers, but suppliers do not interact with each other.

Pattern: Direct data sharing

Value: Improve external data sourcing and reduce costs for data analysis

In part 3, we will take a closer look at the Super Provider use case solution and how to design a custom data sharing framework to automate the setup and on-boarding of new customers for your organization seamlessly.

--

--

Marcin Kulakowski

Don't solve a problem, offer a better solution and show the art of the possible. Currently @ Snowflake.