Dev.to
7/12/2026
FERVOR: A Snowflake-to-Solana pipeline for real-time World Cup fan conviction scoring
Original: We Taught a Snowflake Warehouse to Judge World Cup Conviction and Write the Verdict Back to Solana
Short summary
A hackathon project builds FERVOR, a real-time conviction oracle for World Cup fandom that reads Solana on-chain swap data into Snowflake, computes conviction scores using Cortex ML models, and writes the results back to a Solana devnet oracle account. The six-stage pipeline uses Helius for transaction decoding, Snowflake Dynamic Tables for declarative transforms, and Streamlit-in-Snowflake for serving analytics. Argentina leads with 109 average days held per wallet.
- •FERVOR pipeline: Solana mainnet → Snowflake ingest/transform/ML → Solana devnet oracle write-back
- •Six-stage architecture using Helius, Dynamic Tables DAG, Cortex ML, and Anchor signing bridge
- •Conviction scoring based on wallet holding duration across 16 tracked country tokens
Generated with AI, which can make mistakes.
Is this a good recommendation for you?
