Schema:: ORGANIZATION_USAGE

QUERY_ACCELERATION_HISTORY view¶

The QUERY_ACCELERATION_HISTORY view in the ORGANIZATION_USAGE schema is used for querying 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
ORGANIZATION_NAME	TEXT	Name of the organization.
ACCOUNT_NAME	TEXT	Name of the account (user-defined).
ACCOUNT_LOCATOR	TEXT	Account locator of the account (system-defined).
REGION	TEXT	Name of the region where the account is located.
USAGE_DATE	DATE	Date (in the UTC time zone) when queries were accelerated.
CREDITS_USED	NUMBER	Number of credits billed for the query acceleration service during the USAGE_DATE.
WAREHOUSE_ID	NUMBER	Internal/system-generated identifier for the warehouse that the queries were executed on.
WAREHOUSE_NAME	TEXT	Name of the warehouse that the queries were executed on.

Usage notes¶

Latency for the view may be up to 24 hours (1 day).