stevenschmatz/oura-ring-api-etl

Load data from the Oura Ring API into a personal data warehouse

Oura Ring API ETL

The Oura Ring is a powerful sleep and activity tracker. This project uses the Oura Ring API to load all of the previous day's sleep, readiness, and activity data, and stores it in a custom data warehouse.

Installation

Note that this project requires Python 3.

Installing prerequisites

virtualenv env
source env/bin/activate
pip install -r requirements.txt

Set up the data warehouse

The included file setup_tables.sql contains SQL commands for creating database tables that can store Oura data. Note that it uses some features specific to PostgreSQL.

Create a launch script

Fill in the information in run_etl.sh, which involves your Oura and database credentials.

Usage

./run_etl.sh

oura-ring-api-etl's Issues

Discontinuation of Oura API V1, support of V2 endpoints

Hi, I just wanted to let this project's maintainer know, Oura has announced that the V1 version of their API, which this project is using, will be discontinued in Jan 2024, after which it will no longer be available.

There is a V2 version of the API available, which is documented here: https://cloud.ouraring.com/v2/docs