Request to add static website hosting column in aws_s3_buckets

Feature Requests
1

Hi there, would it be possible to add a column in aws_s3_buckets containing Static website hosting: true/false?

2

Do you know if there is a field in the UI/CLI that indicates if static website hosting is enabled?

3

https://docs.aws.amazon.com/cli/latest/reference/s3/website.html

In the UI, there’s a field in the ‘Properties’ section at the bottom of the screen.

4

While I don’t think we can do a boolean value to indicate whether the static website hosting is enabled, as that seems to be an inference that the UI is making based on the response from the API, we can definitely add a new table to store all of the configurations.

5

I got it, it’s never easy with their CLI.

6

When we add the new table you should be able to run this query to get all of the buckets that have static websites enabled:

SELECT AWS_S3_BUCKETS.*
FROM AWS_S3_BUCKETS
JOIN AWS_S3_BUCKET_WEBSITES ON AWS_S3_BUCKET_WEBSITES.bucket_arn = AWS_S3_BUCKETS.arn;

Just an FYI, I opened a PR for this work: https://github.com/cloudquery/cloudquery/pull/8497

7

btw, can you also have a look into https://github.com/cloudquery/cloudquery/issues/8443?

8

Discussions for that one are ongoing for a number of reasons:

  1. Has the potential to be a HUGE performance hit for users.
  2. This will incur a cost to users as ListObjects (and ListObjectsV2) are not free…