Class: Aws::DatabaseMigrationService::Types::RedshiftSettings
- Inherits:
-
Struct
- Object
- Struct
- Aws::DatabaseMigrationService::Types::RedshiftSettings
- Defined in:
- gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb
Overview
Provides information that defines an Amazon Redshift endpoint.
Constant Summary collapse
- SENSITIVE =
[:password]
Instance Attribute Summary collapse
-
#accept_any_date ⇒ Boolean
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.
-
#after_connect_script ⇒ String
Code to run after connecting.
-
#bucket_folder ⇒ String
An S3 folder where the comma-separated-value (.csv) files are stored before being uploaded to the target Redshift cluster.
-
#bucket_name ⇒ String
The name of the intermediate S3 bucket used to store .csv files before uploading data to Redshift.
-
#case_sensitive_names ⇒ Boolean
If Amazon Redshift is configured to support case sensitive schema names, set
CaseSensitiveNames
totrue
. -
#comp_update ⇒ Boolean
If you set
CompUpdate
totrue
Amazon Redshift applies automatic compression if the table is empty. -
#connection_timeout ⇒ Integer
A value that sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.
-
#database_name ⇒ String
The name of the Amazon Redshift data warehouse (service) that you are working with.
-
#date_format ⇒ String
The date format that you are using.
-
#empty_as_null ⇒ Boolean
A value that specifies whether DMS should migrate empty CHAR and VARCHAR fields as NULL.
-
#encryption_mode ⇒ String
The type of server-side encryption that you want to use for your data.
-
#explicit_ids ⇒ Boolean
This setting is only valid for a full-load migration task.
-
#file_transfer_upload_streams ⇒ Integer
The number of threads used to upload a single file.
-
#load_timeout ⇒ Integer
The amount of time to wait (in milliseconds) before timing out of operations performed by DMS on a Redshift cluster, such as Redshift COPY, INSERT, DELETE, and UPDATE.
-
#map_boolean_as_boolean ⇒ Boolean
When true, lets Redshift migrate the boolean type as boolean.
-
#max_file_size ⇒ Integer
The maximum size (in KB) of any .csv file used to load data on an S3 bucket and transfer data to Amazon Redshift.
-
#password ⇒ String
The password for the user named in the
username
property. -
#port ⇒ Integer
The port number for Amazon Redshift.
-
#remove_quotes ⇒ Boolean
A value that specifies to remove surrounding quotation marks from strings in the incoming data.
-
#replace_chars ⇒ String
A value that specifies to replaces the invalid characters specified in
ReplaceInvalidChars
, substituting the specified characters instead. -
#replace_invalid_chars ⇒ String
A list of characters that you want to replace.
-
#secrets_manager_access_role_arn ⇒ String
The full Amazon Resource Name (ARN) of the IAM role that specifies DMS as the trusted entity and grants the required permissions to access the value in
SecretsManagerSecret
. -
#secrets_manager_secret_id ⇒ String
The full ARN, partial ARN, or friendly name of the
SecretsManagerSecret
that contains the Amazon Redshift endpoint connection details. -
#server_name ⇒ String
The name of the Amazon Redshift cluster you are using.
-
#server_side_encryption_kms_key_id ⇒ String
The KMS key ID.
-
#service_access_role_arn ⇒ String
The Amazon Resource Name (ARN) of the IAM role that has access to the Amazon Redshift service.
-
#time_format ⇒ String
The time format that you want to use.
-
#trim_blanks ⇒ Boolean
A value that specifies to remove the trailing white space characters from a VARCHAR string.
-
#truncate_columns ⇒ Boolean
A value that specifies to truncate data in columns to the appropriate number of characters, so that the data fits in the column.
-
#username ⇒ String
An Amazon Redshift user name for a registered user.
-
#write_buffer_size ⇒ Integer
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.
Instance Attribute Details
#accept_any_date ⇒ Boolean
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.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#after_connect_script ⇒ String
Code to run after connecting. This parameter should contain the code itself, not the name of a file containing the code.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#bucket_folder ⇒ String
An S3 folder where the comma-separated-value (.csv) files are stored before being uploaded to the target Redshift cluster.
For full load mode, DMS converts source records into .csv files and
loads them to the BucketFolder/TableID path. 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, DMS creates a NetChanges table, and loads the .csv files to this BucketFolder/NetChangesTableID path.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#bucket_name ⇒ String
The name of the intermediate S3 bucket used to store .csv files before uploading data to Redshift.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#case_sensitive_names ⇒ Boolean
If Amazon Redshift is configured to support case sensitive schema
names, set CaseSensitiveNames
to true
. The default is false
.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#comp_update ⇒ Boolean
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
.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#connection_timeout ⇒ Integer
A value that sets the amount of time to wait (in milliseconds) before timing out, beginning from when you initially establish a connection.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#database_name ⇒ String
The name of the Amazon Redshift data warehouse (service) that you are working with.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#date_format ⇒ String
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
.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#empty_as_null ⇒ Boolean
A value that specifies whether 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
.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#encryption_mode ⇒ String
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
.
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 Identity and Access Management (IAM) role
with a policy that allows "arn:aws:s3:::*"
to use the following
actions: "s3:PutObject", "s3:ListBucket"
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#explicit_ids ⇒ Boolean
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
.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#file_transfer_upload_streams ⇒ Integer
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.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#load_timeout ⇒ Integer
The amount of time to wait (in milliseconds) before timing out of operations performed by DMS on a Redshift cluster, such as Redshift COPY, INSERT, DELETE, and UPDATE.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#map_boolean_as_boolean ⇒ Boolean
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.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#max_file_size ⇒ Integer
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).
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#password ⇒ String
The password for the user named in the username
property.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#port ⇒ Integer
The port number for Amazon Redshift. The default value is 5439.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#remove_quotes ⇒ Boolean
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
.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#replace_chars ⇒ String
A value that specifies to replaces the invalid characters specified
in ReplaceInvalidChars
, substituting the specified characters
instead. The default is "?"
.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#replace_invalid_chars ⇒ String
A list of characters that you want to replace. Use with
ReplaceChars
.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#secrets_manager_access_role_arn ⇒ String
The full Amazon Resource Name (ARN) of the IAM role that specifies
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
Amazon Web Services Secrets Manager secret that allows access to the
Amazon Redshift endpoint.
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 Database
Migration Service resources in the Database Migration Service
User Guide.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#secrets_manager_secret_id ⇒ String
The full ARN, partial ARN, or friendly name of the
SecretsManagerSecret
that contains the Amazon Redshift endpoint
connection details.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#server_name ⇒ String
The name of the Amazon Redshift cluster you are using.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#server_side_encryption_kms_key_id ⇒ String
The 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.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#service_access_role_arn ⇒ String
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.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#time_format ⇒ String
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
.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#trim_blanks ⇒ Boolean
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
.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#truncate_columns ⇒ Boolean
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
.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#username ⇒ String
An Amazon Redshift user name for a registered user.
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |
#write_buffer_size ⇒ Integer
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).
10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 |
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 10549 class RedshiftSettings < Struct.new( :accept_any_date, :after_connect_script, :bucket_folder, :bucket_name, :case_sensitive_names, :comp_update, :connection_timeout, :database_name, :date_format, :empty_as_null, :encryption_mode, :explicit_ids, :file_transfer_upload_streams, :load_timeout, :max_file_size, :password, :port, :remove_quotes, :replace_invalid_chars, :replace_chars, :server_name, :service_access_role_arn, :server_side_encryption_kms_key_id, :time_format, :trim_blanks, :truncate_columns, :username, :write_buffer_size, :secrets_manager_access_role_arn, :secrets_manager_secret_id, :map_boolean_as_boolean) SENSITIVE = [:password] include Aws::Structure end |