Cortex Intelligence Agent

The CLINICOGENOMICS_AGENT is a Snowflake Cortex Analyst-powered AI agent that lets you query the data warehouse using natural language. It is backed by 48 semantic views that define the data model, dimensions, measures, and synonyms.

What it is

Instead of writing SQL, you ask a question in plain English and the agent generates and runs the query against the semantic layer. It is best for quick aggregation questions; for guaranteed reproducibility, use direct SQL.

How to access

1. Open Snowsight (app.snowflake.com).
2. Navigate to AI & ML → Intelligence in the left sidebar.
3. Select CLINICOGENOMICS_AGENT from CLINICOGENOMICS.LIMS_PUB.
4. Type your question in natural language.

Example prompts

• “How many patients are in the Vertex sponsored cohort?”
• “Show me the monthly trend of OH biweekly deliveries in 2025.”
• “What are the top 10 providers by case volume in the APOL1 cohort?”
• “Compare patient counts across all oncology cohorts.”

Known limitations

• Results may vary between identical prompts (non-deterministic AI).
• Complex multi-join queries may time out or return incomplete results.
• For guaranteed reproducibility, use direct SQL queries instead.