Package software.amazon.awscdk.services.dms

Interface CfnEndpoint.RedshiftSettingsProperty

All Superinterfaces:

software.amazon.jsii.JsiiSerializable

All Known Implementing Classes:

CfnEndpoint.RedshiftSettingsProperty.Jsii$Proxy

Enclosing class:

CfnEndpoint

@Stability(Stable)
public static interface CfnEndpoint.RedshiftSettingsProperty
extends software.amazon.jsii.JsiiSerializable

Provides information that defines an Amazon Redshift endpoint.

This information includes the output format of records applied to the endpoint and details of transaction and control table data information. For more information about other available settings, see Extra connection attributes when using Amazon Redshift as a target for AWS DMS in the AWS Database Migration Service User Guide .

Example:

 // The code below shows an example of how to instantiate this type.
 // The values are placeholders you should change.
 import software.amazon.awscdk.services.dms.*;
 RedshiftSettingsProperty redshiftSettingsProperty = RedshiftSettingsProperty.builder()
         .acceptAnyDate(false)
         .afterConnectScript("afterConnectScript")
         .bucketFolder("bucketFolder")
         .bucketName("bucketName")
         .caseSensitiveNames(false)
         .compUpdate(false)
         .connectionTimeout(123)
         .dateFormat("dateFormat")
         .emptyAsNull(false)
         .encryptionMode("encryptionMode")
         .explicitIds(false)
         .fileTransferUploadStreams(123)
         .loadTimeout(123)
         .mapBooleanAsBoolean(false)
         .maxFileSize(123)
         .removeQuotes(false)
         .replaceChars("replaceChars")
         .replaceInvalidChars("replaceInvalidChars")
         .secretsManagerAccessRoleArn("secretsManagerAccessRoleArn")
         .secretsManagerSecretId("secretsManagerSecretId")
         .serverSideEncryptionKmsKeyId("serverSideEncryptionKmsKeyId")
         .serviceAccessRoleArn("serviceAccessRoleArn")
         .timeFormat("timeFormat")
         .trimBlanks(false)
         .truncateColumns(false)
         .writeBufferSize(123)
         .build();
 

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html

Nested Class Summary

Nested Classes

Modifier and Type	Interface	Description
static final class	CfnEndpoint.RedshiftSettingsProperty.Builder	A builder for CfnEndpoint.RedshiftSettingsProperty
static final class	CfnEndpoint.RedshiftSettingsProperty.Jsii$Proxy	An implementation for CfnEndpoint.RedshiftSettingsProperty

Method Summary

Modifier and Type	Method	Description
static CfnEndpoint.RedshiftSettingsProperty.Builder	builder()
default Object	getAcceptAnyDate()	A value that indicates to allow any date format, including invalid formats such as 00/00/00 00:00:00, to be loaded without generating an error.
default String	getAfterConnectScript()	Code to run after connecting.
default String	getBucketFolder()	An S3 folder where the comma-separated-value (.csv) files are stored before being uploaded to the target Redshift cluster.
default String	getBucketName()	The name of the intermediate S3 bucket used to store .csv files before uploading data to Redshift.
default Object	getCaseSensitiveNames()	If Amazon Redshift is configured to support case sensitive schema names, set CaseSensitiveNames to true .
default Object	getCompUpdate()	If you set CompUpdate to true Amazon Redshift applies automatic compression if the table is empty.
default Number	getConnectionTimeout()	A value that sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.
default String	getDateFormat()	The date format that you are using.
default Object	getEmptyAsNull()	A value that specifies whether AWS DMS should migrate empty CHAR and VARCHAR fields as NULL.
default String	getEncryptionMode()	The type of server-side encryption that you want to use for your data.
default Object	getExplicitIds()	This setting is only valid for a full-load migration task.
default Number	getFileTransferUploadStreams()	The number of threads used to upload a single file.
default Number	getLoadTimeout()	The amount of time to wait (in milliseconds) before timing out of operations performed by AWS DMS on a Redshift cluster, such as Redshift COPY, INSERT, DELETE, and UPDATE.
default Object	getMapBooleanAsBoolean()	When true, lets Redshift migrate the boolean type as boolean.
default Number	getMaxFileSize()	The maximum size (in KB) of any .csv file used to load data on an S3 bucket and transfer data to Amazon Redshift.
default Object	getRemoveQuotes()	A value that specifies to remove surrounding quotation marks from strings in the incoming data.
default String	getReplaceChars()	A value that specifies to replaces the invalid characters specified in ReplaceInvalidChars , substituting the specified characters instead.
default String	getReplaceInvalidChars()	A list of characters that you want to replace.
default String	getSecretsManagerAccessRoleArn()	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 .
default String	getSecretsManagerSecretId()	The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Amazon Redshift endpoint connection details.
default String	getServerSideEncryptionKmsKeyId()	The AWS KMS key ID.
default String	getServiceAccessRoleArn()	The Amazon Resource Name (ARN) of the IAM role that has access to the Amazon Redshift service.
default String	getTimeFormat()	The time format that you want to use.
default Object	getTrimBlanks()	A value that specifies to remove the trailing white space characters from a VARCHAR string.
default Object	getTruncateColumns()	A value that specifies to truncate data in columns to the appropriate number of characters, so that the data fits in the column.
default Number	getWriteBufferSize()	The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk at the DMS replication instance.

Methods inherited from interface software.amazon.jsii.JsiiSerializable

$jsii$toJson

Method Details

getAcceptAnyDate

@Stability(Stable)
@Nullable
default Object getAcceptAnyDate()

A value that indicates to allow any date format, including invalid formats such as 00/00/00 00:00:00, to be loaded without generating an error.

You can choose true or false (the default).

This parameter applies only to TIMESTAMP and DATE columns. Always use ACCEPTANYDATE with the DATEFORMAT parameter. If the date format for the data doesn't match the DATEFORMAT specification, Amazon Redshift inserts a NULL value into that field.

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-acceptanydate

getAfterConnectScript

@Stability(Stable)
@Nullable
default String getAfterConnectScript()

Code to run after connecting.

This parameter should contain the code itself, not the name of a file containing the code.

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-afterconnectscript

getBucketFolder

@Stability(Stable)
@Nullable
default String getBucketFolder()

An S3 folder where the comma-separated-value (.csv) files are stored before being uploaded to the target Redshift cluster.

For full load mode, AWS DMS converts source records into .csv files and loads them to the BucketFolder/TableID path. AWS DMS uses the Redshift COPY command to upload the .csv files to the target table. The files are deleted once the COPY operation has finished. For more information, see COPY in the Amazon Redshift Database Developer Guide .

For change-data-capture (CDC) mode, AWS DMS creates a NetChanges table, and loads the .csv files to this BucketFolder/NetChangesTableID path.

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-bucketfolder

getBucketName

@Stability(Stable)
@Nullable
default String getBucketName()

The name of the intermediate S3 bucket used to store .csv files before uploading data to Redshift.

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-bucketname

getCaseSensitiveNames

@Stability(Stable)
@Nullable
default Object getCaseSensitiveNames()

If Amazon Redshift is configured to support case sensitive schema names, set CaseSensitiveNames to true .

The default is false .

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-casesensitivenames

getCompUpdate

@Stability(Stable)
@Nullable
default Object getCompUpdate()

If you set CompUpdate to true Amazon Redshift applies automatic compression if the table is empty.

This applies even if the table columns already have encodings other than RAW . If you set CompUpdate to false , automatic compression is disabled and existing column encodings aren't changed. The default is true .

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-compupdate

getConnectionTimeout

@Stability(Stable)
@Nullable
default Number getConnectionTimeout()

A value that sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-connectiontimeout

getDateFormat

@Stability(Stable)
@Nullable
default String getDateFormat()

The date format that you are using.

Valid values are auto (case-sensitive), your date format string enclosed in quotes, or NULL. If this parameter is left unset (NULL), it defaults to a format of 'YYYY-MM-DD'. Using auto recognizes most strings, even some that aren't supported when you use a date format string.

If your date and time values use formats different from each other, set this to auto .

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-dateformat

getEmptyAsNull

@Stability(Stable)
@Nullable
default Object getEmptyAsNull()

A value that specifies whether AWS DMS should migrate empty CHAR and VARCHAR fields as NULL.

A value of true sets empty CHAR and VARCHAR fields to null. The default is false .

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-emptyasnull

getEncryptionMode

@Stability(Stable)
@Nullable
default String getEncryptionMode()

The type of server-side encryption that you want to use for your data.

This encryption type is part of the endpoint settings or the extra connections attributes for Amazon S3. You can choose either SSE_S3 (the default) or SSE_KMS .

For the ModifyEndpoint operation, you can change the existing value of the EncryptionMode parameter from SSE_KMS to SSE_S3 . But you can’t change the existing value from SSE_S3 to SSE_KMS .

To use SSE_S3 , create an AWS Identity and Access Management (IAM) role with a policy that allows "arn:aws:s3:::*" to use the following actions: "s3:PutObject", "s3:ListBucket"

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-encryptionmode

getExplicitIds

@Stability(Stable)
@Nullable
default Object getExplicitIds()

This setting is only valid for a full-load migration task.

Set ExplicitIds to true to have tables with IDENTITY columns override their auto-generated values with explicit values loaded from the source data files used to populate the tables. The default is false .

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-explicitids

getFileTransferUploadStreams

@Stability(Stable)
@Nullable
default Number getFileTransferUploadStreams()

The number of threads used to upload a single file.

This parameter accepts a value from 1 through 64. It defaults to 10.

The number of parallel streams used to upload a single .csv file to an S3 bucket using S3 Multipart Upload. For more information, see Multipart upload overview .

FileTransferUploadStreams accepts a value from 1 through 64. It defaults to 10.

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-filetransferuploadstreams

getLoadTimeout

@Stability(Stable)
@Nullable
default Number getLoadTimeout()

The amount of time to wait (in milliseconds) before timing out of operations performed by AWS DMS on a Redshift cluster, such as Redshift COPY, INSERT, DELETE, and UPDATE.

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-loadtimeout

getMapBooleanAsBoolean

@Stability(Stable)
@Nullable
default Object getMapBooleanAsBoolean()

When true, lets Redshift migrate the boolean type as boolean.

By default, Redshift migrates booleans as varchar(1) . You must set this setting on both the source and target endpoints for it to take effect.

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-mapbooleanasboolean

getMaxFileSize

@Stability(Stable)
@Nullable
default Number getMaxFileSize()

The maximum size (in KB) of any .csv file used to load data on an S3 bucket and transfer data to Amazon Redshift. It defaults to 1048576KB (1 GB).

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-maxfilesize

getRemoveQuotes

@Stability(Stable)
@Nullable
default Object getRemoveQuotes()

A value that specifies to remove surrounding quotation marks from strings in the incoming data.

All characters within the quotation marks, including delimiters, are retained. Choose true to remove quotation marks. The default is false .

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-removequotes

getReplaceChars

@Stability(Stable)
@Nullable
default String getReplaceChars()

A value that specifies to replaces the invalid characters specified in ReplaceInvalidChars , substituting the specified characters instead.

The default is "?" .

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-replacechars

getReplaceInvalidChars

@Stability(Stable)
@Nullable
default String getReplaceInvalidChars()

A list of characters that you want to replace.

Use with ReplaceChars .

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-replaceinvalidchars

getSecretsManagerAccessRoleArn

@Stability(Stable)
@Nullable
default String getSecretsManagerAccessRoleArn()

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 .

The role must allow the iam:PassRole action. SecretsManagerSecret has the value of the AWS Secrets Manager secret that allows access to the Amazon Redshift 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 , the corresponding SecretsManagerAccessRoleArn , and the SecretsManagerSecretId that is required to access it, see Using secrets to access AWS Database Migration Service resources in the AWS Database Migration Service User Guide .

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-secretsmanageraccessrolearn

getSecretsManagerSecretId

@Stability(Stable)
@Nullable
default String getSecretsManagerSecretId()

The full ARN, partial ARN, or display name of the SecretsManagerSecret that contains the Amazon Redshift endpoint connection details.

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-secretsmanagersecretid

getServerSideEncryptionKmsKeyId

@Stability(Stable)
@Nullable
default String getServerSideEncryptionKmsKeyId()

The AWS KMS key ID.

If you are using SSE_KMS for the EncryptionMode , provide this key ID. The key that you use needs an attached policy that enables IAM user permissions and allows use of the key.

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-serversideencryptionkmskeyid

getServiceAccessRoleArn

@Stability(Stable)
@Nullable
default String getServiceAccessRoleArn()

The Amazon Resource Name (ARN) of the IAM role that has access to the Amazon Redshift service.

The role must allow the iam:PassRole action.

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-serviceaccessrolearn

getTimeFormat

@Stability(Stable)
@Nullable
default String getTimeFormat()

The time format that you want to use.

Valid values are auto (case-sensitive), 'timeformat_string' , 'epochsecs' , or 'epochmillisecs' . It defaults to 10. Using auto recognizes most strings, even some that aren't supported when you use a time format string.

If your date and time values use formats different from each other, set this parameter to auto .

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-timeformat

getTrimBlanks

@Stability(Stable)
@Nullable
default Object getTrimBlanks()

A value that specifies to remove the trailing white space characters from a VARCHAR string.

This parameter applies only to columns with a VARCHAR data type. Choose true to remove unneeded white space. The default is false .

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-trimblanks

getTruncateColumns

@Stability(Stable)
@Nullable
default Object getTruncateColumns()

A value that specifies to truncate data in columns to the appropriate number of characters, so that the data fits in the column.

This parameter applies only to columns with a VARCHAR or CHAR data type, and rows with a size of 4 MB or less. Choose true to truncate data. The default is false .

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-truncatecolumns

getWriteBufferSize

@Stability(Stable)
@Nullable
default Number getWriteBufferSize()

The size (in KB) of the in-memory file write buffer used when generating .csv files on the local disk at the DMS replication instance. The default value is 1000 (buffer size is 1000KB).

See Also:

• http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-dms-endpoint-redshiftsettings.html#cfn-dms-endpoint-redshiftsettings-writebuffersize

builder

@Stability(Stable)
static CfnEndpoint.RedshiftSettingsProperty.Builder builder()

Returns:

a CfnEndpoint.RedshiftSettingsProperty.Builder of CfnEndpoint.RedshiftSettingsProperty