How to Share Data Products from Snowflake to Snowflake

Data sharing between Snowflake accounts has become one of the most common use cases for organizations of all sizes. Whether it's collaboration between internal teams, partnerships with clients, or monetizing data assets, Snowflake’s zero‑copy data sharing capabilities allow you to expose curated tables and views without physically copying data. It’s powerful, secure, and near real‑time - but let’s be honest: it can feel a bit complex and technical. You’re dealing with Shares, Secure Views, GRANTs, ACCOUNTADMIN privileges, cross‑region considerations… a steep learning curve that can slow things down.

‍

⚡️ The Easier Way: Amplify Data

If you’re not in the mood to dive into intricate DDL logic or set up sophisticated access controls, but still want all the benefits of Snowflake-to‑Snowflake sharing, then check out the Amplify Data Platform. It’s a no-code, self‑serve solution that simplifies exactly this scenario:

• Create data products with custom row/column filters, no SQL required.
• Deliver directly into any Snowflake account (or SFTP, API, etc.) without engineering overhead.
• Track and manage consumption with built‑in analytics and governance.

Since being acquired by Monda in May 2025, Amplify has doubled down on its secure, scalable, zero-copy delivery model, plugging right into Snowflake without egress fees or data replication hassles.

So yes, you can go full-SQL and DIY your way through Shares, Secure Views, GRANTs, and Reader Accounts. But if you’d rather focus on your data strategy and relationships instead of technical plumbing, Amplify Data is a slick, time-saving alternative.

‍

If you’re interested in the nitty-gritty of how it works behind the scenes, keep reading: the detailed steps are below. But if you just want to save time and focus on your data, check out Amplify Data and skip the complexity entirely.

‍

🛠️ The Manual Way: Data Sharing

If you want to share data from one Snowflake account to another Snowflake account, you use a feature called Data Sharing, which enables you to publish and consume data without actually copying it.

Here’s a step-by-step guide:

1. What is a Data Product in this context?

A “data product” in Snowflake is typically a database (or set of tables/views) that you want to expose to others - either within your organization or externally - as a share.

In Snowflake, this is done using a Share object.

‍

2. On the Provider side (the account sharing the data)

You need to create a share and add the database objects you want to share.

Example:

sql
CopyEdit
-- Step 1: Create a share
CREATE SHARE sales_data_share;

-- Step 2: Add database objects to the share
GRANT USAGE ON DATABASE sales_db TO SHARE sales_data_share;
GRANT USAGE ON SCHEMA sales_db.public TO SHARE sales_data_share;
GRANT SELECT ON TABLE sales_db.public.orders TO SHARE sales_data_share;



You can add more tables, views, or secure views if needed.

‍

3. Grant the Share to a Consumer

Now you link the share to the consumer’s account.

‍

If you know the consumer account:

sql
CopyEdit
ALTER SHARE sales_data_share ADD ACCOUNTS = ('consumer_account_name');



You can also allow access to specific regions or organizations.

If the consumer is outside your org, you may instead publish the share as a Listing in the Snowflake Marketplace (for public or private listings).

‍

4. On the Consumer side (the account receiving the data)

The consumer creates a database from the share.

Example:

sql
CopyEdit
-- List all inbound shares available to you
SHOW SHARES;

-- Create a database from the share
CREATE DATABASE sales_data_from_provider
FROM SHARE provider_account_name.sales_data_share;



Now, sales_data_from_provider behaves like any other database - but it’s read-only.

Notes

• Data remains in the provider’s account. The consumer can query it without copying.
• Consumers cannot modify the shared data - it is read-only.
• If you use the Snowflake Marketplace, the process is similar but consumers “subscribe” via the Marketplace interface.

Useful commands

• See all outbound shares you created:

sql
CopyEdit
SHOW SHARES;



• See all consumers who use a share:

sql
CopyEdit
DESC SHARE sales_data_share;



• See inbound shares:

sql
CopyEdit
SHOW SHARES;



Optional: Use Snowflake Marketplace

If you want to share the data more broadly or with unknown accounts, you can publish it as a Listing on the Marketplace:

• In the Snowflake web UI → Data → Listings → Create Listing.
• Choose public or private.
• Choose the share you created and configure visibility.

‍

To Re-cap

Manual Snowflake-to-Snowflake Sharing 🔧

1. Define and prepare your data
   • Decide which databases, schemas, tables/views to share.
   • Optionally create secure views to filter rows/columns per consumer.
2. Create a share object
   • CREATE SHARE my_share;
   • Grant usage and SELECT privileges on the intended objects.
3. Add consumer accounts
   • ALTER SHARE my_share ADD ACCOUNTS = ('consumer_account'); for same-region shares or museum.
   • For cross-region sharing, set up replication groups, add databases and shares, and periodically refresh the replication.
4. Consumer creates a database
   • On the receiving end:
   • pgsql
CopyEdit
SHOW SHARES;
CREATE DATABASE shared_db FROM SHARE provider_account.my_share;


   • Data appears read-only and available immediately.

💡 Challenges: Complex SQL, permission management, replication setup, secure view maintenance, and handling regional differences.

‍

Using Amplify Data 🚀

1. Create a Data Product in Amplify
   • Use no-code UI to pick tables/views, and filter rows or columns dynamically.
2. Publish and configure destinations
   • Amplify can deliver the data product directly into a Snowflake account (or alternatives like SFTP, API, Databricks) without manual linkages.
3. Self-service consumer onboarding
   • Buyers connect themselves via Amplify’s UI. No need to share Snowflake account info or execute SQL scripts.
4. Monitor usage & manage governance
   • Track who’s accessing what data, usage trends, failures - all from a central dashboard.

✨ Benefits: No SQL or replication setup, no tech dependencies. Ideal for business teams wanting frictionless, secure, and customizable data sharing.

‍