Oura

Tables in the Oura connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	daily_readiness	6
2	sessions	8
3	workouts	9
4	sleep_periods	25
5	heart_rate	3		Full Refresh
6	daily_activity	25		Full Refresh
7	daily_sleep	4
8	tags	4

Table: daily_readiness

No	Column Name	Type	Notes
1	score	DOUBLE
2	temperature_deviation	DOUBLE
3	temperature_trend_deviation	DOUBLE
4	contributors	VARCHAR
5	day	VARCHAR
6	timestamp	VARCHAR

Table: sessions

No	Column Name	Type	Notes
1	mood	VARCHAR
2	start_datetime	VARCHAR
3	end_datetime	VARCHAR
4	heart_rate	VARCHAR
5	type	VARCHAR
6	day	VARCHAR
7	heart_rate_variability	VARCHAR
8	motion_count	VARCHAR

Table: workouts

No	Column Name	Type	Notes
1	intensity	VARCHAR
2	activity	VARCHAR
3	distance	DOUBLE
4	end_datetime	VARCHAR
5	start_datetime	VARCHAR
6	calories	DOUBLE
7	label	VARCHAR
8	source	VARCHAR
9	day	VARCHAR

Table: sleep_periods

No	Column Name	Type	Notes
1	average_heart_rate	DOUBLE
2	sleep_score_delta	DOUBLE
3	rem_sleep_duration	DOUBLE
4	latency	DOUBLE
5	time_in_bed	DOUBLE
6	average_hrv	DOUBLE
7	restless_periods	DOUBLE
8	type	VARCHAR
9	deep_sleep_duration	DOUBLE
10	lowest_heart_rate	DOUBLE
11	movement_30_sec	VARCHAR
12	day	VARCHAR
13	bedtime_end	VARCHAR
14	light_sleep_duration	DOUBLE
15	efficiency	DOUBLE
16	period	DOUBLE
17	heart_rate	VARCHAR
18	low_battery_alert	BOOLEAN
19	hrv	VARCHAR
20	total_sleep_duration	VARCHAR
21	average_breath	DOUBLE
22	sleep_phase_5_min	VARCHAR
23	bedtime_start	VARCHAR
24	readiness_score_delta	DOUBLE
25	awake_time	DOUBLE

Table: heart_rate

No	Column Name	Type	Notes
1	source	VARCHAR
2	bpm	DOUBLE
3	timestamp	VARCHAR

Table: daily_activity

No	Column Name	Type	Notes
1	active_calories	DOUBLE
2	sedentary_met_minutes	DOUBLE
3	high_activity_met_minutes	DOUBLE
4	inactivity_alerts	DOUBLE
5	resting_time	DOUBLE
6	medium_activity_met_minutes	DOUBLE
7	score	DOUBLE
8	medium_activity_time	DOUBLE
9	low_activity_met_minutes	DOUBLE
10	sedentary_time	DOUBLE
11	met	VARCHAR
12	day	VARCHAR
13	equivalent_walking_distance	DOUBLE
14	timestamp	VARCHAR
15	low_activity_time	DOUBLE
16	class_5_min	VARCHAR
17	total_calories	DOUBLE
18	target_calories	DOUBLE
19	target_meters	DOUBLE
20	meters_to_target	DOUBLE
21	steps	DOUBLE
22	high_activity_time	DOUBLE
23	non_wear_time	DOUBLE
24	average_met_minutes	DOUBLE
25	contributors	VARCHAR

Table: daily_sleep

No	Column Name	Type	Notes
1	score	DOUBLE
2	contributors	VARCHAR
3	day	VARCHAR
4	timestamp	VARCHAR

Table: tags

No	Column Name	Type	Notes
1	text	VARCHAR
2	day	VARCHAR
3	timestamp	VARCHAR
4	tags	VARCHAR

External Resources

• Oura
• Oura Developer Portal

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.