Snowflake Statements API Reference
The connector uses the Snowflake Statements API to query AI assets and usage data. The following queries are executed during discovery and usage collection.
Asset Discovery Queries
| Query | Description |
| Show Accounts | Retrieves a list of all Snowflake accounts accessible with the provided credentials. |
| Show Agents | Discovers all AI agents configured in your Snowflake account. |
| Describe Agent | Retrieves comprehensive metadata for a specific agent, including configuration, capabilities, and runtime parameters. |
| Query Model Versions | Retrieves detailed version history and metadata for AI models from the information schema. |
| Describe Model | Fetches comprehensive model metadata including type, ownership, version information, and configuration. |
| Describe Fine-Tuning Job | Retrieves status, metrics, and output details for completed fine-tuning jobs. |
Usage Analytics Query
The connector queries the SNOWFLAKE.LOCAL.AI_OBSERVABILITY_EVENTS table to collect AI agent usage data.
This query analyzes usage within a specified time window and returns the following data:
- Session IDs
- Agent names
- Users
- Database and schema names
- Request counts