Table: aws_elasticbeanstalk_environments

This table shows data for AWS Elastic Beanstalk Environments.

https://docs.aws.amazon.com/elasticbeanstalk/latest/APIReference/API_EnvironmentDescription.html (opens in a new tab)

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;