Snowflake API: what you can do and how to use it with AI agents
Snowflake is a cloud data warehouse accessed through SQL, with the SQL API over REST, connectors and standard drivers. Data and BI teams use it to bring together and analyze company data. Access is through a user with a defined role, authenticated by key pair or OAuth.
What the Snowflake API offers
SQL API
Running SQL commands over HTTP, with status tracking.
Queries and views
Reading tables and views prepared by the data team.
Roles and permissions
Access control by database, schema and object.
Warehouses
Compute capacity used by queries, with cost control.
Ingestion
Loading data through stages and pipes.
Data sharing
Access to data shared between accounts.
How to access the Snowflake API
- With your company’s credentialsA user with a dedicated role, authenticated by key pair (JWT) or OAuth. The SQL API accepts these methods. A read-only role on a small warehouse is recommended.
- Queries consume credits, so limit the warehouse and the run time.
- Mask columns that hold personal data.
- Prefer curated views to raw tables.
Official documentation: docs.snowflake.com/en/developer-guide/sql-api/index
What an iTeam agent does with the Snowflake API
Business question in Slack
The director asks for this month's margin by product line, and the agent queries the cleared views and replies with the number and the query.
Alert on an unusual metric
The agent runs daily queries and warns when a metric leaves its expected range.
Recurring report
The weekly close queries run automatically and become a summary for leadership.
Query cost under control
The agent tracks the consumption of the warehouse the agents use and warns when it reaches the cap.
From the credential to the agent at work, with approval
Create a dedicated user and role
The data team grants only the views needed and a small warehouse with auto-suspend.
Store it in the iTeam vault
The private key and the account stay in the vault, and access is read-only.
Test with approval
New queries are reviewed at first, and each run is recorded in the audit trail.
Ready-made AI teams that use Snowflake
Questions about the Snowflake API
Is the Snowflake API free?
There is no separate charge for the API, but queries consume compute credits under your Snowflake contract.
Do I need to code to use Snowflake with iTeam?
Not necessarily. The deployment team sets up access with your data team, and the agent writes queries within what was cleared.
Can the agent change data?
It can, if cleared, but the recommendation is to start with read-only access.
