So the next project for me will be to integrate step counts from Google Fit. Given my improved knowledge and understanding of the tools and infrastructure I am using can working out how I am going to do this and use this data before I start.
The first step was connecting to the Google Fit API and extraction the relevant data. I will admit that I did the standard developer trick and followed an online guide / stackoverflow to get this done, my main source was the link attached.
My next steps will be:
- Use Keboola to connect and load the Google Sheet as in In Job
- As an Out job deposit the data into Snowflake.
- Use dbt to transform and load the data into the final star schema.
- At very least number of k of steps / day would be good to have on in my exercise fact tables. If I integrate this early enough and in enough places it will test a lot of by dbt understanding if nothing else.
- As part of this I am going to also create a proper date dimension and integrate another new sheet with categories and calendar entries. Going forwards this will have a form front end.
- I want this so I can note that I paced someone at parkrun or run with the dog.
- Will also be good to put strength totals and step totals next to each other.
Comments
Post a Comment