Skip to content

aws.codecatalyst.list_dev_environments

Example SQL Queries

SELECT * FROM
aws.codecatalyst.list_dev_environments
WHERE
"space_name" = 'VALUE';

Description

Retrieves a list of Dev Environments in a project.

Table Definition

Column NameColumn Data Type
space_name Required Input Column

The name of the space.

VARCHAR
filters Input Column

Information about filters to apply to narrow the results returned in the list.

STRUCT(
"key" VARCHAR,
"values" VARCHAR[],
"comparison_operator" VARCHAR
)[]
Show child fields
filters[]
Show child fields
filters[].comparison_operator

The operator used to compare the fields.

filters[].key

A key that can be used to sort results.

filters[].values[]
project_name Input Column

The name of the project in the space.

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.

alias

The user-specified alias for the Dev Environment.

VARCHAR
creator_id

The system-generated unique ID of the user who created the Dev Environment.

VARCHAR
id

The system-generated unique ID for the Dev Environment.

VARCHAR
ides

Information about the integrated development environment (IDE) configured for a Dev Environment.

STRUCT(
"runtime" VARCHAR,
"name" VARCHAR
)[]
Show child fields
ides[]
Show child fields
ides[].name

The name of the IDE.

ides[].runtime

A link to the IDE runtime image.

inactivity_timeout_minutes

The amount of time the Dev Environment will run without any activity detected before stopping, in minutes. Dev Environments consume compute minutes when running.

BIGINT
instance_type

The Amazon EC2 instace type used for the Dev Environment.

VARCHAR
last_updated_time

The time when the Dev Environment was last updated, in coordinated universal time (UTC) timestamp format as specified in RFC 3339.

TIMESTAMP_S
persistent_storage

Information about the configuration of persistent storage for the Dev Environment.

STRUCT(
"size_in_gi_b" BIGINT
)
Show child fields
persistent_storage.size_in_gi_b

The size of the persistent storage in gigabytes (specifically GiB).

Valid values for storage are based on memory sizes in 16GB increments. Valid values are 16, 32, and 64.

repositories

Information about the repositories that will be cloned into the Dev Environment. If no rvalue is specified, no repository is cloned.

STRUCT(
"repository_name" VARCHAR,
"branch_name" VARCHAR
)[]
Show child fields
repositories[]
Show child fields
repositories[].branch_name

The name of the branch in a source repository cloned into the Dev Environment.

repositories[].repository_name

The name of the source repository.

status

The status of the Dev Environment.

VARCHAR
status_reason

The reason for the status.

VARCHAR
vpc_connection_name

The name of the connection used to connect to Amazon VPC used when the Dev Environment was created, if any.

VARCHAR