Rivalry Engine uses Snowflake and AI to narrate football history without fabricating facts
A developer built 'Rivalry Engine,' a Snowflake-based app that analyzes 150 years of national football match data to characterize rivalries between any two countries. The tool calculates a heat score, classifies the rivalry's shape, and uses Snowflake's Cortex AI to generate a narrative — but only from facts computed via SQL. A key design rule prevents Cortex from ever producing a number itself, ensuring all statistics come from verified match data. If two nations have never played each other, the app returns an honest 'first chapter unwritten' card instead of generating speculative content. The entire stack — data, analytics, AI, and front-end — runs within Snowflake's Streamlit environment, with nothing leaving the warehouse.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.



Discussion (0)
Log in to join the discussion and vote.
Log in