架构：: LOCAL

CORTEX_ANALYST_REQUESTS_V 视图¶

CORTEX_ANALYST_REQUESTS_V 视图显示 Cortex Analyst 请求日志数据。

Columns¶

`timestamp`	TIMESTAMP_NTZ	The time the request was received.
`semantic_model_type`	VARCHAR	The data that was used to provide the semantic model. 该值是以下值之一： `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`. 对于从语义视图加载的模型，这是视图的名称。
`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. 该对象具有以下字段： `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 请求正文.
`response_body`	VARIANT	The full body of the HTTP response. For the structure of this object, see 非流式传输响应.
`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	包含请求响应生成详细信息的元数据
`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 发送反馈.