Consumer fulfillment behavior

Traditionally, Snowflake uses two primary fulfillment patterns:

  • Same-region access: Consumers in the same region as the provider access data directly from the provider’s account without additional replication.

  • Cross-region access: Providers use auto-fulfillment to replicate data and metadata to a Secure Share Area (SSA) in the consumer’s region.

The impact of failover groups for listings

With the introduction of failover groups for listings, Snowflake ensures that metadata and relationships remain intact in a secondary data recovery (DR) account. This capability provides a specialized access pattern designed to prevent downtime for your consumers, regardless of the region that is currently the primary.

Consumer access patterns

After providers configure Business Continuity and Disaster Recovery (BCDR) for listings, the fulfillment path depends on the consumer’s location relative to the listing’s original primary region.

The original primary region

In the region where the listing was originally created, sometimes called the Home region, consumers access data directly from the original provider account.

  • Failover status: Regardless of the failover status, even if the listing fails over to a secondary region, consumers in the original region don’t switch to an SSA.

  • Data updates: These consumers continue to receive fresh data through the failover group, which replicates data back from the new primary to the old primary.

Secondary and remote regions

For consumers located in any other region — including the region where the DR secondary account resides — fulfillment follows the SSA pattern.

  • Unified mount point: To ensure a seamless experience, Snowflake maintains a single mount point per region. In these regions, that mount point is the SSA.

  • Failover resiliency: If a failover occurs, the SSA begins sourcing its updates from the new primary account. The consumer’s connection to the SSA remains unchanged, resulting in zero downtime.

Comparison of fulfillment paths

The following table summarizes how fulfillment works based on the consumer location.

Consumer location

Fulfillment source

Access method

Original primary region

Original provider account

Direct share

Secondary (DR) region

SSA

Auto-fulfillment

All other remote regions

SSA

Auto-fulfillment