Statuspage

Tables in the Statuspage connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	components	14		Full Refresh
2	pages	45		Full Refresh
3	subscribers_histogram_by_state	5		Full Refresh
4	subscribers	15		Full Refresh
5	incidents	30		Full Refresh
6	incident_templates	9		Full Refresh
7	metrics	18		Full Refresh

Table: components

No	Column Name	Type	Notes
1	created_at	VARCHAR
2	description	VARCHAR
3	page_id	VARCHAR
4	updated_at	VARCHAR
5	group_id	VARCHAR
6	name	VARCHAR
7	showcase	BOOLEAN
8	only_show_if_degraded	BOOLEAN
9	automation_email	VARCHAR
10	id	VARCHAR
11	position	INTEGER
12	group	BOOLEAN
13	status	VARCHAR
14	start_date	VARCHAR

Table: pages

No	Column Name	Type	Notes
1	country	VARCHAR
2	hero_cover	VARCHAR
3	css_link_color	VARCHAR
4	activity_score	DOUBLE
5	allow_sms_subscribers	BOOLEAN
6	city	VARCHAR
7	branding	VARCHAR
8	twitter_username	VARCHAR
9	transactional_logo	VARCHAR
10	created_at	VARCHAR
11	ip_restrictions	VARCHAR
12	page_description	VARCHAR
13	css_yellows	VARCHAR
14	css_graph_color	VARCHAR
15	css_reds	VARCHAR
16	css_no_data	VARCHAR
17	support_url	VARCHAR
18	favicon_logo	VARCHAR
19	updated_at	VARCHAR
20	notifications_email_footer	VARCHAR
21	allow_incident_subscribers	BOOLEAN
22	id	VARCHAR
23	notifications_from_email	VARCHAR
24	state	VARCHAR
25	headline	VARCHAR
26	css_blues	VARCHAR
27	css_body_background_color	VARCHAR
28	allow_email_subscribers	BOOLEAN
29	css_oranges	VARCHAR
30	hidden_from_search	BOOLEAN
31	time_zone	VARCHAR
32	css_light_font_color	VARCHAR
33	url	VARCHAR
34	viewers_must_be_team_members	BOOLEAN
35	allow_webhook_subscribers	BOOLEAN
36	twitter_logo	VARCHAR
37	domain	VARCHAR
38	name	VARCHAR
39	css_greens	VARCHAR
40	email_logo	VARCHAR
41	subdomain	VARCHAR
42	css_border_color	VARCHAR
43	css_font_color	VARCHAR
44	allow_page_subscribers	BOOLEAN
45	allow_rss_atom_feeds	BOOLEAN

Table: subscribers_histogram_by_state

No	Column Name	Type	Notes
1	integration_partner	VARCHAR
2	webhook	VARCHAR
3	slack	VARCHAR
4	sms	VARCHAR
5	email	VARCHAR

Table: subscribers

No	Column Name	Type	Notes
1	obfuscated_channel_name	VARCHAR
2	components	VARCHAR
3	display_phone_number	VARCHAR
4	quarantined_at	VARCHAR
5	created_at	VARCHAR
6	skip_confirmation_notification	BOOLEAN
7	page_access_user_id	VARCHAR
8	mode	VARCHAR
9	endpoint	VARCHAR
10	purge_at	VARCHAR
11	phone_country	VARCHAR
12	phone_number	VARCHAR
13	id	VARCHAR
14	email	VARCHAR
15	workspace_name	VARCHAR

Table: incidents

No	Column Name	Type	Notes
1	scheduled_auto_in_progress	BOOLEAN
2	monitoring_at	VARCHAR
3	components	VARCHAR
4	metadata	VARCHAR
5	created_at	VARCHAR
6	scheduled_for	VARCHAR
7	postmortem_published_at	BOOLEAN
8	page_id	VARCHAR
9	updated_at	VARCHAR
10	auto_transition_to_maintenance_state	BOOLEAN
11	id	VARCHAR
12	scheduled_auto_completed	BOOLEAN
13	auto_transition_deliver_notifications_at_start	BOOLEAN
14	shortlink	VARCHAR
15	impact_override	VARCHAR
16	scheduled_remind_prior	BOOLEAN
17	impact	VARCHAR
18	postmortem_body	VARCHAR
19	postmortem_body_last_updated_at	VARCHAR
20	auto_transition_to_operational_state	BOOLEAN
21	postmortem_notified_twitter	BOOLEAN
22	postmortem_notified_subscribers	BOOLEAN
23	resolved_at	VARCHAR
24	postmortem_ignored	BOOLEAN
25	name	VARCHAR
26	incident_updates	VARCHAR
27	auto_transition_deliver_notifications_at_end	BOOLEAN
28	scheduled_until	VARCHAR
29	scheduled_reminded_at	VARCHAR
30	status	VARCHAR

Table: incident_templates

No	Column Name	Type	Notes
1	components	VARCHAR
2	update_status	VARCHAR
3	group_id	VARCHAR
4	name	VARCHAR
5	id	VARCHAR
6	title	VARCHAR
7	body	VARCHAR
8	should_tweet	BOOLEAN
9	should_send_notifications	BOOLEAN

Table: metrics

No	Column Name	Type	Notes
1	reference_name	VARCHAR
2	y_axis_hidden	BOOLEAN
3	display	BOOLEAN
4	most_recent_data_at	VARCHAR
5	created_at	VARCHAR
6	backfilled	BOOLEAN
7	y_axis_max	DOUBLE
8	suffix	VARCHAR
9	metrics_provider_id	VARCHAR
10	decimal_places	INTEGER
11	updated_at	VARCHAR
12	name	VARCHAR
13	id	VARCHAR
14	y_axis_min	DOUBLE
15	tooltip_description	VARCHAR
16	backfill_percentage	INTEGER
17	metric_identifier	VARCHAR
18	last_fetched_at	VARCHAR

External Resources

• Statuspage.io Api
• Here

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.