AfterConnectScript => Str

For use with change data capture (CDC) only, this attribute has AWS DMS bypass foreign keys and user triggers to reduce the time it takes to bulk load data.

Example: "afterConnectScript=SET session_replication_role='replica'"

CaptureDdls => Bool

To capture DDL events, AWS DMS creates various artifacts in the PostgreSQL database when the task starts. You can later remove these artifacts.

If this value is set to "N", you don't have to create tables or triggers on the source database.

DatabaseName => Str

Database name for the endpoint.

DdlArtifactsSchema => Str

The schema in which the operational DDL database artifacts are created.

Example: "ddlArtifactsSchema=xyzddlschema;"

ExecuteTimeout => Int

Sets the client statement timeout for the PostgreSQL instance, in seconds. The default value is 60 seconds.

Example: "executeTimeout=100;"

FailTasksOnLobTruncation => Bool

When set to "true", this value causes a task to fail if the actual size of a LOB column is greater than the specified "LobMaxSize".

If task is set to Limited LOB mode and this option is set to true, the task fails instead of truncating the LOB data.

MaxFileSize => Int

Specifies the maximum size (in KB) of any .csv file used to transfer data to PostgreSQL.

Example: "maxFileSize=512"

Password => Str

Endpoint connection password.

Port => Int

Endpoint TCP port.

SecretsManagerAccessRoleArn => Str

The full Amazon Resource Name (ARN) of the IAM role that specifies AWS DMS as the trusted entity and grants the required permissions to access the value in "SecretsManagerSecret". "SecretsManagerSecret" has the value of the AWS Secrets Manager secret that allows access to the PostgreSQL endpoint.

You can specify one of two sets of values for these permissions. You can specify the values for this setting and "SecretsManagerSecretId". Or you can specify clear-text values for "UserName", "Password", "ServerName", and "Port". You can't specify both. For more information on creating this "SecretsManagerSecret" and the "SecretsManagerAccessRoleArn" and "SecretsManagerSecretId" required to access it, see Using secrets to access AWS Database Migration Service resources (https://docs.aws.amazon.com/https:/docs.aws.amazon.com/dms/latest/userguide/CHAP_Security.html#security-iam-secretsmanager) in the AWS Database Migration Service User Guide.

SecretsManagerSecretId => Str

The full ARN, partial ARN, or friendly name of the "SecretsManagerSecret" that contains the PostgreSQL endpoint connection details.

ServerName => Str

Fully qualified domain name of the endpoint.

SlotName => Str

Sets the name of a previously created logical replication slot for a CDC load of the PostgreSQL source instance.

When used with the AWS DMS API "CdcStartPosition" request parameter, this attribute also enables using native CDC start points.

Username => Str

Endpoint connection user name.