Pulling Data from Google Fit

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.