| Column Name | Column Data Type |
filters Input Column
Filters applied to the migration projects 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[]
|
marker Input Column
Specifies the unique pagination token that makes it possible to display the next page of results. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords. If Marker is returned by a previous response, there are more results available. The value of Marker is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token and keeping all other arguments unchanged. | VARCHAR |
max_records Input Column
The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, DMS includes a pagination token in the response so that you can retrieve the remaining results. | BIGINT |
_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 |
migration_projects
A description of migration projects. | STRUCT( "migration_project_name" VARCHAR, "migration_project_arn" VARCHAR, "migration_project_creation_time" TIMESTAMP_S, "source_data_provider_descriptors" STRUCT( "secrets_manager_secret_id" VARCHAR, "secrets_manager_access_role_arn" VARCHAR, "data_provider_name" VARCHAR, "data_provider_arn" VARCHAR )[], "target_data_provider_descriptors" STRUCT( "secrets_manager_secret_id" VARCHAR, "secrets_manager_access_role_arn" VARCHAR, "data_provider_name" VARCHAR, "data_provider_arn" VARCHAR )[], "instance_profile_arn" VARCHAR, "instance_profile_name" VARCHAR, "transformation_rules" VARCHAR, "description" VARCHAR, "schema_conversion_application_attributes" STRUCT( "s3_bucket_path" VARCHAR, "s3_bucket_role_arn" VARCHAR ) )[] |
Show child fields- migration_projects[]
Show child fields- migration_projects[].description
A user-friendly description of the migration project.
- migration_projects[].instance_profile_arn
The Amazon Resource Name (ARN) of the instance profile for your migration project.
- migration_projects[].instance_profile_name
The name of the associated instance profile.
- migration_projects[].migration_project_arn
The ARN string that uniquely identifies the migration project.
- migration_projects[].migration_project_creation_time
The time when the migration project was created.
- migration_projects[].migration_project_name
The name of the migration project.
- migration_projects[].schema_conversion_application_attributes
The schema conversion application attributes, including the Amazon S3 bucket name and Amazon S3 role ARN. Show child fields- migration_projects[].schema_conversion_application_attributes.s3_bucket_path
The path for the Amazon S3 bucket that the application uses for exporting assessment reports.
- migration_projects[].schema_conversion_application_attributes.s3_bucket_role_arn
The ARN for the role the application uses to access its Amazon S3 bucket.
- migration_projects[].source_data_provider_descriptors[]
Show child fields- migration_projects[].source_data_provider_descriptors[].data_provider_arn
The Amazon Resource Name (ARN) of the data provider.
- migration_projects[].source_data_provider_descriptors[].data_provider_name
The user-friendly name of the data provider.
- migration_projects[].source_data_provider_descriptors[].secrets_manager_access_role_arn
The ARN of the role used to access Amazon Web Services Secrets Manager.
- migration_projects[].source_data_provider_descriptors[].secrets_manager_secret_id
The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.
- migration_projects[].target_data_provider_descriptors[]
Show child fields- migration_projects[].target_data_provider_descriptors[].data_provider_arn
The Amazon Resource Name (ARN) of the data provider.
- migration_projects[].target_data_provider_descriptors[].data_provider_name
The user-friendly name of the data provider.
- migration_projects[].target_data_provider_descriptors[].secrets_manager_access_role_arn
The ARN of the role used to access Amazon Web Services Secrets Manager.
- migration_projects[].target_data_provider_descriptors[].secrets_manager_secret_id
The identifier of the Amazon Web Services Secrets Manager Secret used to store access credentials for the data provider.
- migration_projects[].transformation_rules
The settings in JSON format for migration rules. Migration rules make it possible for you to change the object names according to the rules that you specify. For example, you can change an object name to lowercase or uppercase, add or remove a prefix or suffix, or rename objects.
|