Skip to content
AWS for Query.Farm

aws.trustedadvisor.get_recommendation

Example SQL Queries

SELECT * FROM
aws.trustedadvisor.get_recommendation
WHERE
"recommendation_identifier" = 'VALUE';

Description

Get a specific Recommendation

Table Definition

Column NameColumn Data Type
recommendation_identifier Required Input Column

The Recommendation identifier

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.

recommendation

The Recommendation

STRUCT(
    "arn" VARCHAR,
    "aws_services" VARCHAR[],
    "check_arn" VARCHAR,
    "created_at" TIMESTAMP_S,
    "created_by" VARCHAR,
    "description" VARCHAR,
    "id" VARCHAR,
    "last_updated_at" TIMESTAMP_S,
    "lifecycle_stage" VARCHAR,
    "name" VARCHAR,
    "pillar_specific_aggregates" STRUCT(
        "cost_optimizing" STRUCT(
            "estimated_monthly_savings" DOUBLE,
            "estimated_percent_monthly_savings" DOUBLE
        )
    ),
    "pillars" VARCHAR[],
    "resolved_at" TIMESTAMP_S,
    "resources_aggregates" STRUCT(
        "error_count" BIGINT,
        "ok_count" BIGINT,
        "warning_count" BIGINT
    ),
    "source" VARCHAR,
    "status" VARCHAR,
    "type" VARCHAR,
    "update_reason" VARCHAR,
    "update_reason_code" VARCHAR,
    "updated_on_behalf_of" VARCHAR,
    "updated_on_behalf_of_job_title" VARCHAR
)
Show child fields
recommendation.arn

The ARN of the Recommendation

recommendation.aws_services[]
recommendation.check_arn

The AWS Trusted Advisor Check ARN that relates to the Recommendation

recommendation.created_at

When the Recommendation was created, if created by AWS Trusted Advisor Priority

recommendation.created_by

The creator, if created by AWS Trusted Advisor Priority

recommendation.description

A description for AWS Trusted Advisor recommendations

recommendation.id

The ID which identifies where the Recommendation was produced

recommendation.last_updated_at

When the Recommendation was last updated

recommendation.lifecycle_stage

The lifecycle stage from AWS Trusted Advisor Priority

recommendation.name

The name of the AWS Trusted Advisor Recommendation

recommendation.pillar_specific_aggregates

The pillar aggregations for cost savings

Show child fields
recommendation.pillar_specific_aggregates.cost_optimizing

Cost optimizing aggregates

Show child fields
recommendation.pillar_specific_aggregates.cost_optimizing.estimated_monthly_savings

The estimated monthly savings

recommendation.pillar_specific_aggregates.cost_optimizing.estimated_percent_monthly_savings

The estimated percently monthly savings

recommendation.pillars[]
recommendation.resolved_at

When the Recommendation was resolved

recommendation.resources_aggregates

An aggregation of all resources

Show child fields
recommendation.resources_aggregates.error_count

The number of AWS resources that were flagged to have errors according to the Trusted Advisor check

recommendation.resources_aggregates.ok_count

The number of AWS resources that were flagged to be OK according to the Trusted Advisor check

recommendation.resources_aggregates.warning_count

The number of AWS resources that were flagged to have warning according to the Trusted Advisor check

recommendation.source

The source of the Recommendation

recommendation.status

The status of the Recommendation

recommendation.type

Whether the Recommendation was automated or generated by AWS Trusted Advisor Priority

recommendation.update_reason

Reason for the lifecycle stage change

recommendation.update_reason_code

Reason code for the lifecycle state change

recommendation.updated_on_behalf_of

The person on whose behalf a Technical Account Manager (TAM) updated the recommendation. This information is only available when a Technical Account Manager takes an action on a recommendation managed by AWS Trusted Advisor Priority

recommendation.updated_on_behalf_of_job_title

The job title of the person on whose behalf a Technical Account Manager (TAM) updated the recommendation. This information is only available when a Technical Account Manager takes an action on a recommendation managed by AWS Trusted Advisor Priority