Create a Python test framework for data testing across multiple data sources

I am looking for some help in developing a python test framework, that aids in testing data across multiple frameworks:

1) AWS - Redshift
2) AWS - S3
3) GCP - Big Query
4) GCP - data store

Attached is the first piece of the package requirement. First we will start with the connection methods for the databases listed in the document.
I have provided detail in section a), b), c) as well
Also tried to provide some pseudo code on how the package will be used.

Please review the document and let me know things that are not clear.