| Column Name | Column Data Type |
|---|
cluster_identifier Input Column
The unique identifier of the cluster for which the recommendation is returned. | VARCHAR |
namespace_arn Input Column
The Amazon Redshift cluster namespace ARN for which the recommendations is returned. | 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.
|
_aws_region Input Column
The AWS region to use. | VARCHAR |
created_at
The date and time (UTC) that the recommendation was created. | TIMESTAMP_S |
description
The description of the recommendation. | VARCHAR |
id
A unique identifier of the Advisor recommendation. | VARCHAR |
impact_ranking
The scale of the impact that the Advisor recommendation has to the performance and cost of the cluster. | VARCHAR |
observation
The description of what was observed about your cluster. | VARCHAR |
recommendation_text
The description of the recommendation. | VARCHAR |
recommendation_type
The type of Advisor recommendation. | VARCHAR |
recommended_actions
List of Amazon Redshift recommended actions. | STRUCT(
"text" VARCHAR,
"database" VARCHAR,
"command" VARCHAR,
"type" VARCHAR
)[] |
Show child fields- recommended_actions[]
Show child fields- recommended_actions[].command
The command to run. - recommended_actions[].database
The database name to perform the action on. Only applicable if the type of command is SQL. - recommended_actions[].text
The specific instruction about the command. - recommended_actions[].type
The type of command.
|
reference_links
List of helpful links for more information about the Advisor recommendation. | STRUCT(
"text" VARCHAR,
"link" VARCHAR
)[] |
Show child fields- reference_links[]
Show child fields- reference_links[].link
The URL address to find more information. - reference_links[].text
The hyperlink text that describes the link to more information.
|
title
The title of the recommendation. | VARCHAR |