Snowflake SQL API
✓ Official Vendor SpecDeveloper ToolsSource Controlbearer, oauth23 EndpointsREST
For Agents
Programmatically submits a sql statement for execution., checks the status of the execution of a statement. Covers 3 operations with bearer, oauth2 authentication.
Use for: I need to submits a sql statement for execution., I want to checks the status of the execution of a statement, Search for cancels the execution of a statement., List all records from Snowflake SQL API
Not supported: Does not handle payments, communications, or crm — use for developer tools only.
The Snowflake SQL API is a REST API that you can use to access and update data in a Snowflake database. The API exposes 3 endpoints secured with bearer, oauth2 authentication.
Install Jentic One Beta
Connect the Snowflake SQL API to your agent
Jentic One is a self-hosted execution layer for AI agents. It lets your agent call the Snowflake SQL API, or any other public or private API you need. You set the rules, the agent never sees your credentials, and every call is logged.
Two steps, two machines. Install the instance in a safe environment, then register your agent from wherever it runs.
1
Step 1: Jentic One Host machine
# On the machine that will host your Jentic One instance:
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh2
Step 2: Agent machine
# On the machine where your agent runs (keep this separate from the instance):
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh
jentic register # connects your agent to your Jentic One instanceJentic One is in public beta. The setup above keeps your agent separate from the instance, which is what you want before using real credentials: an agent running as the same OS user as Jentic One can read its stored keys directly. Just evaluating? A single local install is fine to start. See the secure deployment guide for the tiers.
Capabilities
What an agent can do with Snowflake SQL API.
Submits a SQL statement for execution.
Checks the status of the execution of a statement
Cancels the execution of a statement.
Query and filter Snowflake SQL API records by parameters
Monitor Snowflake SQL API operational status and events
Use Cases
Patterns agents use Snowflake SQL API for, with concrete tasks.
★ Developer Tools Operations
Use the Snowflake SQL API to perform developer tools operations programmatically. The API provides 3 endpoints covering core functionality including submits a sql statement for execution., checks the status of the execution of a statement, cancels the execution of a statement..
Call POST /api/v2/statements to submits a sql statement for execution.
Automated Statements Management
Automate statements operations by combining multiple Snowflake SQL API endpoints. Agents can checks the status of the execution of a statement and then cancels the execution of a statement. in a single workflow.
Call GET /api/v2/statements/{statementHandle} to checks the status of the execution of a statement, then verify the result
AI Agent Integration via Jentic
AI agents discover and call Snowflake SQL API endpoints through Jentic without managing credentials directly. An agent searches for the required operation by intent, receives the matching endpoint schema, and executes the call with Jentic-managed authentication. This eliminates the need to read API documentation or handle bearer, oauth2 tokens manually.
Search Jentic for 'submits a sql statement for execution.', load the operation schema, and execute with Jentic-managed credentials
Key Endpoints
3 endpoints — the snowflake sql api is a rest api that you can use to access and update data in a snowflake database.
METHOD
PATH
DESCRIPTION
POST
/api/v2/statements
Submits a SQL statement for execution.
GET
/api/v2/statements/{statementHandle}
Checks the status of the execution of a statement
POST
/api/v2/statements/{statementHandle}/cancel
Cancels the execution of a statement.
POST
/api/v2/statements
Submits a SQL statement for execution.
GET
/api/v2/statements/{statementHandle}
Checks the status of the execution of a statement
POST
/api/v2/statements/{statementHandle}/cancel
Cancels the execution of a statement.
Why Jentic?
Three things that make agents converge on Jentic-routed access.
Credential isolation
Snowflake SQL API bearer, oauth2 credentials are stored encrypted in the Jentic vault (MAXsystem). Agents receive scoped access tokens — raw secrets never enter the agent context.
Intent-based discovery
Agents search by intent (e.g., 'submits a sql statement for execution.') and Jentic returns the matching Snowflake SQL API operation with its input schema, so the agent can call the right endpoint without browsing docs.
Time to first call
Direct Snowflake SQL API integration: 1-3 days for auth handling, response parsing, and error cases. Through Jentic: under 1 hour — search, load schema, execute.
Related APIs
Alternatives and complements available in the Jentic catalogue.
Alternative
Github
Alternative developer tools API
Choose Github when you need a different approach to developer tools operations
FAQs
Specific to using Snowflake SQL API through Jentic.
What authentication does the Snowflake SQL API use?
The Snowflake SQL API uses bearer, oauth2 authentication. Through Jentic, these credentials are stored encrypted in the MAXsystem vault and injected at execution time, so raw secrets never enter the agent context.
Can I submits a sql statement for execution. with the Snowflake SQL API?
Yes. Use the POST /api/v2/statements endpoint. The API returns structured JSON responses that agents can parse and act on directly.
What are the rate limits for the Snowflake SQL API?
Rate limits are not specified in the OpenAPI spec. Check the vendor documentation for current limits. Through Jentic, rate limiting is handled automatically with retry logic built into the execution layer.
How do I submits a sql statement for execution. through Jentic?
Install the Jentic SDK with pip install jentic, authenticate at https://app.jentic.com/sign-up, then search for 'submits a sql statement for execution.'. Jentic returns the matching Snowflake SQL API operation with its input schema. Load the schema and execute the call — credentials are injected automatically.
How many endpoints does the Snowflake SQL API have?
The Snowflake SQL API exposes 3 endpoints covering statements operations.
GET STARTED