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