SpecStream for Snowflake Cortex Agents Deep Search
SpecStream is the live web data engine for teams and agents. One SQL script gives a Cortex Agent three custom tools that price a Deep Search, start it after the user approves the maximum, and read the rows as a table with a Source column, through Snowflake's External Access.
What you get
- Approved in the chat
- The agent shows how it read the request and the most it can cost, and starts the search only after the user says yes.
- The amount stays fixed
- The quote waits in a Snowflake table, so the model cannot change the amount it approves.
- A table with its sources
- read_deep_search returns the rows as one Markdown table, with the page each row was read on.
Set it up
- Create a SpecStream API key with Authorize paid work and a total spending limit.
- Run the setup SQL as ACCOUNTADMIN: External Access, the quote table, two procedures and one function.
- Create the agent from the spec in the guide, then ask for rows 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 Deep Search.
Ask in your own words for companies, places, people, filings or anything else the web lists.