Schema:: LOCAL

CORTEX_ANALYST_REQUESTS_V view¶

The CORTEX_ANALYST_REQUESTS_V view presents Cortex Analyst request log data.

Columns¶

`timestamp`	TIMESTAMP_NTZ	The time the request was received.
`semantic_model_type`	VARCHAR	The data that was used to provide the semantic model. This value is one of the following: `FILE_ON_STAGE`: The semantic model was loaded from a semantic model file on a Snowflake stage. `SEMANTIC_VIEW`: The semantic model was loaded from a semantic view definition.
`semantic_model_name`	VARCHAR	The name of the semantic model. For models loaded from a stage, this is the fully qualified path to the staged file in the form `@db.schema.stage/spec_path`. For models loaded from a semantic view, this is the name of the view.
`tables_referenced`	VARIANT	An array containing the fully qualified names of all tables referenced by Cortex Analyst.
`request_id`	VARCHAR	The internal/system-generated identifier for the request.
`user_id`	VARCHAR	The Snowflake identifier for the user that sent the request.
`source`	VARCHAR	A JSON object containing metadata about the request source. This object has the following fields: `agent_request_id`: Internal/system-generated identifier for the agent request that generated this request, if any
`generated_sql`	VARCHAR	The SQL statement generated by Cortex Analyst in response to the request’s question.
`latest_question`	VARCHAR	The most recent question sent as part of the request.
`request_body`	VARIANT	The full body of the HTTP request. For the structure of this object, see Request body.
`response_body`	VARIANT	The full body of the HTTP response. For the structure of this object, see Non-streaming response.
`response_status_code`	NUMBER	The HTTP response code returned to the client.
`warnings`	VARIANT	The list of warnings from Cortex Analyst about the request.
`primary_role_name`	VARCHAR	The name of the role that created the semantic model used in the request.
`response_metadata`	VARIANT	Metadata containing the response generation details for the request
`feedback`	ARRAY	Array of objects that contain information for all feedback associated with the request. Feedback objects are identical to the REST API call request body as described in Send feedback.