| Column Name | Column Data Type |
|---|
after_last_updated_at Input Column
After the last update of the Recommendation | TIMESTAMP_S |
aws_service Input Column
The aws service associated with the Recommendation | VARCHAR |
before_last_updated_at Input Column
Before the last update of the Recommendation | TIMESTAMP_S |
check_identifier Input Column
The check identifier of the Recommendation | VARCHAR |
pillar Input Column
The pillar of the Recommendation | VARCHAR |
source Input Column
The source of the Recommendation | VARCHAR |
status Input Column
The status of the Recommendation | VARCHAR |
type Input Column
Whether the Recommendation was automated or generated by AWS Trusted Advisor Priority | 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.
|
arn
The ARN of the Recommendation | VARCHAR |
aws_services
The AWS Services that the Recommendation applies to | VARCHAR[] |
Show child fields- aws_services[]
|
check_arn
The AWS Trusted Advisor Check ARN that relates to the Recommendation | VARCHAR |
created_at
When the Recommendation was created, if created by AWS Trusted Advisor Priority | TIMESTAMP_S |
id
The ID which identifies where the Recommendation was produced | VARCHAR |
last_updated_at
When the Recommendation was last updated | TIMESTAMP_S |
lifecycle_stage
The lifecycle stage from AWS Trusted Advisor Priority | VARCHAR |
name
The name of the AWS Trusted Advisor Recommendation | VARCHAR |
pillar_specific_aggregates
The pillar aggregations for cost savings | STRUCT(
"cost_optimizing" STRUCT(
"estimated_monthly_savings" DOUBLE,
"estimated_percent_monthly_savings" DOUBLE
)
) |
Show child fields- pillar_specific_aggregates.cost_optimizing
Cost optimizing aggregates Show child fields- pillar_specific_aggregates.cost_optimizing.estimated_monthly_savings
The estimated monthly savings - pillar_specific_aggregates.cost_optimizing.estimated_percent_monthly_savings
The estimated percently monthly savings
|
pillars
The Pillars that the Recommendation is optimizing | VARCHAR[] |
Show child fields- pillars[]
|
resources_aggregates
An aggregation of all resources | STRUCT(
"error_count" BIGINT,
"ok_count" BIGINT,
"warning_count" BIGINT
) |
Show child fields- resources_aggregates.error_count
The number of AWS resources that were flagged to have errors according to the Trusted Advisor check - resources_aggregates.ok_count
The number of AWS resources that were flagged to be OK according to the Trusted Advisor check - resources_aggregates.warning_count
The number of AWS resources that were flagged to have warning according to the Trusted Advisor check
|