Skip to content

aws.m2.get_environment

Example SQL Queries

SELECT * FROM
aws.m2.get_environment
WHERE
"environment_id" = 'VALUE';

Description

Describes a specific runtime environment.

Table Definition

Column NameColumn Data Type
environment_id Required Input Column

The unique identifier of the runtime environment.

VARCHAR
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
actual_capacity

The number of instances included in the runtime environment. A standalone runtime environment has a maximum of one instance. Currently, a high availability runtime environment has a maximum of two instances.

BIGINT
creation_time

The timestamp when the runtime environment was created.

TIMESTAMP_S
description

The description of the runtime environment.

VARCHAR
engine_type

The target platform for the runtime environment.

VARCHAR
engine_version

The version of the runtime engine.

VARCHAR
environment_arn

The Amazon Resource Name (ARN) of the runtime environment.

VARCHAR
high_availability_config

The desired capacity of the high availability configuration for the runtime environment.

STRUCT(
"desired_capacity" BIGINT
)
Show child fields
high_availability_config.desired_capacity

The number of instances in a high availability configuration. The minimum possible value is 1 and the maximum is 100.

instance_type

The type of instance underlying the runtime environment.

VARCHAR
kms_key_id

The identifier of a customer managed key.

VARCHAR
load_balancer_arn

The Amazon Resource Name (ARN) for the load balancer used with the runtime environment.

VARCHAR
name

The name of the runtime environment. Must be unique within the account.

VARCHAR
pending_maintenance

Indicates the pending maintenance scheduled on this environment.

STRUCT(
"engine_version" VARCHAR,
"schedule" STRUCT(
"end_time" TIMESTAMP_S,
"start_time" TIMESTAMP_S
)
)
Show child fields
pending_maintenance.engine_version

The specific runtime engine that the maintenance schedule applies to.

pending_maintenance.schedule

The maintenance schedule for the runtime engine version.

Show child fields
pending_maintenance.schedule.end_time

The time the scheduled maintenance is to end.

pending_maintenance.schedule.start_time

The time the scheduled maintenance is to start.

preferred_maintenance_window

The maintenance window for the runtime environment. If you don't provide a value for the maintenance window, the service assigns a random value.

VARCHAR
publicly_accessible

Whether applications running in this runtime environment are publicly accessible.

BOOLEAN
security_group_ids

The unique identifiers of the security groups assigned to this runtime environment.

VARCHAR[]
Show child fields
security_group_ids[]
status

The status of the runtime environment.

VARCHAR
status_reason

The reason for the reported status.

VARCHAR
storage_configurations

The storage configurations defined for the runtime environment.

STRUCT(
"efs" STRUCT(
"file_system_id" VARCHAR,
"mount_point" VARCHAR
),
"fsx" STRUCT(
"file_system_id" VARCHAR,
"mount_point" VARCHAR
)
)[]
Show child fields
storage_configurations[]
Show child fields
storage_configurations[].efs

Defines the storage configuration for an Amazon EFS file system.

Show child fields
storage_configurations[].efs.file_system_id

The file system identifier.

storage_configurations[].efs.mount_point

The mount point for the file system.

storage_configurations[].fsx

Defines the storage configuration for an Amazon FSx file system.

Show child fields
storage_configurations[].fsx.file_system_id

The file system identifier.

storage_configurations[].fsx.mount_point

The mount point for the file system.

subnet_ids

The unique identifiers of the subnets assigned to this runtime environment.

VARCHAR[]
Show child fields
subnet_ids[]
tags

The tags defined for this runtime environment.

MAP(VARCHAR, VARCHAR)
vpc_id

The unique identifier for the VPC used with this runtime environment.

VARCHAR