We’re excited to announce a major expansion of Snowflake’s zero-ETL data sharing: Now, you can easily and securely share open table formats, including Apache Iceberg and Delta Lake, across regions and clouds. This release allows source providers to securely share data stored in open table formats across any cloud and region without complex pipelines and without incurring exponential per-query egress charges.
Snowflake data sharing already leads in the market when it comes to collaboration capabilities and adoption. With 2.5x the data sharing ecosystem compared to leading competitors, Snowflake collaboration provides increasing value to a growing, global user base. With thousands of customers already sharing data, businesses can use open table format sharing to get the best of both worlds: open-format data sharing and all of the core benefits of Snowflake sharing. These benefits include:
Near real-time data access
Snowflake Horizon Catalog’s policy-based governance controls for shared data
Cross-Cloud Auto-Fulfillment and Egress Cost Optimizer for simplified and economical cross-region and cross-cloud sharing
Delivery into regulated regions including the U.S. government cloud and Virtual Private Snowflake
For many years, Snowflake customers have been able to securely share data and collaborate with a vast ecosystem of customers and partners. Data sharing is a cornerstone of the Snowflake platform, with many customers using it to develop connections and build strong data ecosystems in the Snowflake AI Data Cloud.
With the introduction of open table format sharing, Snowflake collaboration capabilities have expanded to:
Data stored outside of Snowflake in customers’ own cloud storage (AWS S3, Azure Storage, Google GCS)
Data in open table formats, including:
Apache Iceberg managed by Horizon Catalog or managed by external catalogs (AWS Glue, Apache Polaris)
Delta Lake managed by external catalogs (Databricks Unity, Hive Metastore)
This means businesses that choose open table formats are also now connected into the AI Data Cloud and can enjoy the benefits of a thriving data ecosystem.
Most organizations frequently need to share diverse data formats, both internally and externally, yet they often encounter obstacles such as:
Security and compliance: Enforcing fine-grained data-access policies on shared data is crucial for maintaining security and compliance.
Geographic and cloud dispersion: Collaboration among business units (LOBs, vendors, customers) that are often spread across different regions and clouds, including commercial and government cloud environments.
Varied data formats: Data exists in diverse formats, such as Apache Iceberg and Delta Lake.
Snowflake data sharing, and specifically open table format sharing, directly addresses the key obstacles that data engineers and data architects face when collaborating on data. It reduces geographic and cloud barriers with the ability to share open-format tables, it extends core governance capabilities, and it gives customers the flexibility to standardize on a data format such as Iceberg, all while allowing global organizations to share with any business unit, vendor and/or customer.
Open table format sharing is enabled by Cross-Cloud Auto-Fulfillment (supported on commercial, Virtual Private Snowflake and U.S. government clouds), which simplifies data sharing for Apache Iceberg and Delta Lake directly from your cloud storage. You can share this data with a Snowflake consumer in any region or cloud without needing to manage the underlying infrastructure or requiring you to maintain extract, transform and load (ETL) jobs. In addition, open table format sharing optimizes data transfer costs through Egress Cost Optimizer, helping to avoid unpredictable and astronomical per-query egress charges.
Snowflake Horizon Catalog provides comprehensive policy-based governance controls that can be applied to open table format data shared with consumers across different regions or clouds. This capability ensures data residency and facilitates the compliance necessary for collaboration, particularly within or in conjunction with regulated sectors, such as public sectors, financial services, healthcare and life sciences.
When combined with Delta Direct and Catalog Federation (leveraging Unity Catalog and Uniform’s IRC API), Snowflake Cross-Cloud Auto-Fulfillment extends this capability to a Delta Lake table residing in your cloud storage and written by Delta engines such as Microsoft Fabric or Databricks or managed by catalogs such as Databricks Unity or Hive Metastore. This extends open table sharing to Delta Lake tables with Snowflake consumers in any region or cloud, again, without the need to manage underlying infrastructure.
Open table format sharing allows Apache Iceberg and Delta Lake tables to be shared across regions or clouds and is available only through the Iceberg Cross-Cloud Auto-Fulfillment feature. For details on how auto-fulfillment works, see “Auto-fulfillment for listings.” For more information on how open table format sharing works, see the “Using auto-fulfillment with open format tables” documentation.
Here is how to get started with sharing open table formats, using the example of sharing Iceberg tables.
Sign in to the provider account and create an open table format (such as Iceberg) following the SQL commands listed below. For more information on how to create Iceberg tables or managed by external catalogs, see the CREATE ICEBERG TABLE documentation here.
Before sharing, leverage Snowflake Horizon Catalog’s governance features’ full support on your Horizon-managed and externally managed Apache Iceberg or Delta tables, including:
Fine-grained governance policies: row access, masking policies
Privacy-enhancing policies: aggregation policy, join policy, projection policy
Data classification and tagging
Additionally, you can audit and monitor the sharing with a complete audit using account usage and access history.
For more information, review examples in “Share data protected by policy.”
In your provider account, create a private listing through Snowsight interface by clicking +Listing and selecting Only Specified Customers, then doing the following:
Specify a listing name
Attach the Iceberg table that you created
Add a listing description
Specify the account alias of the consumer account
Publish the listing
Detailed steps are available here.
Status: Using the ACCOUNTADMIN role, you can check the status of the listing in the provider account by going to Data Sharing -> Provider Studio -> Listings.
Cross-Cloud Auto-Fulfillment ensures that your data is securely and automatically delivered to consumers across any region or cloud.
Consumers can go to Data Products -> Private Sharing to find the private listing, and then click Get. The consumer can be within the same account (internal sharing), within the same organization (internal marketplace), or across organizations (external sharing on Snowflake Marketplace).
Snowflake is extending its zero-ETL data-sharing leadership by integrating open table formats to enable secure, governed and cost-optimized data sharing across any cloud and region. To see these powerful new capabilities in action and learn how to get started, check out this solutions page featuring a demo and quickstart!
When architecting technology needs, data and AI leaders rarely settle for a single product. Instead, they often select core platforms […]
We’re excited to announce a major expansion of Snowflake’s zero-ETL data sharing: Now, you can easily and securely share open […]
As people analytics leaders, we often talk about the future of work and how technology will shape it. But at […]
Our services help both the big and small organisations in the identification of security breaches and provide outclass solutions to prevent any potential harm.