Skip to the page

SpecStream for Snowflake Cortex Agents

SpecStream is the live web data engine for teams and agents. One SQL script gives a Cortex Agent two custom tools, web_search and read_pages, that call SpecStream's Search API and Extract API through Snowflake's External Access.

What you get

Answers with their page
web_search returns an answer with the page it was read from and the time it was read, and every result with its URL and published date.
The same call in SQL
Both tools are scalar functions that return VARIANT, so a SELECT can search or read pages for every row of a table.
A limit on the key
The key stays in a Snowflake secret and carries its own spending limit. Every call is in your SpecStream request log.

Set it up

  1. Get a SpecStream key on the Search API screen of your workspace.
  2. Run the setup SQL as ACCOUNTADMIN: the network rule, the secret, the External Access Integration and the two functions.
  3. Create the agent from the spec in the guide, then ask in the agent playground under AI & ML, Agents.

The full setup guide has every step, with what to do if something doesn’t arrive.

Live web data, in Snowflake Cortex Agents.

Ask in your own words for companies, places, people, filings or anything else the web lists.