Incorrect S3 Bucket Existence Check in CloudFront Origins

[ilanabitbol]

SQL Query Bug: Incorrect S3 Bucket Existence Check in CloudFront Origins

Issue Description

The current SQL query incorrectly identifies non-existent S3 buckets by checking the Origin ID instead of the Origin Domain Name. This leads to false positives when checking CloudFront distributions' S3 origins.

Current Behavior

• Query checks bucket existence using Origin ID
• False positives for distributions with valid S3 origins
• Incorrect bucket name extraction from Origin configuration

Expected Behavior

• Check bucket existence using Origin Domain Name
• Correctly identify only truly non-existent S3 buckets
• Extract bucket name from the standard format: [bucket-name].s3.[region].amazonaws.com

Fixed Query

Change bucket name extraction from Origin ID to Origin Domain Name