Add support for CloudFront GetMonitoringSubscription API

[dj00808]

Is your feature request related to a problem? Please describe.

The current aws_cloudfront_distribution table does not expose monitoring subscription details for CloudFront distributions. The GetMonitoringSubscription API provides information about whether additional CloudWatch metrics are enabled for a given distribution, but this data is not currently available in the plugin.

Describe the solution you'd like

Expose the monitoring subscription details for CloudFront distributions. This could be implemented by either:

• Adding relevant columns to the existing aws_cloudfront_distribution table, or
• Creating a new table (e.g., aws_cloudfront_monitoring_subscription) to surface this information.

I am open to feedback on which approach aligns best with the project’s design principles.

Describe alternatives you've considered

Currently, there is no way to retrieve this information via Steampipe. The only alternative is to use the AWS CLI or SDK directly.

Additional context

• GetMonitoringSubscription API documentation
• Related IAM permission: cloudfront:GetMonitoringSubscription