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 where the usage took place.

ACCOUNT_NAME

TEXT

Name of the account where the usage took place.

ACCOUNT_LOCATOR

TEXT

Account locator in a region.

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).

  • The data is retained for 365 days (1 year).