Schema:

ACCOUNT_USAGE

CORTEX_SEARCH_SERVING_USAGE_HISTORY view¶

This Account Usage view can be used to query the hourly serving usage history of Cortex Search. The information in this view includes the number of serving credits consumed per hour for a Cortex Search Service. This view only contains credits consumed for serving, not the other costs associated with a Cortex Search Service. For more information, see Cost considerations.

Columns¶

Column Name

Data Type

Description

START_TIME

TIMESTAMP_LTZ

Start of the specified time range in which the Cortex Search serving usage took place.

END_TIME

TIMESTAMP_LTZ

End of the specified time range in which the Cortex Search usage took place.

DATABASE_NAME

TEXT

Name of the database in which the Cortex Search Service resides.

SCHEMA_NAME

TEXT

Name of the schema in which the Cortex Search Service resides.

CORTEX_SEARCH_SERVICE_NAME

NUMBER

Name of the Cortex Search Service.

CORTEX_SEARCH_SERVICE_ID

NUMBER

ID of the Cortex Search Service.

CREDITS

NUMBER

Number of credits billed for Cortex Search serving usage based on the size of indexed data during the START_TIME and END_TIME window.

Usage notes¶

  • The view provides up-to-date credit usage for an account within the last 365 days (1 year).

  • Serving credits are incurred per GB-mo of indexed data, metered at the second-level. One may get an estimate of the indexed data size for a given service using the credit rate defined in the Snowflake Service Consumption Table.

  • This view may show small discrepancies in incurred cost from hour-to-hour based on the second-level metering.