Can an AI tell a rivalry's story without inventing the score?

Short summary

A weekend project called Rivalry Engine that runs entirely in Snowflake: it reads 150 years of national football match data, computes rivalry heat scores and Elo predictions in SQL, and uses Cortex to narrate the story without inventing facts. The key design rule is that AI interprets the shape of a rivalry but never produces numbers — all counts, dates, and scores come from SQL. Teams that never met get an honest empty state instead of a fabricated narrative.

• •Rivalry Engine runs entirely in Snowflake using SQL for facts and Cortex for narrative
• •Core design rule: AI interprets but never invents numbers — all data computed in SQL
• •Includes Elo-based match prediction and Cortex Analyst for natural-language queries

Generated with AI, which can make mistakes.