| Column Name | Column Data Type |
|---|
lens_alias Required Input Column
The alias of the lens. For Amazon Web Services official lenses, this is either the lens alias, such as serverless, or the lens ARN, such as arn:aws:wellarchitected:us-east-1::lens/serverless. Note that some operations (such as ExportLens and CreateLensShare) are not permitted on Amazon Web Services official lenses. For custom lenses, this is the lens ARN, such as arn:aws:wellarchitected:us-west-2:123456789012:lens/0123456789abcdef01234567890abcdef. Each lens is identified by its LensSummary$LensAlias. | VARCHAR |
workload_id Required Input Column
The ID assigned to the workload. This ID is unique within an Amazon Web Services Region. | VARCHAR |
milestone_number Input Column
The milestone number. A workload can have a maximum of 100 milestones. | BIGINT |
_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 |
lens_review
A lens review of a question. | STRUCT(
"lens_alias" VARCHAR,
"lens_arn" VARCHAR,
"lens_version" VARCHAR,
"lens_name" VARCHAR,
"lens_status" VARCHAR,
"pillar_review_summaries" STRUCT(
"pillar_id" VARCHAR,
"pillar_name" VARCHAR,
"notes" VARCHAR,
"risk_counts" MAP(VARCHAR, BIGINT),
"prioritized_risk_counts" MAP(VARCHAR, BIGINT)
)[],
"jira_configuration" STRUCT(
"selected_pillars" STRUCT(
"pillar_id" VARCHAR,
"selected_question_ids" VARCHAR[]
)[]
),
"updated_at" TIMESTAMP_S,
"notes" VARCHAR,
"risk_counts" MAP(VARCHAR, BIGINT),
"next_token" VARCHAR,
"profiles" STRUCT(
"profile_arn" VARCHAR,
"profile_version" VARCHAR
)[],
"prioritized_risk_counts" MAP(VARCHAR, BIGINT)
) |
Show child fields- lens_review.jira_configuration
Jira configuration status of the Lens review. Show child fields- lens_review.jira_configuration.selected_pillars[]
Show child fields- lens_review.jira_configuration.selected_pillars[].pillar_id
The ID used to identify a pillar, for example, security. A pillar is identified by its PillarReviewSummary$PillarId. - lens_review.jira_configuration.selected_pillars[].selected_question_ids[]
- lens_review.lens_alias
The alias of the lens. For Amazon Web Services official lenses, this is either the lens alias, such as serverless, or the lens ARN, such as arn:aws:wellarchitected:us-east-1::lens/serverless. Note that some operations (such as ExportLens and CreateLensShare) are not permitted on Amazon Web Services official lenses. For custom lenses, this is the lens ARN, such as arn:aws:wellarchitected:us-west-2:123456789012:lens/0123456789abcdef01234567890abcdef. Each lens is identified by its LensSummary$LensAlias. - lens_review.lens_arn
The ARN for the lens. - lens_review.lens_name
The full name of the lens. - lens_review.lens_status
The status of the lens. - lens_review.lens_version
The version of the lens. - lens_review.next_token
The token to use to retrieve the next set of results. - lens_review.notes
The notes associated with the workload. For a review template, these are the notes that will be associated with the workload when the template is applied. - lens_review.pillar_review_summaries[]
Show child fields- lens_review.pillar_review_summaries[].notes
The notes associated with the workload. For a review template, these are the notes that will be associated with the workload when the template is applied. - lens_review.pillar_review_summaries[].pillar_id
The ID used to identify a pillar, for example, security. A pillar is identified by its PillarReviewSummary$PillarId. - lens_review.pillar_review_summaries[].pillar_name
The name of the pillar. - lens_review.pillar_review_summaries[].prioritized_risk_counts
A map from risk names to the count of how many questions have that rating. - lens_review.pillar_review_summaries[].risk_counts
A map from risk names to the count of how many questions have that rating.
- lens_review.prioritized_risk_counts
A map from risk names to the count of how many questions have that rating. - lens_review.profiles[]
Show child fields- lens_review.profiles[].profile_arn
The profile ARN. - lens_review.profiles[].profile_version
The profile version.
- lens_review.risk_counts
A map from risk names to the count of how many questions have that rating. - lens_review.updated_at
The date and time recorded.
|