analyst_agentic_optimizations
Creates, updates, deletes, gets or lists an analyst_agentic_optimizations resource.
Overview
| Name | analyst_agentic_optimizations |
| Type | Resource |
| Id | snowflake.cortex.analyst_agentic_optimizations |
Fields
The following fields are returned by SELECT queries:
- get
OK. Retrieved optimization.
| Name | Datatype | Description |
|---|---|---|
request_id | string | Unique request ID (example: abcd1234-5678-90ab-cdef-1234567890ab) |
outcome | string | An opaque string containing the outcome of the optimization, separate from the state. This should be the JSON-encoded form of an AgenticOptimizationOutcome protobuf message. (example: {"extensions": ""}) |
state | string | An opaque string containing the state of the optimization. (example: {"progress": 0.5, "details": "Halfway through the optimization"}) |
status | string | The status of an agentic optimization run. (IN_PROGRESS, COMPLETED, FAILED, CANCELED) |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | optimization_name, endpoint | Get the status and state of a specified agentic optimization run | |
list_agentic_optimizations | exec | endpoint, semantic_model | List all agentic optimization runs for a given base model |
Parameters
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
endpoint | string | Organization and account identifier (orgname-accountname) (default: orgname-accountname) |
optimization_name | string | The fully-qualified name of the optimization to retrieve. |
SELECT examples
- get
Get the status and state of a specified agentic optimization run
SELECT
request_id,
outcome,
state,
status
FROM snowflake.cortex.analyst_agentic_optimizations
WHERE optimization_name = '{{ optimization_name }}' -- required
AND endpoint = '{{ endpoint }}' -- required
;
Lifecycle Methods
- list_agentic_optimizations
List all agentic optimization runs for a given base model
EXEC snowflake.cortex.analyst_agentic_optimizations.list_agentic_optimizations
@endpoint='{{ endpoint }}' --required
@@json=
'{
"semantic_model": "{{ semantic_model }}",
"experimental": "{{ experimental }}"
}'
;