Skip to content

aws.migrationhubstrategy.get_portfolio_preferences

Example SQL Queries

SELECT * FROM
aws.migrationhubstrategy.get_portfolio_preferences;

Description

Retrieves your migration and modernization preferences.

Table Definition

Column NameColumn Data Type
_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.

application_mode

The classification for application component types.

VARCHAR
application_preferences

The transformation preferences for non-database applications.

STRUCT(
"management_preference" STRUCT(
"aws_managed_resources" STRUCT(
"target_destination" VARCHAR[]
),
"no_preference" STRUCT(
"target_destination" VARCHAR[]
),
"self_manage_resources" STRUCT(
"target_destination" VARCHAR[]
)
)
)
Show child fields
application_preferences.management_preference

Application preferences that you specify to prefer managed environment.

Show child fields
application_preferences.management_preference.aws_managed_resources

Indicates interest in solutions that are managed by AWS.

Show child fields
application_preferences.management_preference.aws_managed_resources.target_destination[]
application_preferences.management_preference.no_preference

No specific preference.

Show child fields
application_preferences.management_preference.no_preference.target_destination[]
application_preferences.management_preference.self_manage_resources

Indicates interest in managing your own resources on AWS.

Show child fields
application_preferences.management_preference.self_manage_resources.target_destination[]
database_preferences

The transformation preferences for database applications.

STRUCT(
"database_management_preference" VARCHAR,
"database_migration_preference" STRUCT(
"heterogeneous" STRUCT(
"target_database_engine" VARCHAR[]
),
"homogeneous" STRUCT(
"target_database_engine" VARCHAR[]
),
"no_preference" STRUCT(
"target_database_engine" VARCHAR[]
)
)
)
Show child fields
database_preferences.database_management_preference

Specifies whether you're interested in self-managed databases or databases managed by AWS.

database_preferences.database_migration_preference

Specifies your preferred migration path.

Show child fields
database_preferences.database_migration_preference.heterogeneous

Indicates whether you are interested in moving from one type of database to another. For example, from SQL Server to Amazon Aurora MySQL-Compatible Edition.

Show child fields
database_preferences.database_migration_preference.heterogeneous.target_database_engine[]
database_preferences.database_migration_preference.homogeneous

Indicates whether you are interested in moving to the same type of database into AWS. For example, from SQL Server in your environment to SQL Server on AWS.

Show child fields
database_preferences.database_migration_preference.homogeneous.target_database_engine[]
database_preferences.database_migration_preference.no_preference

Indicated that you do not prefer heterogeneous or homogeneous.

Show child fields
database_preferences.database_migration_preference.no_preference.target_database_engine[]
prioritize_business_goals

The rank of business goals based on priority.

STRUCT(
"business_goals" STRUCT(
"license_cost_reduction" BIGINT,
"modernize_infrastructure_with_cloud_native_technologies" BIGINT,
"reduce_operational_overhead_with_managed_services" BIGINT,
"speed_of_migration" BIGINT
)
)
Show child fields
prioritize_business_goals.business_goals

Rank of business goals based on priority.

Show child fields
prioritize_business_goals.business_goals.license_cost_reduction

Business goal to reduce license costs.

prioritize_business_goals.business_goals.modernize_infrastructure_with_cloud_native_technologies

Business goal to modernize infrastructure by moving to cloud native technologies.

prioritize_business_goals.business_goals.reduce_operational_overhead_with_managed_services

Business goal to reduce the operational overhead on the team by moving into managed services.

prioritize_business_goals.business_goals.speed_of_migration

Business goal to achieve migration at a fast pace.