You are required to implement a set our routine using Python Analytics API ([url removed, login to view]), and insert these data into a SQL database using SQLAlchemy ([url removed, login to view]) ORM.
You role include:
- Implement necessary authentication to retrieve access and refresh token
- Extract the data with the provided API and put into the SQL database
- Ensure adequate test coverage for the API code
- Include necessary packaging for python (e.g. [url removed, login to view], [url removed, login to view])
- Check in code into our git repository
We will provide:
- Base data framework (include SQLAlchemy classes and data API)
- Source repository, initial pairing to get setup going.
- Test GA account and setup