Schema:

ORGANIZATION_USAGE

SEARCH_OPTIMIZATION_HISTORY View

The SEARCH_OPTIMIZATION_HISTORY view in the ORGANIZATION_USAGE schema is used for querying the search optimization service maintenance history for a specified table within a specified date range. The information returned by the function includes the table name and credits consumed each time a search optimization maintenance operation occurred.

Columns

Column Name

Data Type

Description

ORGANIZATION_NAME

VARCHAR

Name of the organization where 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 (in the UTC time zone) of this usage record.

CREDITS_USED

NUMBER

Number of credits billed for the search optimization service during the USAGE_DATE.

TABLE_ID

NUMBER

Internal/system-generated identifier for the search optimization service.

TABLE_NAME

TEXT

This is a system-generated alias that contains the ID of the table for which search optimization was enabled; that ID is embedded inside a string of the form “SEARCH OPTIMIZATION ON TABLE_ID: <optimized_table_id>”. For example, if you enable search optimization on a table named accounts, and if accounts has ID 1200, then the TABLE_NAME (alias) shown in this column will be “SEARCH OPTIMIZATION ON TABLE_ID: 1200”.

SCHEMA_ID

NUMBER

Internal/system-generated identifier for the schema that contains the search optimization service.

SCHEMA_NAME

TEXT

Name of the schema that contains the search optimization service.

DATABASE_ID

NUMBER

Internal/system-generated identifier for the database that contains the search optimization service.

DATABASE_NAME

TEXT

Name of the database that contains the search optimization service.

Usage Notes

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

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