CloudQuery News

Introducing the new StatusPage source plugin

What is StatusPage?

StatusPage is a service from Atlassian that allows businesses to communicate to their customers about the status of their services. It provides a platform to create a status page where businesses can post updates about incidents, scheduled maintenance, and the overall status of their services. This helps in maintaining transparency with customers and reduces support tickets during incidents.

Why StatusPage + CloudQuery?

The StatusPage source plugin allows you to perform advanced data filtering and grouping without relying on restrictive UI filters. It also makes it easier to access parts of data that would not be possible to reach through UI.

The CloudQuery StatusPage source plugin supports fetching the following resources:

Use cases

Let's take a look at a few examples that show how you can use the StatusPage source plugin to analyze and uncover overdue problems, prioritize the most pressing ones, and get insights into what is most important for your users.

In all of these examples we assume the data was synced from StatusPage source to a PostgreSQL destination plugin.

Long running incidents

Lets check for any unresolved issues that have been ongoing for more than 7 days.

select id as incident_id,
page_id,
created_at,
updated_at
from statuspage_page_incidents
where status in ('investigating', 'identified')
and resolved_at is null
and created_at <= now() - interval '7 days';

Most subscribed active incidents

Maybe you want to check which active StatusPage incidents are most subscribed by users?

select
incidents.id as incident_id,
incidents.page_id,
incidents.created_at,
incidents.updated_at,
count(subscribers._cq_parent_id) as subscriber_count
from statuspage_page_incidents as incidents
left join statuspage_page_incident_subscribers as subscribers
on incidents._cq_id = subscribers._cq_parent_id
where incidents.status in ('investigating', 'identified')
and incidents.resolved_at is null
group by incidents.id
order by subscriber_count desc;

All users with access to certain page

With the StatusPage plugin from CloudQuery, it's possible to get all users that have access to a page with a certain id.

select
users.*,
elem->>'page_id' as page_id
from
statuspage_users as users
join
statuspage_user_permissions as sup on users.id = sup.user_id,
unnest(sup.pages::jsonb[]) as elem
where
elem->>'page_id' = 'your_page_id';

Functioning of which pages is most important to the users?

Let's order pages by their subscriber count.

select
pages.id as page_id,
count(subscribers._cq_parent_id) as subscriber_count
from
statuspage_pages as pages
left join
statuspage_page_subscribers as subscribers
on
pages._cq_id = subscribers._cq_parent_id
group by
pages.id
order by
subscriber_count desc;

Getting Started

To get started syncing StatusPage data, see the StatusPage source plugin documentation for instructions.


Want to see CloudQuery in action? Schedule a demo with our team or check out the platform documentation to learn more.

Got feedback or suggestions? Join the CloudQuery community to connect with other users and experts, or message our team directly here if you have any questions.

Try CloudQuery yourself

Self-hosted, open source, and free to start. Or schedule a demo to see the managed version.

Related posts

CloudQuery News

Introducing CloudQuery Insights: Cloud Intelligence That Connects the Dots

CloudQuery Insights automatically surfaces connected signals across your cloud inventory: security findings, cost data, policy violations, and audit trails.

Joe Karlsson

Joe Karlsson

April 21, 2026

Cloud Infrastructure

CloudQuery News

Introducing the Nautobot Source Integration

Sync Nautobot DCIM inventory data to PostgreSQL, BigQuery, or Snowflake and query it with SQL alongside your cloud provider data.

Joe Karlsson

Joe Karlsson

March 19, 2026

CloudQuery News

CloudQuery Is Merging with Env Zero

A letter from CloudQuery CEO Yevgeny Pats on the merger with env zero and what it means for customers.

Yevgeny Pats

Yevgeny Pats

March 17, 2026

CloudQuery News

Security

Introducing the Zoom Source Integration

New CloudQuery Zoom source plugin: sync Zoom meeting, user, and webinar data into your database for compliance, analytics, and user access governance reporting.

Joe Karlsson

Joe Karlsson

February 2, 2026

CloudQuery News

Product News

New in CloudQuery: Tines + Semgrep integration, and native visualizations,

CloudQuery October 2025 updates: Tines and Semgrep integration for security orchestration, plus native visualization support in the CloudQuery Platform.

Chris Reuter

Chris Reuter

October 31, 2025

CloudQuery News

Product News

Security

Introducing Data Access Control for CloudQuery Platform

CloudQuery Platform RBAC: Control cloud asset access with SQL-based permissions. Map Azure AD/Okta groups to roles. Available now on all environments.

Joe Karlsson

Joe Karlsson

October 28, 2025

AI

CloudQuery News

Understand your cloud infra faster using natural language

CloudQuery unifies AWS, GCP, Azure, and SaaS configs into SQL tables. The new AI assistant lets you query your cloud inventory using natural language.

Chris Reuter

Chris Reuter

September 29, 2025

CloudQuery News

Find the Cloud Waste Contest

Win CloudQuery swag by finding cloud waste in our dataset. Sync AWS data with CloudQuery, solve 3 SQL challenges, get t-shirts, sweatshirts, and mugs.

Joe Karlsson

Joe Karlsson

September 25, 2025

AI

CloudQuery News

Generate CloudQuery Configuration with Natural Language

Generate CloudQuery config files from natural language prompts. Use AI to quickly create source and destination plugin configs without manual YAML editing.

Chris Reuter

Chris Reuter

September 23, 2025

Own your pipeline.
Own your data.