Troubleshoot auto-fulfillment setup issues

When you set up your listing, underlying issues with your data product can prevent auto-fulfillment.

A direct share with the same name already exists in the remote account

Error:

Two or more providers within an organization can’t create a direct share with the same name.

Cause:

A direct share with the same name already exists in the secure share area used by Cross-Cloud Auto-Fulfillment. This can happen if a different account in your organization is using Cross-Cloud Auto-Fulfillment and has a direct share with the same name auto-fulfilled to that cloud region. The secure share area in a cloud region is shared across all provider accounts in your organization.

Solution:

Rename the direct share that contains the share attached to the listing that will be auto-fulfilled. Renaming the direct share doesn’t affect any downstream consumers.

A role missing privileges on a share

Error:

OWNERSHIP on the selected share is required to enable auto-fulfillment.

Cause:

Only the ACCOUNTADMIN role can set up auto-fulfillment. This error can occur when the ACCOUNTADMIN role is not granted and does not inherit the role that owns the share attached to the listing.

Solution:

Grant the role that owns the share to the ACCOUNTADMIN role. For example, run the following:

GRANT ROLE SHARE_OWNER TO ROLE ACCOUNTADMIN;
Copy

Auto-fulfillment failed during snapshot generation for multiple listings

Error:

Internal error occurs during auto-fulfillment for multiple listings.

Cause:

The error can occur if multiple listings use the same database for cross-region sharing and one of the listings contains or references an unsupported object type. This can impact the auto-fulfillment process for all listings that use that database. For example, let’s say a provider adds a new listing to be transferred across clouds or regions. The new listing shares objects from a database that other listings also use. The new listing includes a VIEW using a BUILD_SCOPED_FILE_URL, a function that calls GET_STAGE_FILE to retrieve data from an external stage in S3. Because external stages are not supported for auto-fulfillment, and the objects in that database are transferred together as a group, the other listings get the same error. If no action is taken, existing consumers in remote regions will not get updates, and new customers will not be able to get the data product.

Similar-looking errors can occur for other issues like network issues, authentication problems, or unsupported object types in certain operations (like replication).

Solution:

Starting with listings that were most recently added or updated, verify the following:

  • Verify that the listings in the group of listings that have errors include only supported object types for cross-region auto-fulfillment,

  • Verify that none of the objects make reference to unsupported object types. You might have to check multiple levels of dependencies to identify the root cause of the issue, for example, a view calling BUILD_SCOPED_FILE_URL which itself calls GET_STAGE_FILE to retrieve data from an external stage.

  • Use separate databases for listings that require different object types to avoid cross-impact.

  • Remove or replace any unsupported objects to avoid auto-fulfillment errors.

  • Check for any potential network, authentication, or missing GRANTS issue.

  • Contact Snowflake Support if the issue persists or you need assistance.

The database is larger than 10 terabytes

Error:

Auto-fulfillment is unavailable because the share is associated with a database larger than 10TB.

Auto-fulfillment is unavailable because the data product is associated with a database larger than 10TB.

Cause:

The database that contains the objects in your share is larger than the 10TB limit for database replication and auto-fulfillment. The limit exists to prevent unexpectedly high costs resulting from auto-fulfillment or replication, but can be changed.

Solution:

Explore the cost ramifications for auto-fulfilling a database larger than 10TB to one or more regions. See Auto-fulfillment costs.

If you accept the potential added cost, you can contact Snowflake Support to have the limit adjusted for your entire account.

The data product contains a reference database

Error:

The reference database in the share is not supported for auto-fulfillment.

The shared object references below are incompatible.

The references below in the shared database are incompatible.

Cause:

The share attached to the listing contains a reference database or contains objects that reference a different database. Referencing objects in a different database is not supported for auto-fulfillment.

Solution:

You can do one of the following:

  • Remove the reference database, and objects referring to the reference database, from the share.

  • Use a different database that has all of the objects required for the share. You might need to recreate tables in the new database and view & function definitions updated.

  • Use manual fulfillment instead. Only some listings can be manually fulfilled. See Manually replicate data to fulfill a listing request.

The data product contains unsupported objects

Error:

The data product contains objects incompatible with cross-region sharing. Update the data product to share with accounts in other regions.

The shared objects below are incompatible.

The objects below in shared database are incompatible.

Cause:

The database that contains the share contains objects unsupported by auto-fulfillment. Because the entire database gets auto-fulfilled, even if the share does not contain the objects, you might still encounter this issue.

For an application package, you might see this issue if the data content included in the application or the referenced database contains objects unsupported by auto-fulfillment.

Solution:

Review the full list of supported objects for auto-fulfillment. See Objects supported for auto-fulfillment.

If the database contains objects that are not supported, you can do one of the following:

  • Remove the unsupported objects from the database or application package to be shared.

  • Use a different database that has all the objects required for the share, and no unsupported objects.

The listing database is a primary database

Error:

The primary database in the share is not supported for auto-fulfillment.

The primary database in the data product is not supported for auto-fulfillment.

Cannot auto-fulfill listing: listing database is a global database, which is not supported.

Cause:

The share contains objects from a database that was previously used for database replication.

Solution:

You can do one of the following:

The listing database is a secondary database

Error:

The secondary database in the share is not supported for auto-fulfillment. You will need to manually set up accounts in available regions, replicate the database to each account, create a secure share in each account, and attach those shares to this listing.

The secondary database in the data product is not supported for auto-fulfillment. Please choose another data product.

Cause:

The database that contains the share is a secondary database, which is read-only and cannot be replicated or auto-fulfilled.

Solution:

You can do one of the following:

  • Create your listing from the account where the database is the primary database.

  • Stop replicating the database manually to other regions.

The user is unable to share to accounts in other regions

Error:

To share to accounts in other regions, please contact your organization administrator to delegate privileges to the ACCOUNTADMIN role in this account.

Cause:

Your role does not have permission to set up auto-fulfillment.

Solution:

Contact your organization administrator to Manage privileges for auto-fulfillment.