cotera

Run from Snowflake

If your data lives in Snowflake, agents can come to it. The Cotera Native App lets you call an agent per row from plain SQL (enrich prospects, classify records, summarize text) with results landing right back in your query.

For the full story, see the Snowflake integration page.

Install

  1. In Snowflake, open the Marketplace and search for Cotera, then click Get.
  2. Approve outbound network access to app.cotera.co (requires an admin).
  3. In Cotera, create an API key and store it as a secret in the app's setup.

Run an agent from SQL

SELECT
  company_name,
  cotera.agents.agent(
    agent_id => 'your-agent-id',
    input => object_construct('company_name', company_name)
  )::VARCHAR AS enrichment
FROM companies
WHERE status = 'prospect';

Each row becomes one agent run: durable, retried on failure, and able to use every tool the agent has (Salesforce, Slack, the web) even though it was called from SQL.

Things to know

  • Create and test the agent in Cotera first; you reference it by ID from SQL.
  • Give the agent structured output and results come back as parseable JSON rather than prose.
  • This is the reverse direction from connecting Snowflake as a warehouse (which feeds Snowflake data into Cotera datasets). The two work well together.