Contents
Five documents, one pipeline
Each page stands on its own — start anywhere, or read them in order for the full picture of the SCM Assistant Agent and the data behind it.
Capability Overview
What the SCM Assistant Agent is, who it's for, what it can do across purchasing, delivery, demand planning, and inventory, how it structures its answers, and its known limitations.
Open →Architecture Diagram
End-to-end platform view: raw data ingestion, Snowpark transformation, semantic views, the Cortex AI orchestrator and sub-agents, and Snowflake Horizon Catalog governance.
Open →ER Diagram & Data Dictionary
Every table and column across RAW, RAW_TRUSTED, STAGING, CURATED, AGGREGATE, and SEMANTIC, plus the CURATED star-schema relationship diagram.
Open →Business Rules, Data Assumptions & Personas
52 business-validated query & interpretation rules, 10 data assumptions, pipeline-level construction rules, and the persona roles the SCM Assistant Agent is scoped for.
Open →Evaluation Report
Full 160-question evaluation run — accuracy, consistency, latency, root-cause failure analysis, and every individual test case with ground truth and generated SQL.
Open →