I've started using Meltano to show how much sleep ...
# random
a
I've started using Meltano to show how much sleep I'm getting. Turns out I'm probably not getting enough! 😅
s
hah nice, whats the pipeline like?
a
Just a simple one - I use the Oura ring to track sleep and I wrote a custom tap to get data from the API. The pipeline runs every morning to get the previous night's data
It'd be more interesting to combine this with other data to see what might be affecting the amount of sleep 🙂
s
sick! is the tap open source? just curious
been meaning to buy an Oura…
j
Get some sleep Al !
a
@srini_kadamati__apache_superset_ yep it's here: https://github.com/allanw/tap-oura Warning though, it's pretty rough - just threw it together quickly! The only config required is a
start_date
and the access key. It doesn't maintain state yet or anything, I've only had the Oura ring for a week or two so currently haven't got much data, it just does a full table reload each time
@john_scott haha if only working on personal projects and getting sleep weren't mutually exclusive
c
Love projects like this! Would be nice if there was a curated list of how folks are using Meltano for personal projects...also like the fact that oura allows customers to export their data, apparently Apple watch stores similar data but exporting it is a pain
s
yeah Apple takes privacy quite seriously, so all Health data is stored encrypted on your iPhone itself. You can export it as CSV and it takes minutes to do so and dump it into Dropbox or something. There are apps that will oauth / can get you API access to this data (which then the app can do w/e it wants to with it.) Maybe there should be a Meltano app that acts as the native oauth ‘bridge’ to push data out for Apple services 😛
d
@al_whatmough Super cool! Would you like to do a guest blog post on this? 😄
a
@chester A curated list of Meltano projects is a great idea! I'd happily contribute to that 👍
d
@al_whatmough I was thinking about a blogpost that could be referenced from such a curated list, but simply having a list of open source Meltano projects with detailed READMEs would work as well!
a
@douwe_maan I'd be happy to do a blog post too if that would be of interest! I've been enjoying working with Meltano for this type of 'personal analytics', I've definitely got more to explore but I could write up what I've been doing so far 🙂
d
@al_whatmough I think that'd be fun! Up to you if you think you're ready, or if you'd like to wait until (for example)
tap-oura
is more production-ready with a readme and OOTB support in Meltano etc 🙂
a
@douwe_maan I'll tidy that repo up a bit for sure and then get something together in the next few days. I haven't had chance to test it out yet but it's also worth keeping an eye on https://github.com/anelendata/tap-rest-api - I was wondering if that could remove the need to write specific taps for each API
d
Sounds good! tap-rest-api is definitely cool, but I'm a bit skeptical about its general applicability since I've never seen 2 REST APIs that actually behaved consistently beyond the surface level...
n
@al_whatmough what a cool project.. It is inspiring me to build a tracker for my garmin and correlate my sleep with my productivity. 🤔
a
@nehil_jain Awesome! I was also doing something with pulling data out of my Garmin, haven't got it on a dashboard yet but I was playing with some running data. Maybe we can help each other out on this 😀
n
sounds fun
f
Hi, folks! Jumping in this 3-year-old thread after finding it on search 😄 I’ve been tinkering a bit with health data in the last months, and it’s been a very cool experience. I put a first version of https://github.com/felippecaso/tap-applehealth together just recently that would be really open for testing and contributions I hope to continue having this conversation going on in the community! On Friday I’ll also share some thoughts about this at the MDS Fest and it would be awesome to see you there 😃