CORTEX_SEARCH_SERVICE_SCORING_PROFILES view

This Information Schema view displays a row for each Cortex Search Service named scoring profile in the current or specified database.

For more information about named scoring profiles, see Named scoring profiles.

Columns

Column NameData TypeDescription
SERVICE_CATALOGVARCHARThe database in which the service is defined.
SERVICE_SCHEMAVARCHARThe schema in which the service is defined.
SERVICE_NAMEVARCHARThe name of the search service to which the profile belongs.
PROFILE_NAMEVARCHARThe name of the scoring profile.
SCORING_PROFILEVARCHARThe scoring profile configuration as a JSON-format string.

Example

The following statement lists the named scoring profiles that are in the current database.

SELECT * FROM INFORMATION_SCHEMA.CORTEX_SEARCH_SERVICE_SCORING_PROFILES;