AWS

Security

Tutorials

DORA Compliance Made Simple with CloudQuery

As the Digital Operational Resilience Act (DORA) took effect on January 17, 2025, financial institutions with operations in the EU and their third party vendors must keep a close eye on their digital infrastructure. Compliance with DORA requires maintaining an accurate, real-time inventory of all cloud assets and regular checks to ensure everything meets strict security and compliance rules. This is where CloudQuery, a developer-first cloud governance platform, steps in, turning chaotic cloud data into actionable insights.

1. Understanding DORA

DORA sets out several key requirements:

  • ICT Risk Management: Build a framework to identify, assess, and manage risks across all digital assets, including critical assets managed by third parties.
  • Rigorous Incident Reporting: Quickly detect and report any IT incidents to reduce downtime.
  • Regular Resilience Testing: Simulate disruptions to ensure systems can recover quickly.
  • Manage Third-Party Risks: Hold vendors accountable for meeting security standards.
  • Threat Intelligence Sharing: Partner with peers and regulators to stay ahead of threats.

Meeting these requirements is challenging without a centralized view of your cloud environment.

1. Why a Unified Asset Inventory Matters

DORA requires financial institutions to monitor their cloud environments continuously, keep detailed records of every digital asset and third-party service, and quickly identify and manage any vulnerabilities. A unified asset inventory is the foundation for meeting these goals. With CloudQuery, you can:

  • Automated Asset Discovery: Connect AWS, Azure, GCP, or other providers to your Cloud Asset Inventory, and CloudQuery catalogs every VM, database, and storage bucket out of the box. No more spreadsheets, custom scripts or manual tracking.
  • SQL-Powered Insights: CloudQuery transforms raw cloud data into a queryable database so you can write custom SQL queries to pinpoint issues relevant to DORA. Want to know which resources are misconfigured or have outdated security settings? A few SQL statements can provide those answers as will be shown in the upcoming sections.
  • Benchmark Against Best Practices: CloudQuery offers pre-built security and compliance policies based on standards like CIS and NIST, so you can use these policies to quickly assess your environment without having to write every query from scratch.

These features and more enable you to identify misconfigurations, unencrypted resources, or unsecured endpoints—critical steps in maintaining operational resilience under DORA.

2. Building Your Cloud Asset Inventory

To get started, schedule a demo with our team to explore the CloudQuery platform. Once, you have access to the platform, you'll connect your cloud accounts—CloudQuery supports over 60 official integrations to bring together data from all your cloud and SaaS environments into one place.

A screenshot from the CloudQuery platform showing the ‘New Integration’ page. The interface features a searchable list of integrations, including popular services like Airtable, Alibaba Cloud, AWS, Azure, Bamboo HR, and more. Each integration is categorized under labels such as ‘Cloud Infrastructure,’ ‘Engineering Analytics,’ and ‘Databases,’ highlighting the platform’s extensive support for diverse tools.

After connecting your accounts, CloudQuery automatically gathers asset data. You can then use pre-built filters to quickly check for untagged resources, filter by region or look at other metadata fields, giving you a high-level view of your cloud posture across multiple platforms.

A screenshot from the CloudQuery platform showing the ‘Asset Inventory’ interface. The left panel displays a categorized list of resources, including sections like ‘Logging,’ ‘Containers,’ ‘Databases,’ and ‘Storage,’ with specific focus on ‘Hosts’ under AWS. The main panel lists detailed information about EC2 instances, including columns for cloud provider, resource type, account, name, region, and tags. The top includes a search bar with active filters and options to save filters.

3. Identify and Manage Risk with SQL Queries

Moreover, you can use the CloudQuery’s SQL console to dig deeper into your asset data. Below are some practical query examples to help you identify potential compliance gaps:

A. Identify Publicly Accessible Resources

Finding public resources helps you secure systems that are directly exposed to the internet, which is key for managing risks and reporting incidents under DORA.

This query lists EC2 instances that have a public IP address, which may require additional security controls:

SELECT
instance_id, instance_type, public_ip_address, region
FROM
aws_ec2_instances
WHERE
public_ip_address IS NOT NULL;

B. Audit S3 Bucket Policies

Ensuring that storage buckets are secured against public access is critical for protecting sensitive financial data and meet DORA’s requirements.

This query finds S3 buckets that have overly open access policies, which might expose sensitive data:

SELECT
b.name AS bucket_name,
b.arn AS bucket_arn,
p.policy_json AS access_details
FROM
aws_s3_buckets AS b
LEFT JOIN
aws_s3_bucket_policies AS p
ON
b.arn = p.bucket_arn
WHERE
JSONExtractString(p.policy_json, 'Statement[0].Principal') = '*'
AND JSONExtractString(p.policy_json, 'Statement[0].Effect') = 'Allow';

C. Identify Untagged Resources

Tags enable accountability. Untagged resources complicate incident response and audit trails.

This query helps you find resources that are missing tags, which are important for tracking assets and bringing accountability to cloud usage and spending.

SELECT
cloud, account, name, region, resource_type
FROM
cloud_assets
WHERE
tags = '{}'
OR tags is null;
A screenshot from the CloudQuery platform displaying the SQL Console interface. The left panel shows a list of available tables, including ‘cloud assets’ under ‘Asset Inventory Tables,’ with columns such as ‘account,’ ‘cloud,’ ‘name,’ and ‘tags.’ The main panel displays a query for identifying untagged resources, with results listed below showing details like cloud provider, account, name, region, and resource type.

D. Check RDS Backup Configurations

Automated backups are key for ensuring business continuity and rapid recovery after an incident.

This query finds AWS RDS instances that lack automated backup configurations:

SELECT
db_instance_arn, backup_retention_period, region
FROM
aws_rds_instances
WHERE
backup_retention_period = 0;

Save these queries to streamline compliance reporting and utilize our curated list of pre-built queries tailored to DORA requirements.

Screenshot of the CloudQuery SQL Console showing saved queries like ‘AMI older than 30 days’ and integration tables. A query filters data by creation date and state, with a search bar for finding queries.

4. Leverage Security & Compliance Policies

Beyond custom queries, CloudQuery offers pre-configured security and compliance policies that automatically check your cloud environment against industry standards like CIS and NIST. For example, you can run a policy to ensure that IAM roles follow the principle of least privilege, reducing the risk of unauthorized access.

Screenshot of the CloudQuery Policies dashboard showing risk findings in production. It highlights 192 evaluated resources, 129 rule violations, and a rule violations trend over 3 months. A table below lists specific rules, their scope, framework, violations, and risk levels, such as ‘Critical’ for unencrypted S3 buckets.

By integrating these policies into your workflow, you can make sure your cloud environment not only meet DORA’s strict standards but also follow best security practices overall.

Start using CloudQuery today to automate your asset inventory, evaluate your cloud configurations against compliance benchmarks, and ensure your institution is fully prepared for DORA. If you haven’t already, contact us to get started with CloudQuery today.

Have questions or need help? Join the CloudQuery Developer Community to connect with other users, share insights, and get support. Let us know how your team is tackling cloud security by engaging with us on LinkedIn, or X.

Try CloudQuery yourself

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

Related posts

AWS

Security

Tutorials

Finding AWS Unrestricted Outbound Access in 2026: EC2, Lambda, and Beyond

Find EC2, Lambda, and ECS Fargate resources with unrestricted outbound access in AWS using SQL. Why egress controls still break attack chains in 2026.

Joe Karlsson

Joe Karlsson

May 5, 2026

AWS

Security

Tutorials

AWS IAM Identity Center with Google Workspace as an IdP: 2026 Step-by-Step Guide

Set up AWS IAM Identity Center with Google Workspace: SAML authentication, SCIM user provisioning, and group sync with CLI or ssosync. Updated for 2026.

Joe Karlsson

Joe Karlsson

May 5, 2026

AWS

Cloud Infrastructure

Security

Tutorials

Integrate AbuseIPDB Threat Intelligence with CloudQuery

Enrich your cloud asset inventory with AbuseIPDB threat intelligence to identify public cloud IPs with known abuse reports.

Joe Karlsson

Joe Karlsson

April 20, 2026

AWS

Security

Tutorials

AWS IAM Identity Center (Formerly AWS SSO): The Complete 2026 Guide

AWS IAM Identity Center replaced AWS SSO in 2022. Learn how to set it up, configure permission sets, use the AWS CLI, and audit access with CloudQuery.

Joe Karlsson

Joe Karlsson

April 6, 2026

AWS

Security

Tutorials

Set Up AWS CLI with SSO (IAM Identity Center) — Step by Step

Configure AWS CLI v2 with IAM Identity Center in 5 minutes. Covers sso-session setup, automatic token refresh, and switching between multi-account profiles.

Yevgeny Pats

Yevgeny Pats

February 25, 2026

AWS

GCP

Security

Tutorials

How to Inventory All Public IP Addresses Across AWS and GCP using CloudQuery

Track every public IP across AWS and GCP in minutes with SQL. Find exposed EC2 instances, unused Elastic IPs, and GCP Compute resources in one place.

Adam Cobb

Adam Cobb

Joe Karlsson

Joe Karlsson

December 19, 2025

AWS

Azure

GCP

Security

Tutorials

How to Find Internet-Facing Cloud Assets in AWS, Azure and GCP

Find all internet-facing cloud resources across AWS, Azure, and GCP. Identify exposed VMs, storage, databases, and load balancers to reduce attack surface.

Adam Cobb

Adam Cobb

November 5, 2025

AWS

Security

Tutorials

How To List All Expired SSL Certificates on AWS

Learn how to identify expired AWS SSL/TLS certificates using CloudQuery. Sync your AWS data, run SQL queries, and consolidate results to ensure cloud security.

Joe Karlsson

Joe Karlsson

February 5, 2025

AWS

Security

Tutorials

Finding Cross-Account AWS EventBridge Usage

Learn how a CloudQuery customer used custom SQL queries to find cross-account AWS EventBridge usage and strengthen their event-driven security posture.

Jason Kao

Jason Kao

November 30, 2022

Own your pipeline.
Own your data.