How tonysk8cr/steamgamesdata works
SteamData is a small Python ETL application for Steam game data: its runtime entry point obtains a PostgreSQL connection, reads a CSV, filters invalid rows, and loads the cleaned data. The graph preserves each core ETL module and the SQL schema file. The README provides no capability details, and the SQL file was not excerpted, so its relationship to the runtime is left unverified.
Main entry points: main.py ETL entry point · Extract.py CSV extraction · Load.py Row loading · DataBase.py DB connection
Components 9
ETL Runtime
- ETL entry point
SteamData/src/steamdata/main.py - CSV extraction
SteamData/src/steamdata/Extract.py - Data cleaning
SteamData/src/steamdata/Transform.py - Row loading
SteamData/src/steamdata/Load.py
Database
- DB connection
SteamData/src/steamdata/DataBase.py - Table schema
SteamData/src/postgrequery/tablecreation.sql
Other components
- Operator
- Games CSV
- PostgreSQL
Connections 9
- Operator → ETL entry point: runs
- ETL entry point → DB connection: opens connection
SteamData/src/steamdata/main.py - DB connection → PostgreSQL: connects to
SteamData/src/steamdata/DataBase.py - ETL entry point → CSV extraction: calls extraction
SteamData/src/steamdata/main.py - CSV extraction → Games CSV: reads CSV
SteamData/src/steamdata/Extract.py - ETL entry point → Data cleaning: cleans rows
SteamData/src/steamdata/main.py - ETL entry point → Row loading: loads cleaned rows
SteamData/src/steamdata/main.py - Row loading → PostgreSQL: inserts rows
SteamData/src/steamdata/Load.py - Table schema → PostgreSQL: defines table