Manage Cross-Cloud Auto-Fulfillment costs¶
As a provider, you can enable Cross-Cloud Auto-Fulfillment for a listing to automatically replicate your data product to other Snowflake regions.
When you configure Cross-Cloud Auto-Fulfillment for your listing, you don’t have to manage replicating the data. However, you still incur costs associated with replicating and storing your data product in other Snowflake regions to support consumers of your listing.
Unlike traditional manual database replication, Cross-Cloud Auto-Fulfillment does not require a separate account in each region that you support. Instead, Snowflake creates one secure share area for an organization to manage auto-fulfillment to a region and associates billing costs with that area. Because of that, the costs associated with Cross-Cloud Auto-Fulfillment are attributed differently when compared to manual database replication costs.
About Cross-Cloud Auto-Fulfillment¶
Cross-Cloud Auto-Fulfillment lets you offer a data product in any supported Snowflake region, based on the availability and access options you select for your listing, without having to manually replicate data.
For more details, see How Cross-Cloud Auto-Fulfillment works.
Understand Cross-Cloud Auto-Fulfillment costs¶
Cross-Cloud Auto-Fulfillment incurs usage costs in the same way that regular usage of Snowflake does:
- Compute Resources
Replication operations use compute resources to copy data and manage the status of the data in the secure share areas in other regions.
- Storage Resources
Databases replicated to secure share areas in other regions incur storage costs.
- Data Transfer Resources
The initial database replication and subsequent synchronization operations transfer data between regions. Cloud providers charge for data transferred from one region to another within their own network or a region in another cloud.
The data transfer rate is determined by the location of the source account (i.e. the account that stores the primary database) and the destination region and cloud. For data transfer pricing, see the pricing guide (on the Snowflake website).
For more information about data transfer billing, refer to Understanding Data Transfer Cost.
When you use Cross-Cloud Auto-Fulfillment, these usage costs are attributed to one Snowflake-managed secure share area for each region in which you have consumers of your listings. See View actual costs for details about attributing costs. For details about the components of cost in Snowflake, see Understanding Overall Cost.
Estimate and control costs¶
When you configure auto-fulfillment for your listing, the following factors can affect the cost of fulfilling your listing to other regions:
- Compute Resource Factors
Queries run by Snowflake to fulfill your listing contributes to compute resources. The refresh frequency that you set affects how frequently these queries run.
- Storage Resource Factors
The size of the database, the rate at which data is appended and updated, and the rate of change in the database affect how much data is replicated and stored initially and continuously.
- Data Transfer Resource Factors
The cloud region that the listing is replicated to, and the cloud provider of that region affect the cost of data transfer. The more regions that consumers request your listing in, the higher the cost to fulfill those listings, due to the data transfer cost. For data transfer pricing, see the pricing guide (on the Snowflake website).
If you want to minimize costs associated with auto-fulfillment, review the usage of your listings and learn more about preparing your data for auto-fulfillment:
- Monitor Compute Resources
Identify the queries run by Snowflake and review the refresh frequency interval for your listings.
Refer to the LISTING_AUTO_FULFILLMENT_REFRESH_DAILY View to identify the listings and databases contributing to compute cost.
To identify the queries run by Snowflake to support auto-fulfillment, review the Query History and filter on Client generated statements. Refer to the Query History Page.
Review the refresh frequency interval that you set for the listing. Refer to Monitoring and managing auto-fulfillment settings.
- Monitor Storage Resources
Determine what data to put in your listing and how to structure your data to minimize the amount that needs to be replicated. Refer to Preparing data for a listing. Cross-Cloud Auto-Fulfillment does not support secure views that reference data stored in other databases.
Refer to the LISTING_AUTO_FULFILLMENT_DATABASE_STORAGE_DAILY View to identify listings and databases contributing to storage cost.
- Monitor Data Transfer Resources
Identify the regions in which secure share areas have been created. Run the SHOW REPLICATION ACCOUNTS command.
To view estimated costs for all secure share areas associated with the provider accounts in your organization, use the LISTING_AUTO_FULFILLMENT_USAGE_HISTORY View in the ORGANIZATION_USAGE schema of the SNOWFLAKE database.
To view actual costs for accounts in your organization, use other views in the ORGANIZATION_USAGE schema of the SNOWFLAKE database.
View actual costs¶
You can use the ORGANIZATION_USAGE view or the Snowsight Usage dashboard to view costs associated with Cross-Cloud Auto-Fulfillment and attribute costs associated with replicating listings to specific regions. Use the accounts prefixed with SNOWFLAKE_MANAGED$ and AUTO_FULFILLMENT_AREA$ to attribute cost to specific regions.
You must be an account administrator (use the ACCOUNTADMIN role) or use the ORGANIZATION_USAGE_VIEWER database role to view usage data for Snowflake.
To view actual costs in Snowsight, do the following:
Sign into Snowsight.
Select Admin » Cost Management, and select the Consumption tab.
Select a warehouse to use to view the usage data.
Using the accounts filter, select the accounts titled SNOWFLAKE_MANAGED$PUBLIC_<region_name> or AUTO_FULFILLMENT_AREA$-<region_name> to filter on the secure share areas used by auto-fulfillment.
For example, select SNOWFLAKE_MANAGED$PUBLIC_AWS_EU_WEST_2 to view the costs associated with using auto-fulfillment to replicate data to the AWS region eu_west_2.
Use the filters to view all usage types, or focus on compute, storage, or data transfer costs.
The costs that you see reflect all listings shared to a particular region by any account in your organization. To identify which listings are being consumed in which regions and contributing to the costs in a specific region, see Monitoring usage of your listing.
To view estimated costs using SQL, you can query the LISTING_AUTO_FULFILLMENT_USAGE_HISTORY View in the ORGANIZATION_USAGE schema. To view actual costs, refer to the other views in the ORGANIZATION_USAGE schema. For more details on viewing costs, see Exploring Overall Cost.