@Generated(value="com.amazonaws:aws-java-sdk-code-generator") public class RedshiftSettings extends Object implements Serializable, Cloneable, StructuredPojo
Constructor and Description |
---|
RedshiftSettings() |
Modifier and Type | Method and Description |
---|---|
RedshiftSettings |
clone() |
boolean |
equals(Object obj) |
Boolean |
getAcceptAnyDate()
Allows any date format, including invalid formats such as 00/00/00 00:00:00, to be loaded without generating an
error.
|
String |
getAfterConnectScript()
Code to run after connecting.
|
String |
getBucketFolder()
The location where the CSV files are stored before being uploaded to the S3 bucket.
|
String |
getBucketName()
The name of the S3 bucket you want to use
|
Integer |
getConnectionTimeout()
Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish
a connection.
|
String |
getDatabaseName()
The name of the Amazon Redshift data warehouse (service) you are working with.
|
String |
getDateFormat()
The date format you are using.
|
Boolean |
getEmptyAsNull()
Specifies whether AWS DMS should migrate empty CHAR and VARCHAR fields as NULL.
|
String |
getEncryptionMode()
The type of server side encryption you want to use for your data.
|
Integer |
getFileTransferUploadStreams()
Specifies the number of threads used to upload a single file.
|
Integer |
getLoadTimeout()
Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you begin loading.
|
Integer |
getMaxFileSize()
Specifies the maximum size (in KB) of any CSV file used to transfer data to Amazon Redshift.
|
String |
getPassword()
The password for the user named in the username property.
|
Integer |
getPort()
The port number for Amazon Redshift.
|
Boolean |
getRemoveQuotes()
Removes surrounding quotation marks from strings in the incoming data.
|
String |
getReplaceChars()
Replaces invalid characters specified in
ReplaceInvalidChars , substituting the specified value
instead. |
String |
getReplaceInvalidChars()
A list of chars you want to replace.
|
String |
getServerName()
The name of the Amazon Redshift cluster you are using.
|
String |
getServerSideEncryptionKmsKeyId()
If you are using SSE_KMS for the
EncryptionMode , provide the KMS Key ID. |
String |
getServiceAccessRoleArn()
The ARN of the role that has access to the Redshift service.
|
String |
getTimeFormat()
The time format you want to use.
|
Boolean |
getTrimBlanks()
Removes the trailing white space characters from a VARCHAR string.
|
Boolean |
getTruncateColumns()
Truncates data in columns to the appropriate number of characters, so that it fits in the column.
|
String |
getUsername()
An Amazon Redshift user name for a registered user.
|
Integer |
getWriteBufferSize()
The size of the write buffer to use in rows.
|
int |
hashCode() |
Boolean |
isAcceptAnyDate()
Allows any date format, including invalid formats such as 00/00/00 00:00:00, to be loaded without generating an
error.
|
Boolean |
isEmptyAsNull()
Specifies whether AWS DMS should migrate empty CHAR and VARCHAR fields as NULL.
|
Boolean |
isRemoveQuotes()
Removes surrounding quotation marks from strings in the incoming data.
|
Boolean |
isTrimBlanks()
Removes the trailing white space characters from a VARCHAR string.
|
Boolean |
isTruncateColumns()
Truncates data in columns to the appropriate number of characters, so that it fits in the column.
|
void |
marshall(ProtocolMarshaller protocolMarshaller)
Marshalls this structured data using the given
ProtocolMarshaller . |
void |
setAcceptAnyDate(Boolean acceptAnyDate)
Allows any date format, including invalid formats such as 00/00/00 00:00:00, to be loaded without generating an
error.
|
void |
setAfterConnectScript(String afterConnectScript)
Code to run after connecting.
|
void |
setBucketFolder(String bucketFolder)
The location where the CSV files are stored before being uploaded to the S3 bucket.
|
void |
setBucketName(String bucketName)
The name of the S3 bucket you want to use
|
void |
setConnectionTimeout(Integer connectionTimeout)
Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish
a connection.
|
void |
setDatabaseName(String databaseName)
The name of the Amazon Redshift data warehouse (service) you are working with.
|
void |
setDateFormat(String dateFormat)
The date format you are using.
|
void |
setEmptyAsNull(Boolean emptyAsNull)
Specifies whether AWS DMS should migrate empty CHAR and VARCHAR fields as NULL.
|
void |
setEncryptionMode(String encryptionMode)
The type of server side encryption you want to use for your data.
|
void |
setFileTransferUploadStreams(Integer fileTransferUploadStreams)
Specifies the number of threads used to upload a single file.
|
void |
setLoadTimeout(Integer loadTimeout)
Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you begin loading.
|
void |
setMaxFileSize(Integer maxFileSize)
Specifies the maximum size (in KB) of any CSV file used to transfer data to Amazon Redshift.
|
void |
setPassword(String password)
The password for the user named in the username property.
|
void |
setPort(Integer port)
The port number for Amazon Redshift.
|
void |
setRemoveQuotes(Boolean removeQuotes)
Removes surrounding quotation marks from strings in the incoming data.
|
void |
setReplaceChars(String replaceChars)
Replaces invalid characters specified in
ReplaceInvalidChars , substituting the specified value
instead. |
void |
setReplaceInvalidChars(String replaceInvalidChars)
A list of chars you want to replace.
|
void |
setServerName(String serverName)
The name of the Amazon Redshift cluster you are using.
|
void |
setServerSideEncryptionKmsKeyId(String serverSideEncryptionKmsKeyId)
If you are using SSE_KMS for the
EncryptionMode , provide the KMS Key ID. |
void |
setServiceAccessRoleArn(String serviceAccessRoleArn)
The ARN of the role that has access to the Redshift service.
|
void |
setTimeFormat(String timeFormat)
The time format you want to use.
|
void |
setTrimBlanks(Boolean trimBlanks)
Removes the trailing white space characters from a VARCHAR string.
|
void |
setTruncateColumns(Boolean truncateColumns)
Truncates data in columns to the appropriate number of characters, so that it fits in the column.
|
void |
setUsername(String username)
An Amazon Redshift user name for a registered user.
|
void |
setWriteBufferSize(Integer writeBufferSize)
The size of the write buffer to use in rows.
|
String |
toString()
Returns a string representation of this object.
|
RedshiftSettings |
withAcceptAnyDate(Boolean acceptAnyDate)
Allows any date format, including invalid formats such as 00/00/00 00:00:00, to be loaded without generating an
error.
|
RedshiftSettings |
withAfterConnectScript(String afterConnectScript)
Code to run after connecting.
|
RedshiftSettings |
withBucketFolder(String bucketFolder)
The location where the CSV files are stored before being uploaded to the S3 bucket.
|
RedshiftSettings |
withBucketName(String bucketName)
The name of the S3 bucket you want to use
|
RedshiftSettings |
withConnectionTimeout(Integer connectionTimeout)
Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish
a connection.
|
RedshiftSettings |
withDatabaseName(String databaseName)
The name of the Amazon Redshift data warehouse (service) you are working with.
|
RedshiftSettings |
withDateFormat(String dateFormat)
The date format you are using.
|
RedshiftSettings |
withEmptyAsNull(Boolean emptyAsNull)
Specifies whether AWS DMS should migrate empty CHAR and VARCHAR fields as NULL.
|
RedshiftSettings |
withEncryptionMode(EncryptionModeValue encryptionMode)
The type of server side encryption you want to use for your data.
|
RedshiftSettings |
withEncryptionMode(String encryptionMode)
The type of server side encryption you want to use for your data.
|
RedshiftSettings |
withFileTransferUploadStreams(Integer fileTransferUploadStreams)
Specifies the number of threads used to upload a single file.
|
RedshiftSettings |
withLoadTimeout(Integer loadTimeout)
Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you begin loading.
|
RedshiftSettings |
withMaxFileSize(Integer maxFileSize)
Specifies the maximum size (in KB) of any CSV file used to transfer data to Amazon Redshift.
|
RedshiftSettings |
withPassword(String password)
The password for the user named in the username property.
|
RedshiftSettings |
withPort(Integer port)
The port number for Amazon Redshift.
|
RedshiftSettings |
withRemoveQuotes(Boolean removeQuotes)
Removes surrounding quotation marks from strings in the incoming data.
|
RedshiftSettings |
withReplaceChars(String replaceChars)
Replaces invalid characters specified in
ReplaceInvalidChars , substituting the specified value
instead. |
RedshiftSettings |
withReplaceInvalidChars(String replaceInvalidChars)
A list of chars you want to replace.
|
RedshiftSettings |
withServerName(String serverName)
The name of the Amazon Redshift cluster you are using.
|
RedshiftSettings |
withServerSideEncryptionKmsKeyId(String serverSideEncryptionKmsKeyId)
If you are using SSE_KMS for the
EncryptionMode , provide the KMS Key ID. |
RedshiftSettings |
withServiceAccessRoleArn(String serviceAccessRoleArn)
The ARN of the role that has access to the Redshift service.
|
RedshiftSettings |
withTimeFormat(String timeFormat)
The time format you want to use.
|
RedshiftSettings |
withTrimBlanks(Boolean trimBlanks)
Removes the trailing white space characters from a VARCHAR string.
|
RedshiftSettings |
withTruncateColumns(Boolean truncateColumns)
Truncates data in columns to the appropriate number of characters, so that it fits in the column.
|
RedshiftSettings |
withUsername(String username)
An Amazon Redshift user name for a registered user.
|
RedshiftSettings |
withWriteBufferSize(Integer writeBufferSize)
The size of the write buffer to use in rows.
|
public void setAcceptAnyDate(Boolean acceptAnyDate)
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.
acceptAnyDate
- 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.
public Boolean getAcceptAnyDate()
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.
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.
public RedshiftSettings withAcceptAnyDate(Boolean acceptAnyDate)
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.
acceptAnyDate
- 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.
public Boolean isAcceptAnyDate()
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.
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.
public void setAfterConnectScript(String afterConnectScript)
Code to run after connecting. This should be the code, not a filename.
afterConnectScript
- Code to run after connecting. This should be the code, not a filename.public String getAfterConnectScript()
Code to run after connecting. This should be the code, not a filename.
public RedshiftSettings withAfterConnectScript(String afterConnectScript)
Code to run after connecting. This should be the code, not a filename.
afterConnectScript
- Code to run after connecting. This should be the code, not a filename.public void setBucketFolder(String bucketFolder)
The location where the CSV files are stored before being uploaded to the S3 bucket.
bucketFolder
- The location where the CSV files are stored before being uploaded to the S3 bucket.public String getBucketFolder()
The location where the CSV files are stored before being uploaded to the S3 bucket.
public RedshiftSettings withBucketFolder(String bucketFolder)
The location where the CSV files are stored before being uploaded to the S3 bucket.
bucketFolder
- The location where the CSV files are stored before being uploaded to the S3 bucket.public void setBucketName(String bucketName)
The name of the S3 bucket you want to use
bucketName
- The name of the S3 bucket you want to usepublic String getBucketName()
The name of the S3 bucket you want to use
public RedshiftSettings withBucketName(String bucketName)
The name of the S3 bucket you want to use
bucketName
- The name of the S3 bucket you want to usepublic void setConnectionTimeout(Integer connectionTimeout)
Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.
connectionTimeout
- Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially
establish a connection.public Integer getConnectionTimeout()
Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.
public RedshiftSettings withConnectionTimeout(Integer connectionTimeout)
Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.
connectionTimeout
- Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially
establish a connection.public void setDatabaseName(String databaseName)
The name of the Amazon Redshift data warehouse (service) you are working with.
databaseName
- The name of the Amazon Redshift data warehouse (service) you are working with.public String getDatabaseName()
The name of the Amazon Redshift data warehouse (service) you are working with.
public RedshiftSettings withDatabaseName(String databaseName)
The name of the Amazon Redshift data warehouse (service) you are working with.
databaseName
- The name of the Amazon Redshift data warehouse (service) you are working with.public void setDateFormat(String dateFormat)
The date format you are using. Valid values are 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
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
.
dateFormat
- The date format you are using. Valid values are 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 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
.
public String getDateFormat()
The date format you are using. Valid values are 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
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
.
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 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
.
public RedshiftSettings withDateFormat(String dateFormat)
The date format you are using. Valid values are 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
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
.
dateFormat
- The date format you are using. Valid values are 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 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
.
public void setEmptyAsNull(Boolean emptyAsNull)
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.
emptyAsNull
- 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.public Boolean getEmptyAsNull()
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.
public RedshiftSettings withEmptyAsNull(Boolean emptyAsNull)
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.
emptyAsNull
- 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.public Boolean isEmptyAsNull()
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.
public void setEncryptionMode(String encryptionMode)
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 "arn:aws:s3:::*"
to use the following actions:
"s3:PutObject", "s3:ListBucket"
.
encryptionMode
- 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 "arn:aws:s3:::*"
to use the following
actions: "s3:PutObject", "s3:ListBucket"
.EncryptionModeValue
public String getEncryptionMode()
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 "arn:aws:s3:::*"
to use the following actions:
"s3:PutObject", "s3:ListBucket"
.
"arn:aws:s3:::*"
to use the
following actions: "s3:PutObject", "s3:ListBucket"
.EncryptionModeValue
public RedshiftSettings withEncryptionMode(String encryptionMode)
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 "arn:aws:s3:::*"
to use the following actions:
"s3:PutObject", "s3:ListBucket"
.
encryptionMode
- 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 "arn:aws:s3:::*"
to use the following
actions: "s3:PutObject", "s3:ListBucket"
.EncryptionModeValue
public RedshiftSettings withEncryptionMode(EncryptionModeValue encryptionMode)
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 "arn:aws:s3:::*"
to use the following actions:
"s3:PutObject", "s3:ListBucket"
.
encryptionMode
- 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 "arn:aws:s3:::*"
to use the following
actions: "s3:PutObject", "s3:ListBucket"
.EncryptionModeValue
public void setFileTransferUploadStreams(Integer fileTransferUploadStreams)
Specifies the number of threads used to upload a single file. This accepts a value between 1 and 64. It defaults to 10.
fileTransferUploadStreams
- Specifies the number of threads used to upload a single file. This accepts a value between 1 and 64. It
defaults to 10.public Integer getFileTransferUploadStreams()
Specifies the number of threads used to upload a single file. This accepts a value between 1 and 64. It defaults to 10.
public RedshiftSettings withFileTransferUploadStreams(Integer fileTransferUploadStreams)
Specifies the number of threads used to upload a single file. This accepts a value between 1 and 64. It defaults to 10.
fileTransferUploadStreams
- Specifies the number of threads used to upload a single file. This accepts a value between 1 and 64. It
defaults to 10.public void setLoadTimeout(Integer loadTimeout)
Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you begin loading.
loadTimeout
- Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you begin
loading.public Integer getLoadTimeout()
Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you begin loading.
public RedshiftSettings withLoadTimeout(Integer loadTimeout)
Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you begin loading.
loadTimeout
- Sets the amount of time to wait (in milliseconds) before timing out, beginning from when you begin
loading.public void setMaxFileSize(Integer maxFileSize)
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).
maxFileSize
- 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).public Integer getMaxFileSize()
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).
public RedshiftSettings withMaxFileSize(Integer maxFileSize)
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).
maxFileSize
- 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).public void setPassword(String password)
The password for the user named in the username property.
password
- The password for the user named in the username property.public String getPassword()
The password for the user named in the username property.
public RedshiftSettings withPassword(String password)
The password for the user named in the username property.
password
- The password for the user named in the username property.public void setPort(Integer port)
The port number for Amazon Redshift. The default value is 5439.
port
- The port number for Amazon Redshift. The default value is 5439.public Integer getPort()
The port number for Amazon Redshift. The default value is 5439.
public RedshiftSettings withPort(Integer port)
The port number for Amazon Redshift. The default value is 5439.
port
- The port number for Amazon Redshift. The default value is 5439.public void setRemoveQuotes(Boolean removeQuotes)
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.
removeQuotes
- 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.public Boolean getRemoveQuotes()
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.
public RedshiftSettings withRemoveQuotes(Boolean removeQuotes)
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.
removeQuotes
- 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.public Boolean isRemoveQuotes()
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.
public void setReplaceInvalidChars(String replaceInvalidChars)
A list of chars you want to replace. Use with ReplaceChars
.
replaceInvalidChars
- A list of chars you want to replace. Use with ReplaceChars
.public String getReplaceInvalidChars()
A list of chars you want to replace. Use with ReplaceChars
.
ReplaceChars
.public RedshiftSettings withReplaceInvalidChars(String replaceInvalidChars)
A list of chars you want to replace. Use with ReplaceChars
.
replaceInvalidChars
- A list of chars you want to replace. Use with ReplaceChars
.public void setReplaceChars(String replaceChars)
Replaces invalid characters specified in ReplaceInvalidChars
, substituting the specified value
instead. The default is "?".
replaceChars
- Replaces invalid characters specified in ReplaceInvalidChars
, substituting the specified
value instead. The default is "?".public String getReplaceChars()
Replaces invalid characters specified in ReplaceInvalidChars
, substituting the specified value
instead. The default is "?".
ReplaceInvalidChars
, substituting the specified
value instead. The default is "?".public RedshiftSettings withReplaceChars(String replaceChars)
Replaces invalid characters specified in ReplaceInvalidChars
, substituting the specified value
instead. The default is "?".
replaceChars
- Replaces invalid characters specified in ReplaceInvalidChars
, substituting the specified
value instead. The default is "?".public void setServerName(String serverName)
The name of the Amazon Redshift cluster you are using.
serverName
- The name of the Amazon Redshift cluster you are using.public String getServerName()
The name of the Amazon Redshift cluster you are using.
public RedshiftSettings withServerName(String serverName)
The name of the Amazon Redshift cluster you are using.
serverName
- The name of the Amazon Redshift cluster you are using.public void setServiceAccessRoleArn(String serviceAccessRoleArn)
The ARN of the role that has access to the Redshift service.
serviceAccessRoleArn
- The ARN of the role that has access to the Redshift service.public String getServiceAccessRoleArn()
The ARN of the role that has access to the Redshift service.
public RedshiftSettings withServiceAccessRoleArn(String serviceAccessRoleArn)
The ARN of the role that has access to the Redshift service.
serviceAccessRoleArn
- The ARN of the role that has access to the Redshift service.public void setServerSideEncryptionKmsKeyId(String serverSideEncryptionKmsKeyId)
If you are using SSE_KMS for the 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.
serverSideEncryptionKmsKeyId
- If you are using SSE_KMS for the 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.public String getServerSideEncryptionKmsKeyId()
If you are using SSE_KMS for the 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.
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.public RedshiftSettings withServerSideEncryptionKmsKeyId(String serverSideEncryptionKmsKeyId)
If you are using SSE_KMS for the 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.
serverSideEncryptionKmsKeyId
- If you are using SSE_KMS for the 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.public void setTimeFormat(String timeFormat)
The time format 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 are not supported when you use a time format string.
If your date and time values use formats different from each other, set this to auto
.
timeFormat
- The time format 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 are not supported when you use a time format string.
If your date and time values use formats different from each other, set this to auto
.
public String getTimeFormat()
The time format 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 are not supported when you use a time format string.
If your date and time values use formats different from each other, set this to auto
.
auto
(case-sensitive),
'timeformat_string', 'epochsecs', or 'epochmillisecs'. It defaults to 10. Using auto
recognizes most strings, even some that are not supported when you use a time format string.
If your date and time values use formats different from each other, set this to auto
.
public RedshiftSettings withTimeFormat(String timeFormat)
The time format 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 are not supported when you use a time format string.
If your date and time values use formats different from each other, set this to auto
.
timeFormat
- The time format 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 are not supported when you use a time format string.
If your date and time values use formats different from each other, set this to auto
.
public void setTrimBlanks(Boolean trimBlanks)
Removes 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.
trimBlanks
- Removes 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.public Boolean getTrimBlanks()
Removes 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.
public RedshiftSettings withTrimBlanks(Boolean trimBlanks)
Removes 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.
trimBlanks
- Removes 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.public Boolean isTrimBlanks()
Removes 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.
public void setTruncateColumns(Boolean truncateColumns)
Truncates data in columns to the appropriate number of characters, so that it fits in the column. 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.
truncateColumns
- Truncates data in columns to the appropriate number of characters, so that it fits in the column. 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.public Boolean getTruncateColumns()
Truncates data in columns to the appropriate number of characters, so that it fits in the column. 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.
public RedshiftSettings withTruncateColumns(Boolean truncateColumns)
Truncates data in columns to the appropriate number of characters, so that it fits in the column. 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.
truncateColumns
- Truncates data in columns to the appropriate number of characters, so that it fits in the column. 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.public Boolean isTruncateColumns()
Truncates data in columns to the appropriate number of characters, so that it fits in the column. 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.
public void setUsername(String username)
An Amazon Redshift user name for a registered user.
username
- An Amazon Redshift user name for a registered user.public String getUsername()
An Amazon Redshift user name for a registered user.
public RedshiftSettings withUsername(String username)
An Amazon Redshift user name for a registered user.
username
- An Amazon Redshift user name for a registered user.public void setWriteBufferSize(Integer writeBufferSize)
The size of the write buffer to use in rows. Valid values range from 1 to 2048. Defaults to 1024. Use this setting to tune performance.
writeBufferSize
- The size of the write buffer to use in rows. Valid values range from 1 to 2048. Defaults to 1024. Use this
setting to tune performance.public Integer getWriteBufferSize()
The size of the write buffer to use in rows. Valid values range from 1 to 2048. Defaults to 1024. Use this setting to tune performance.
public RedshiftSettings withWriteBufferSize(Integer writeBufferSize)
The size of the write buffer to use in rows. Valid values range from 1 to 2048. Defaults to 1024. Use this setting to tune performance.
writeBufferSize
- The size of the write buffer to use in rows. Valid values range from 1 to 2048. Defaults to 1024. Use this
setting to tune performance.public String toString()
toString
in class Object
Object.toString()
public RedshiftSettings clone()
public void marshall(ProtocolMarshaller protocolMarshaller)
StructuredPojo
ProtocolMarshaller
.marshall
in interface StructuredPojo
protocolMarshaller
- Implementation of ProtocolMarshaller
used to marshall this object's data.Copyright © 2013 Amazon Web Services, Inc. All Rights Reserved.