MDAA TS Docs
    Preparing search index...

    Interface RedshiftSettingsProperty

    Provides information that defines an Amazon Redshift endpoint. Modified from the equivalent L1 Construct to prevent use of plaintext credentials and enforce use of KMS encryption. 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 .

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

    interface RedshiftSettingsProperty {
        acceptAnyDate?: boolean;
        afterConnectScript?: string;
        bucketFolder?: string;
        bucketName: string;
        caseSensitiveNames?: boolean;
        compUpdate?: boolean;
        connectionTimeout?: number;
        dateFormat?: string;
        emptyAsNull?: boolean;
        explicitIds?: boolean;
        fileTransferUploadStreams?: number;
        loadTimeout?: number;
        mapBooleanAsBoolean?: boolean;
        maxFileSize?: number;
        removeQuotes?: boolean;
        replaceChars?: string;
        replaceInvalidChars?: string;
        secretsManagerAccessRoleArn?: string;
        secretsManagerSecretArn: string;
        secretsManagerSecretKMSArn?: string;
        serverSideEncryptionKmsKeyId: string;
        serviceAccessRoleArn?: string;
        timeFormat?: string;
        trimBlanks?: boolean;
        truncateColumns?: boolean;
        writeBufferSize?: number;
    }
    Index

    Properties

    acceptAnyDate? afterConnectScript? bucketFolder? bucketName caseSensitiveNames? compUpdate? connectionTimeout? dateFormat? emptyAsNull? explicitIds? fileTransferUploadStreams? loadTimeout? mapBooleanAsBoolean? maxFileSize? removeQuotes? replaceChars? replaceInvalidChars? secretsManagerAccessRoleArn? secretsManagerSecretArn secretsManagerSecretKMSArn? serverSideEncryptionKmsKeyId serviceAccessRoleArn? timeFormat? trimBlanks? truncateColumns? writeBufferSize?

    Properties

    acceptAnyDate?: boolean

    Flag to allow any date format including invalid formats for flexible date handling in Redshift data warehouse

    afterConnectScript?: string

    SQL script to execute after connecting to Redshift endpoint for initialization and setup tasks

    bucketFolder?: string

    S3 folder for storing CSV files before uploading to Redshift cluster for staged data loading

    bucketName: string

    S3 bucket name for intermediate CSV file storage before Redshift data loading operations

    caseSensitiveNames?: boolean

    Flag to enable case-sensitive schema names in Redshift data warehouse for precise schema handling

    compUpdate?: boolean

    Flag to enable automatic compression for empty Redshift tables for storage optimization

    connectionTimeout?: number

    Connection timeout in milliseconds for Redshift endpoint connection establishment

    dateFormat?: string

    Date format specification for Redshift data loading and date handling

    emptyAsNull?: boolean

    Flag to migrate empty CHAR and VARCHAR fields as NULL for consistent null handling

    explicitIds?: boolean

    Flag to override auto-generated IDENTITY column values with explicit source values for full-load migration

    fileTransferUploadStreams?: number

    Number of parallel threads for single file upload to optimize S3 multipart upload performance

    loadTimeout?: number

    Timeout in milliseconds for Redshift cluster operations including COPY, INSERT, DELETE, and UPDATE

    mapBooleanAsBoolean?: boolean

    Flag to migrate boolean type as native boolean in Redshift for proper data type representation

    maxFileSize?: number

    Maximum CSV file size in KB for S3 staging and Redshift data transfer optimization

    removeQuotes?: boolean

    Flag to remove surrounding quotation marks from strings in incoming data for cleaner data processing

    replaceChars?: string

    Replacement character for invalid characters specified in ReplaceInvalidChars for data cleaning

    replaceInvalidChars?: string

    List of characters to replace during data migration for data cleaning

    secretsManagerAccessRoleArn?: string

    IAM role ARN for AWS Secrets Manager access to Redshift endpoint credentials

    secretsManagerSecretArn: string

    Secrets Manager secret ARN containing Redshift endpoint connection details for secure credential management

    secretsManagerSecretKMSArn?: string

    KMS key ARN for encrypting Redshift endpoint credentials secret in Secrets Manager

    serverSideEncryptionKmsKeyId: string

    KMS key ID for server-side encryption when using SSE_KMS encryption mode for Redshift S3 staging security

    serviceAccessRoleArn?: string

    IAM role ARN for DMS service access to Redshift service operations for data warehouse integration

    timeFormat?: string

    Time format specification for Redshift data loading and time handling

    trimBlanks?: boolean

    Flag to remove trailing white space characters from VARCHAR strings for cleaner data processing

    truncateColumns?: boolean

    Flag to truncate data in columns to fit column size limits for data integrity in Redshift

    writeBufferSize?: number

    In-memory file write buffer size in KB for CSV file generation performance optimization

    Settings

    Member Visibility

    On This Page

    Properties