Skip to content

aws.dms.describe_migration_projects

Example SQL Queries

SELECT * FROM
aws.dms.describe_migration_projects;

Description

Returns a paginated list of migration projects for your account in the current region.

Table Definition

Column NameColumn 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.