Summit 26 from June 1-4 in San Francisco

Lead your organization in the era of agents and enterprise intelligence.

Snowflake for DevelopersGuidesOlympic Games Analytics using Notebook and Streamlit

Olympic Games Analytics using Notebook and Streamlit

Matteo Consoli

Overview

This solution architecture shows how to use The Olympic Games Data Hub to explore, analyze and visualize Olympic games data. 

  • Ingest data from GitHub into Snowflake tables.
  • Perform statistical analysis on the Olympic games dataset
  • Streamlit app for exploring and visualizing the Olympic Games data from 1896 to 2022.

Solution Architecture: Olympic Games Analytics

Architecture Diagram

The Olympic Games Data Hub consists of the following components:

  • setup.sql: Script to set up the database, schema, warehouse, and external access integration.
  • olympic_games_ingest_explore.ipynb: Notebook to fetch data from GitHub and push it into Snowflake tables.
  • olympics_games_data_hub.py: Streamlit app for exploring and visualizing the Olympic Games data.
  • dataset: folder containing csv dataset that will be uploaded in your Snowflake account.

Get Started

Updated 2026-04-29

This content is provided as is, and is not maintained on an ongoing basis. It may be out of date with current Snowflake instances