To build ELT data pipelines for chess.com players
Chess.com is a popular online website that chess players play chess for fun or training.
It offers official API from where developers can fetch data about player profiles, game history and etc.
This project is to fetch chess.com data of chess learners of a local chess club, so that tutors can monitor, understand and make decisions on player performance data.
This diagram illustrate how does the whole pipeline looks like. For this repo, the work focuses on the ELT steps.
Player id - str
Player username - str
Player chess.com - str
Player id - str foreign key
Player score - int
Score type - str
Score update time - timestamp
Player id - str foreign key
Game id - str foreign key
Start time - timestamp
End time - timestamp
Game type - str
Is white - boolean
Result - str
Number of moves - int
Start rating white - int
End eating white - int
Start rating black - int
End rating black - int
Game id - str foreign key
Move number - int
White move - str
Black move - str