NAME

Paws::DMS::RedshiftSettings

USAGE

This class represents one of two things:

Arguments in a call to a service

Use the attributes of this class as arguments to methods. You shouldn't make instances of this class. Each attribute should be used as a named argument in the calls that expect this type of object.

As an example, if Att1 is expected to be a Paws::DMS::RedshiftSettings object:

  $service_obj->Method(Att1 => { AcceptAnyDate => $value, ..., WriteBufferSize => $value  });

Results returned from an API call

Use accessors for each attribute. If Att1 is expected to be an Paws::DMS::RedshiftSettings object:

  $result = $service_obj->Method(...);
  $result->Att1->AcceptAnyDate

DESCRIPTION

This class has no description

ATTRIBUTES

AcceptAnyDate => Bool

  Allows 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 (default).

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

AfterConnectScript => Str

  Code to run after connecting. This should be the code, not a filename.

BucketFolder => Str

  The location where the CSV files are stored before being uploaded to
the S3 bucket.

BucketName => Str

  The name of the S3 bucket you want to use

ConnectionTimeout => Int

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

DatabaseName => Str

  The name of the Amazon Redshift data warehouse (service) you are
working with.

DateFormat => Str

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

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

EmptyAsNull => Bool

  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.

EncryptionMode => Str

  The type of server side encryption you want to use for your data. This
is part of the endpoint settings or the extra connections attributes
for Amazon S3. You can choose either SSE_S3 (default) or SSE_KMS. To
use SSE_S3, create an IAM role with a policy that allows
C<"arn:aws:s3:::*"> to use the following actions: C<"s3:PutObject",
"s3:ListBucket">.

FileTransferUploadStreams => Int

  Specifies the number of threads used to upload a single file. This
accepts a value between 1 and 64. It defaults to 10.

LoadTimeout => Int

  Sets the amount of time to wait (in milliseconds) before timing out,
beginning from when you begin loading.

MaxFileSize => Int

  Specifies the maximum size (in KB) of any CSV file used to transfer
data to Amazon Redshift. This accepts a value between 1 and 1048576. It
defaults to 32768 KB (32 MB).

Password => Str

  The password for the user named in the username property.

Port => Int

  The port number for Amazon Redshift. The default value is 5439.

RemoveQuotes => Bool

  Removes 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.

ReplaceChars => Str

  Replaces invalid characters specified in C<ReplaceInvalidChars>,
substituting the specified value instead. The default is "?".

ReplaceInvalidChars => Str

  A list of chars you want to replace. Use with C<ReplaceChars>.

ServerName => Str

  The name of the Amazon Redshift cluster you are using.

ServerSideEncryptionKmsKeyId => Str

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

ServiceAccessRoleArn => Str

  The ARN of the role that has access to the Redshift service.

TimeFormat => Str

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