Troubleshooting Cross-Cloud Auto-fulfillment¶

Role missing privileges on 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

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 Allow accounts to set up cross-cloud auto-fulfillment.

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 Managing Cross-Cloud Auto-fulfillment costs.

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

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 before fulfilling a listing request.

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 a full list of unsupported objects, see Unsupported object types for auto-fulfillment.

Solution

You can do one of the following:

• Remove the unsupported objects from the database to be shared.

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

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:

• Convert the secondary and primary databases to use replication groups and set up a manual replication group if desired. See Transitioning From Database Replication to Group-Based Replication

• Use a different database that has all of the objects required for the share, and has not been previously replicated.

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.

Database with the same name already exists in the remote account¶

Error

The reference database in the data product is not supported for auto-fulfillment because it is already being auto-fulfilled as part of another listing. Please remove all reference databases and objects referring to the reference database before sharing to remote customers.

Cause

A database with the same name already exists in the secure share area used by auto-fulfillment. This can happen if a different account in your organization is also using auto-fulfillment and has a database with the same name auto-fulfilled to that cloud region.

Solution

You can do one of the following:

• Rename the database that contains the share attached to the listing that will be auto-fulfilled.

• Use a different database that has all of the objects required for the share.

Data is missing or out of sync for consumers¶

Error

Consumer reports that views from an auto-fulfillment listing are no longer visible.

Cause

You re-created objects, such as tables or views, associated with your listing and either:

• The objects were not re-granted to the share after being re-created

• Or, the objects were re-granted but it has been less than 10 minutes. Changes to objects granted to shares are checked every 10 minutes, so if it has been less than 10 minutes, the updated objects have not yet been auto-fulfilled to the consumer’s region.

Solution

Verify that the objects were re-granted to the share, and determine how much time has passed since the grant query was run.

To confirm that all objects are granted to the share in your primary account, run the following:

SHOW GRANTS to SHARE <share_name>;

Copy

If needed, re-grant objects to the share:

GRANT USAGE on DATABASE <db_name> to SHARE <share_name>;
GRANT USAGE on SCHEMA <schema_name> to SHARE <share_name>;
GRANT SELECT on TABLE <table_name> to SHARE <share_name>;
GRANT SELECT on VIEW <view_name> to SHARE <share_name>;
GRANT USAGE on FUNCTION <function_name(parameters)> to SHARE <share_name>;

Copy

Allow up to 10 minutes after grants have been updated in the primary region, or after a database has been refreshed with new objects, for grants to apply in all remote regions.

Long delay getting data after requesting listing¶

Consumer reports that they requested a listing in their region, but after several days, they still don’t have access to the data product.

Error

Data is replicating to your region…

Cause

If the error message appears for several days with no change in status, it’s likely that an auto-fulfillment error occurred.

Solution

As a provider, view the listing details to identify a specific error preventing auto-fulfillment of the data product, and refer to this troubleshooting guide to address the error.

As a consumer, contact the provider to let them know that there is a problem auto-fulfilling their data product to your region.