Schema:

ORGANIZATION_USAGE

AUTOMATIC_CLUSTERING_HISTORY View

The AUTOMATIC_CLUSTERING_HISTORY view in the ORGANIZATION_USAGE schema is used for querying the Automatic Clustering history for your organization’s tables within a specified date range. The information returned by the function includes the credits consumed, bytes updated, and rows updated each time a table is reclustered.

While the feature is in preview, we may make some behavior changes. We will notify you about any changes before implementing them.

Columns

Column Name

Data Type

Description

ORGANIZATION_NAME

VARCHAR

Name of the organization in which the usage took place.

ACCOUNT_NAME

TEXT

Name of the account where the usage took place.

ACCOUNT_LOCATOR

TEXT

Name of the account locator.

REGION

VARCHAR

Name of the region where the account is located.

USAGE_DATE

DATE

Date when automatic clustering usage occurred.

CREDITS_USED

TEXT

Number of credits billed for automatic clustering during the USAGE_DATE.

NUM_BYTES_RECLUSTERED

NUMBER

Number of bytes reclustered during the usage date.

NUM_ROWS_RECLUSTERED

NUMBER

Number of rows reclustered during the USAGE_DATE.

TABLE_ID

NUMBER

Internal/system-generated identifier for the table.

TABLE_NAME

TEXT

Name of the table.

SCHEMA_ID

NUMBER

Internal/system-generated identifier for the schema that contains the table.

SCHEMA_NAME

TEXT

Name of the schema that contains the table.

DATABASE_ID

NUMBER

Internal/system-generated identifier for the database that contains the table.

DATABASE_NAME

TEXT

Name of the database that contains the table.

Usage Notes

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

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

Back to top