| Column Name | Column Data Type |
|---|
filters Input Column
Filters applied to the target engine recommendations described in the form of key-value pairs. | STRUCT(
"name" VARCHAR,
"values" VARCHAR[]
)[] |
Show child fields- filters[]
Show child fields- filters[].name
The name of the filter as specified for a Describe* or similar operation. - filters[].values[]
|
max_records Input Column
The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, Fleet Advisor includes a pagination token in the response so that you can retrieve the remaining results. | BIGINT |
next_token Input Column
The unique pagination token returned for you to pass to a subsequent request. Fleet Advisor returns this token when the number of records in the response is greater than the MaxRecords value. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged. | 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 |
recommendations
The list of recommendations of target engines that Fleet Advisor created for the source database. | STRUCT(
"database_id" VARCHAR,
"engine_name" VARCHAR,
"created_date" VARCHAR,
"status" VARCHAR,
"preferred" BOOLEAN,
"settings" STRUCT(
"instance_sizing_type" VARCHAR,
"workload_type" VARCHAR
),
"data" STRUCT(
"rds_engine" STRUCT(
"requirements_to_target" STRUCT(
"engine_edition" VARCHAR,
"instance_vcpu" DOUBLE,
"instance_memory" DOUBLE,
"storage_size" BIGINT,
"storage_iops" BIGINT,
"deployment_option" VARCHAR,
"engine_version" VARCHAR
),
"target_configuration" STRUCT(
"engine_edition" VARCHAR,
"instance_type" VARCHAR,
"instance_vcpu" DOUBLE,
"instance_memory" DOUBLE,
"storage_type" VARCHAR,
"storage_size" BIGINT,
"storage_iops" BIGINT,
"deployment_option" VARCHAR,
"engine_version" VARCHAR
)
)
)
)[] |
Show child fields- recommendations[]
Show child fields- recommendations[].created_date
The date when Fleet Advisor created the target engine recommendation. - recommendations[].data
The recommendation of a target engine for the specified source database. Show child fields- recommendations[].data.rds_engine
The recommendation of a target Amazon RDS database engine. Show child fields- recommendations[].data.rds_engine.requirements_to_target
Supplemental information about the requirements to the recommended target database on Amazon RDS. Show child fields- recommendations[].data.rds_engine.requirements_to_target.deployment_option
The required deployment option for the Amazon RDS DB instance. Valid values include "MULTI_AZ" for Multi-AZ deployments and "SINGLE_AZ" for Single-AZ deployments. - recommendations[].data.rds_engine.requirements_to_target.engine_edition
The required target Amazon RDS engine edition. - recommendations[].data.rds_engine.requirements_to_target.engine_version
The required target Amazon RDS engine version. - recommendations[].data.rds_engine.requirements_to_target.instance_memory
The required memory on the Amazon RDS DB instance. - recommendations[].data.rds_engine.requirements_to_target.instance_vcpu
The required number of virtual CPUs (vCPU) on the Amazon RDS DB instance. - recommendations[].data.rds_engine.requirements_to_target.storage_iops
The required number of I/O operations completed each second (IOPS) on your Amazon RDS DB instance. - recommendations[].data.rds_engine.requirements_to_target.storage_size
The required Amazon RDS DB instance storage size.
- recommendations[].data.rds_engine.target_configuration
Supplemental information about the configuration of the recommended target database on Amazon RDS. Show child fields- recommendations[].data.rds_engine.target_configuration.deployment_option
Describes the deployment option for the recommended Amazon RDS DB instance. The deployment options include Multi-AZ and Single-AZ deployments. Valid values include "MULTI_AZ" and "SINGLE_AZ". - recommendations[].data.rds_engine.target_configuration.engine_edition
Describes the recommended target Amazon RDS engine edition. - recommendations[].data.rds_engine.target_configuration.engine_version
Describes the recommended target Amazon RDS engine version. - recommendations[].data.rds_engine.target_configuration.instance_memory
Describes the memory on the recommended Amazon RDS DB instance that meets your requirements. - recommendations[].data.rds_engine.target_configuration.instance_type
Describes the recommended target Amazon RDS instance type. - recommendations[].data.rds_engine.target_configuration.instance_vcpu
Describes the number of virtual CPUs (vCPU) on the recommended Amazon RDS DB instance that meets your requirements. - recommendations[].data.rds_engine.target_configuration.storage_iops
Describes the number of I/O operations completed each second (IOPS) on the recommended Amazon RDS DB instance that meets your requirements. - recommendations[].data.rds_engine.target_configuration.storage_size
Describes the storage size of the recommended Amazon RDS DB instance that meets your requirements. - recommendations[].data.rds_engine.target_configuration.storage_type
Describes the storage type of the recommended Amazon RDS DB instance that meets your requirements. Amazon RDS provides three storage types: General Purpose SSD (also known as gp2 and gp3), Provisioned IOPS SSD (also known as io1), and magnetic (also known as standard).
- recommendations[].database_id
The identifier of the source database for which Fleet Advisor provided this recommendation. - recommendations[].engine_name
The name of the target engine. Valid values include "rds-aurora-mysql", "rds-aurora-postgresql", "rds-mysql", "rds-oracle", "rds-sql-server", and "rds-postgresql". - recommendations[].preferred
Indicates that this target is the rightsized migration destination. - recommendations[].settings
The settings in JSON format for the preferred target engine parameters. These parameters include capacity, resource utilization, and the usage type (production, development, or testing). Show child fields- recommendations[].settings.instance_sizing_type
The size of your target instance. Fleet Advisor calculates this value based on your data collection type, such as total capacity and resource utilization. Valid values include "total-capacity" and "utilization". - recommendations[].settings.workload_type
The deployment option for your target engine. For production databases, Fleet Advisor chooses Multi-AZ deployment. For development or test databases, Fleet Advisor chooses Single-AZ deployment. Valid values include "development" and "production".
- recommendations[].status
The status of the target engine recommendation. Valid values include "alternate", "in-progress", "not-viable", and "recommended".
|