监控资源并查看成本
本节介绍如何监控自动履行资源并查看与自动履行相关的预计和实际成本。
监控资源
如果想尽量降低与自动履行相关的成本，请检查列表的使用情况，并了解更多有关为自动履行准备数据的信息：
- Monitor Compute Resources
确定 Snowflake 运行的查询，并检查列表的刷新频率间隔。
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 Set the account-level refresh interval.
- 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 auto-fulfilled. Refer to Prepare 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.
- Monitor ECO costs
Monitor the ECO costs across your organization. Run the USAGE_IN_CURRENCY_DAILY view in the ORGANIZATION_USAGE schema of the SNOWFLAKE database. In the SERVICE_TYPE column, review the EGRESS_COST_OPTIMIZER value.
查看估算成本
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.
查看实际成本
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 fulfilling 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 in to Snowsight.
-
In the navigation menu, select Admin » Cost management, and then select Consumption.
-
选择要使用的仓库，以查看使用情况数据。
-
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-fulfilling data to the AWS region eu_west_2.
-
使用筛选器查看所有使用类型，或重点关注计算、存储或数据传输成本。
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.
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 Monitor listing use.