| Column Name | Column Data Type |
|---|
_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.
|
activation_code
The activation code to register a device to the environment. | VARCHAR |
arn
The Amazon Resource Name (ARN) of the environment. | VARCHAR |
created_at
The timestamp of when the environment was created. | TIMESTAMP_S |
desired_software_set_id
The ID of the software set to apply. | VARCHAR |
desktop_arn
The Amazon Resource Name (ARN) of the desktop to stream from Amazon WorkSpaces, WorkSpaces Web, or AppStream 2.0. | VARCHAR |
desktop_endpoint
The URL for the identity provider login (only for environments that use AppStream 2.0). | VARCHAR |
desktop_type
The type of streaming desktop for the environment. | VARCHAR |
id
The ID of the environment. | VARCHAR |
maintenance_window
A specification for a time window to apply software updates. | STRUCT(
"type" VARCHAR,
"start_time_hour" BIGINT,
"start_time_minute" BIGINT,
"end_time_hour" BIGINT,
"end_time_minute" BIGINT,
"days_of_the_week" VARCHAR[],
"apply_time_of" VARCHAR
) |
Show child fields- maintenance_window.apply_time_of
The option to set the maintenance window during the device local time or Universal Coordinated Time (UTC). - maintenance_window.days_of_the_week[]
- maintenance_window.end_time_hour
The hour for the maintenance window end (00-23). - maintenance_window.end_time_minute
The minutes for the maintenance window end (00-59). - maintenance_window.start_time_hour
The hour for the maintenance window start (00-23). - maintenance_window.start_time_minute
The minutes past the hour for the maintenance window start (00-59). - maintenance_window.type
An option to select the default or custom maintenance window.
|
name
The name of the environment. | VARCHAR |
pending_software_set_id
The ID of the software set that is pending to be installed. | VARCHAR |
software_set_update_mode
An option to define which software updates to apply. | VARCHAR |
software_set_update_schedule
An option to define if software updates should be applied within a maintenance window. | VARCHAR |
updated_at
The timestamp of when the device was updated. | TIMESTAMP_S |