Schema:

ACCOUNT_USAGE

HYBRID_TABLE_USAGE_HISTORY view¶

This Account Usage view displays consumption of Hybrid Table Requests (serverless compute) resources for hybrid tables, in terms of credits billed for your entire Snowflake account, within the last 365 days (1 year).

Columns¶

Column Name

Data Type

Description

OBJECT_TYPE

TEXT

Type of object referenced for scope of consumption. ACCOUNT by default for scope of consumption of hybrid tables in your account.

OBJECT_ID

NUMBER

Internal identifier of object referenced for scope of consumption. Because scope of consumption of hybrid tables is tracked at the account level, this value is NULL by default.

OBJECT_NAME

TEXT

Name of object referenced for scope of consumption. Because scope of consumption of hybrid tables is tracked at the account level, this value is NULL by default.

START_TIME

TIMESTAMP_LTZ

Date and start time (in the local time zone) when usage of hybrid tables occurred.

END_TIME

TIMESTAMP_LTZ

Date and end time (in the local time zone) when usage of hybrid tables occurred.

CREDITS_USED

NUMBER

Number of credits used for Hybrid Table Requests between the values for START_TIME and END_TIME.

Usage notes¶

  • Latency for the view may be up to 180 minutes (3 hours).

  • This view may return usage data that is slightly inconsistent with metrics returned in METERING_DAILY_HISTORY view and METERING_HISTORY view. The discrepancy in the calculation of credits used is due to rounding during division.

Examples¶

This query returns the total number of credits used by hybrid tables in your account over a specific period of time:

-- Credits used (all time = past year)
SELECT object_name,
  SUM(credits_used) AS total_credits
FROM snowflake.account_usage.hybrid_table_usage_history
GROUP BY 1
ORDER BY 2 DESC;

-- Credits used (past N days/weeks/months)
SELECT object_name,
  SUM(credits_used) AS total_credits
FROM snowflake.account_usage.hybrid_table_usage_history
WHERE start_time >= DATEADD(day, -m, CURRENT_TIMESTAMP()) 
GROUP BY 1
ORDER BY 2 DESC;
Copy