Table: aws_elasticbeanstalk_environments
This table shows data for AWS Elastic Beanstalk Environments.
The composite primary key for this table is (account_id, id).
Relations
The following tables depend on aws_elasticbeanstalk_environments:
Columns
| Name | Type |
|---|---|
| _cq_id | uuid |
| _cq_parent_id | uuid |
| account_id (PK) | utf8 |
| arn | utf8 |
| region | utf8 |
| tags | json |
| id (PK) | utf8 |
| listeners | json |
| abortable_operation_in_progress | bool |
| application_name | utf8 |
| cname | utf8 |
| date_created | timestamp[us, tz=UTC] |
| date_updated | timestamp[us, tz=UTC] |
| description | utf8 |
| endpoint_url | utf8 |
| environment_arn | utf8 |
| environment_id | utf8 |
| environment_links | json |
| environment_name | utf8 |
| health | utf8 |
| health_status | utf8 |
| operations_role | utf8 |
| platform_arn | utf8 |
| resources | json |
| solution_stack_name | utf8 |
| status | utf8 |
| template_name | utf8 |
| tier | json |
| version_label | utf8 |
Example Queries
These SQL queries are sampled from CloudQuery policies and are compatible with PostgreSQL.
Elastic Beanstalk environments should have enhanced health reporting enabled
SELECT
'Elastic Beanstalk environments should have enhanced health reporting enabled'
AS title,
account_id,
arn AS resource_id,
CASE
WHEN health_status IS NULL OR health_status = '' OR health IS NULL THEN 'fail'
ELSE 'pass'
END
AS status
FROM
aws_elasticbeanstalk_environments;