| Column Name | Column Data Type |
|---|
filters Input Column
Filters applied to replication tasks. Valid filter names: replication-task-arn | replication-task-id | migration-type | endpoint-arn | replication-instance-arn | 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[]
|
without_settings Input Column
An option to set to avoid returning information about settings. Use this to reduce overhead when setting information is too large. To use this option, choose true; otherwise, choose false (the default). | BOOLEAN |
_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 |
cdc_start_position
Indicates when you want a change data capture (CDC) operation to start. Use either CdcStartPosition or CdcStartTime to specify when you want the CDC operation to start. Specifying both values results in an error. The value can be in date, checkpoint, or LSN/SCN format. Date Example: --cdc-start-position “2018-03-08T12:12:12” Checkpoint Example: --cdc-start-position "checkpoint:V1#27#mysql-bin-changelog.157832:1975:-1:2002:677883278264080:mysql-bin-changelog.157832:1876#0#0#*#0#93" LSN Example: --cdc-start-position “mysql-bin-changelog.000024:373” | VARCHAR |
cdc_stop_position
Indicates when you want a change data capture (CDC) operation to stop. The value can be either server time or commit time. Server time example: --cdc-stop-position “server_time:2018-02-09T12:12:12” Commit time example: --cdc-stop-position “commit_time:2018-02-09T12:12:12“ | VARCHAR |
last_failure_message
The last error (failure) message generated for the replication task. | VARCHAR |
migration_type
The type of migration. | VARCHAR |
recovery_checkpoint
Indicates the last checkpoint that occurred during a change data capture (CDC) operation. You can provide this value to the CdcStartPosition parameter to start a CDC operation that begins at that checkpoint. | VARCHAR |
replication_instance_arn
The ARN of the replication instance. | VARCHAR |
replication_task_arn
The Amazon Resource Name (ARN) of the replication task. | VARCHAR |
replication_task_creation_date
The date the replication task was created. | TIMESTAMP_S |
replication_task_identifier
The user-assigned replication task identifier or name. Constraints: -
Must contain 1-255 alphanumeric characters or hyphens. -
First character must be a letter. -
Cannot end with a hyphen or contain two consecutive hyphens. | VARCHAR |
replication_task_settings
The settings for the replication task. | VARCHAR |
replication_task_start_date
The date the replication task is scheduled to start. | TIMESTAMP_S |
replication_task_stats
The statistics for the task, including elapsed time, tables loaded, and table errors. | STRUCT(
"full_load_progress_percent" BIGINT,
"elapsed_time_millis" BIGINT,
"tables_loaded" BIGINT,
"tables_loading" BIGINT,
"tables_queued" BIGINT,
"tables_errored" BIGINT,
"fresh_start_date" TIMESTAMP_S,
"start_date" TIMESTAMP_S,
"stop_date" TIMESTAMP_S,
"full_load_start_date" TIMESTAMP_S,
"full_load_finish_date" TIMESTAMP_S
) |
Show child fields- replication_task_stats.elapsed_time_millis
The elapsed time of the task, in milliseconds. - replication_task_stats.fresh_start_date
The date the replication task was started either with a fresh start or a target reload. - replication_task_stats.full_load_finish_date
The date the replication task full load was completed. - replication_task_stats.full_load_progress_percent
The percent complete for the full load migration task. - replication_task_stats.full_load_start_date
The date the replication task full load was started. - replication_task_stats.start_date
The date the replication task was started either with a fresh start or a resume. For more information, see StartReplicationTaskType. - replication_task_stats.stop_date
The date the replication task was stopped. - replication_task_stats.tables_errored
The number of errors that have occurred during this task. - replication_task_stats.tables_loaded
The number of tables loaded for this task. - replication_task_stats.tables_loading
The number of tables currently loading for this task. - replication_task_stats.tables_queued
The number of tables queued for this task.
|
source_endpoint_arn
The Amazon Resource Name (ARN) that uniquely identifies the endpoint. | VARCHAR |
status
The status of the replication task. This response parameter can return one of the following values: | VARCHAR |
stop_reason
The reason the replication task was stopped. This response parameter can return one of the following values: -
"Stop Reason NORMAL" -
"Stop Reason RECOVERABLE_ERROR" -
"Stop Reason FATAL_ERROR" -
"Stop Reason FULL_LOAD_ONLY_FINISHED" -
"Stop Reason STOPPED_AFTER_FULL_LOAD" – Full load completed, with cached changes not applied -
"Stop Reason STOPPED_AFTER_CACHED_EVENTS" – Full load completed, with cached changes applied -
"Stop Reason EXPRESS_LICENSE_LIMITS_REACHED" -
"Stop Reason STOPPED_AFTER_DDL_APPLY" – User-defined stop task after DDL applied -
"Stop Reason STOPPED_DUE_TO_LOW_MEMORY" -
"Stop Reason STOPPED_DUE_TO_LOW_DISK" -
"Stop Reason STOPPED_AT_SERVER_TIME" – User-defined server time for stopping task -
"Stop Reason STOPPED_AT_COMMIT_TIME" – User-defined commit time for stopping task -
"Stop Reason RECONFIGURATION_RESTART" -
"Stop Reason RECYCLE_TASK" | VARCHAR |
table_mappings
Table mappings specified in the task. | VARCHAR |
target_endpoint_arn
The ARN that uniquely identifies the endpoint. | VARCHAR |
target_replication_instance_arn
The ARN of the replication instance to which this task is moved in response to running the MoveReplicationTask operation. Otherwise, this response parameter isn't a member of the ReplicationTask object. | VARCHAR |
task_data
Supplemental information that the task requires to migrate the data for certain source and target endpoints. For more information, see Specifying Supplemental Data for Task Settings in the Database Migration Service User Guide. | VARCHAR |