- Schema:
QUERY_ACCELERATION_HISTORY View¶
This Account Usage view can be used to query the history of queries accelerated by the query acceleration service. The information returned by the view includes the warehouse name and the credits consumed by the query acceleration service.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
START_TIME |
TIMESTAMP_LTZ |
Start of the specified time range. |
END_TIME |
TIMESTAMP_LTZ |
End of the specified time range. |
CREDITS_USED |
NUMBER |
Number of credits billed for the query acceleration service during the START_TIME and END_TIME window. |
WAREHOUSE_ID |
NUMBER |
Internal/system-generated identifier for the warehouse. |
WAREHOUSE_NAME |
TEXT |
Name of the warehouse. |
Usage Notes¶
Billing history is not necessarily updated immediately. Latency for the view may be up to 180 minutes (3 hours).
Examples¶
Credits used by each warehouse in your account for the query acceleration service (month-to-date):
select warehouse_name,
sum(credits_used) as total_credits_used
from query_acceleration_history
where start_time >= date_trunc(month, current_date)
group by 1
order by 2 desc;