浏览总体成本

You can explore historical cost using Snowsight, or by writing queries against views in the ACCOUNT_USAGE and ORGANIZATION_USAGE schemas. Snowsight allows you to quickly and easily obtain information about cost from a visual dashboard. Queries against the usage views allow you to drill down into cost data and can help generate custom reports and dashboards.

If you need an introduction to how costs are incurred in Snowflake, refer to Understanding overall cost.

To obtain a billing statement that contains information about historical usage, see Access a billing usage statement.

Viewing costs using Snowsight¶

Snowsight provides multiple pages that allow you to explore the historical cost of using Snowflake. For details on using these pages to view overall costs, see:

• 组织级别成本概览
• 账户级别成本概览
• 深入了解产生的成本

组织级别成本概览

The Organization Overview page provides insights into how your organization is spending the capacity commitment made in the current contract. For example, it shows you the remaining balance of the contract, the accumulated cost of Snowflake usage since the start of the contract, and the monthly spend for the organization.

它还为您提供组织中每个账户所支出的金额的概览。

要访问组织级别的已发生成本概览，请执行以下操作：

1. Sign in to the organization account or an ORGADMIN-enabled account.
2. Switch to a role with access to cost-related features.
3. In the navigation menu, select Admin » Cost management.
4. 选择要使用的仓库，以查看使用情况数据。Snowflake 建议使用 X 小仓库来实现此目的。
5. Select Organization Overview.

The Account Spend Summary tile has a View All option to expand the contents of the tile to include all of the accounts in the organization, not just the accounts that have spent the most. To display the SQL query used to populate this tile, select View All » View query () .

账户级别成本概览

The Account Overview page provides high-level insights into the cost of using Snowflake and can be a starting off point for optimizing your spend.

要访问账户级别的已发生成本概览，请执行以下操作：

1. Sign in to Snowsight.
2. Switch to a role with access to cost-related features.
3. In the navigation menu, select Admin » Cost management.
4. 选择要使用的仓库，以查看使用情况数据。Snowflake 建议使用 X 小仓库来实现此目的。
5. Select Account Overview.

Many tiles on the Account Overview page have a View All option to expand the contents of the tile to include more items. For example, for the Top warehouses by cost tile, select View All to open a dialog that displays all warehouses in your account sorted by cost.

To display the SQL query used to populate a tile, select View All » View query () . For example, if you view the query for the Top warehouses by cost tile, you see that the data comes from querying the WAREHOUSE_METERING_HISTORY view in the ACCOUNT_USAGE schema of the shared SNOWFLAKE database.

深入了解产生的成本

You can use the Consumption page to drill down into the overall cost of using Snowflake for any given day, week, or month.

To use Snowsight to drill down into the overall cost:

1. Sign in to Snowsight.
2. Switch to a role with access to cost-related features.
3. In the navigation menu, select Admin » Cost management.
4. 选择要使用的仓库，以查看使用情况数据。Snowflake 建议使用 X 小仓库来实现此目的。
5. Select Consumption.
6. Select All Usage Types from the drop-down list.

这汇总了计算、存储和数据传输资源的成本，并使用该组织的货币将其显示在条形图中。所选时间段内这些资源的总成本显示在条形图上方。

To isolate the cost of compute, storage, or data transfer, adjust your selection in the All Usage Types filter.

使用说明

Keep the following in mind when accessing the Consumption page:

• It can take up to 72 hours for cost information to become available in Snowsight.

• To access all of the features on the Consumption page, the account administrator must also have the ORGADMIN role. For example, if a user has the ACCOUNTADMIN role, but does not have the ORGADMIN role, they can only view costs for the current account. The Account filter that would allow them to switch to a different account does not appear.
• If the usage details fail to load with a message indicating that The result set is too large to display, you must use the filters to select a shorter date range or otherwise filter the results.
• Compute costs do not include queries executed on a warehouse by the SYSTEM user as part of a user-defined task.

总体成本查询数据

以下查询结合了 ORGANIZATION_USAGE 架构中 USAGE_IN_CURRENCY 视图中的数据，以便深入了解 Snowflake 的总体使用成本。

Query: Total usage costs in dollars for the organization, broken down by account

Copy codeExpand code block

SELECT account_name,
  ROUND(SUM(usage_in_currency), 2) as usage_in_currency
FROM snowflake.organization_usage.usage_in_currency_daily
WHERE usage_date > DATEADD(month,-1,CURRENT_TIMESTAMP())
GROUP BY 1
ORDER BY 2 desc;

Show lessSee more

Scroll to top

后续主题：

• Exploring compute cost
• Exploring storage cost
• Exploring data transfer cost