CORTEX_SEARCH_SERVICES view¶
This view shows existing Cortex Search Services in the current or specified database.
Columns¶
Column Name | Data Type | Description |
|---|---|---|
SERVICE_CATALOG | VARCHAR | Database that the service belongs to. |
SERVICE_SCHEMA | VARCHAR | Schema that the service belongs to. |
SERVICE_NAME | VARCHAR | Name of the service. |
CREATED | TIMESTAMP_LTZ | Creation time of the service. |
DEFINITION | VARCHAR | SQL query used to create the service. |
SEARCH_COLUMN | VARCHAR | Name of the search column. |
ATTRIBUTE_COLUMNS | VARCHAR | Comma-separated list of attribute columns in the service. |
COLUMNS | VARCHAR | Comma-separated list of all columns included in the service. |
TARGET_LAG | VARCHAR | Target lag for refreshing the service. |
WAREHOUSE | VARCHAR | Name of the warehouse used for refreshing the service. |
COMMENT | VARCHAR | Comment for this service. |
SERVICE_QUERY_URL | VARCHAR | URL for querying the service. |
OWNER | VARCHAR | Role that owns the service. |
OWNER_ROLE_TYPE | VARCHAR | Type of role of the service owner (one of DATABASE_ROLE or ROLE). |
DATA_FRESH_AS_OF | TIMESTAMP_LTZ | Time when data was last confirmed fresh. |
DATA_TIMESTAMP | TIMESTAMP_LTZ | Time at which the source data was checked for changes resulting in the currently serving index. |
SOURCE_DATA_BYTES | NUMBER | Current size, in bytes, of the materialized source data. |
SOURCE_DATA_NUM_ROWS | NUMBER | Current number of rows in the materialized source data. |
INDEXING_STATE | VARCHAR | Indexing state of the service (one of SUSPENDED or RUNNING). |
INDEXING_ERROR | VARCHAR | Error encountered in the last indexing pipeline, if one exists. |
SERVING_STATE | VARCHAR | Serving state of the service (one of SUSPENDED or RUNNING). |
SERVING_DATA_BYTES | NUMBER | Size of the billable serving data, in bytes. |
EMBEDDING_MODEL | VARCHAR | The vector embedding model used by the service. |
Example¶
SELECT * FROM SNOWFLAKE.INFORMATION_SCHEMA.CORTEX_SEARCH_SERVICES;