Each season's folder contains subfolders and notebooks for collecting, relating, and loading that season's data into the database.
All the folders would follow a similar structure. Doing it this way helps me stick to the process I used for the first iteration of the database, as well as create breakpoints between the seasons' updates.
I'll call the functions I need from the list of function script as putting their code here would make the notebook too long.
I'll use conditional overwrites for each season to update the database. This would make it easy to update a season's data whether monthly, or even weekly.
I'm using the sandbox version of BigQuery so as I can't use the regular method of making updates, the actual overwritinng would be done with SQL queries.