Class: Aws::DatabaseMigrationService::Types::RedshiftSettings

Inherits:
Struct
  • Object
show all
Defined in:
gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb

Overview

Note:

When making an API call, you may pass RedshiftSettings data as a hash:

{
  accept_any_date: false,
  after_connect_script: "String",
  bucket_folder: "String",
  bucket_name: "String",
  case_sensitive_names: false,
  comp_update: false,
  connection_timeout: 1,
  database_name: "String",
  date_format: "String",
  empty_as_null: false,
  encryption_mode: "sse-s3", # accepts sse-s3, sse-kms
  explicit_ids: false,
  file_transfer_upload_streams: 1,
  load_timeout: 1,
  max_file_size: 1,
  password: "SecretString",
  port: 1,
  remove_quotes: false,
  replace_invalid_chars: "String",
  replace_chars: "String",
  server_name: "String",
  service_access_role_arn: "String",
  server_side_encryption_kms_key_id: "String",
  time_format: "String",
  trim_blanks: false,
  truncate_columns: false,
  username: "String",
  write_buffer_size: 1,
}

Provides information that defines an Amazon Redshift endpoint.

Constant Summary collapse

SENSITIVE =
[:password]

Instance Attribute Summary collapse

Instance Attribute Details

#accept_any_dateBoolean

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.

Returns:

  • (Boolean)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#after_connect_scriptString

Code to run after connecting. This parameter should contain the code itself, not the name of a file containing the code.

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#bucket_folderString

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

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#bucket_nameString

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

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#case_sensitive_namesBoolean

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

Returns:

  • (Boolean)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#comp_updateBoolean

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.

Returns:

  • (Boolean)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#connection_timeoutInteger

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

Returns:

  • (Integer)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#database_nameString

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

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#date_formatString

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.

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#empty_as_nullBoolean

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.

Returns:

  • (Boolean)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#encryption_modeString

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"

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#explicit_idsBoolean

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.

Returns:

  • (Boolean)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#file_transfer_upload_streamsInteger

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.

Returns:

  • (Integer)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#load_timeoutInteger

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.

Returns:

  • (Integer)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#max_file_sizeInteger

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

Returns:

  • (Integer)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#passwordString

The password for the user named in the username property.

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#portInteger

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

Returns:

  • (Integer)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#remove_quotesBoolean

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.

Returns:

  • (Boolean)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#replace_charsString

A value that specifies to replaces the invalid characters specified in ReplaceInvalidChars, substituting the specified characters instead. The default is "?".

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#replace_invalid_charsString

A list of characters that you want to replace. Use with ReplaceChars.

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#server_nameString

The name of the Amazon Redshift cluster you are using.

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#server_side_encryption_kms_key_idString

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.

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#service_access_role_arnString

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

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#time_formatString

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.

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#trim_blanksBoolean

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.

Returns:

  • (Boolean)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#truncate_columnsBoolean

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.

Returns:

  • (Boolean)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#usernameString

An Amazon Redshift user name for a registered user.

Returns:

  • (String)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end

#write_buffer_sizeInteger

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

Returns:

  • (Integer)


6377
6378
6379
6380
6381
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6393
6394
6395
6396
6397
6398
6399
6400
6401
6402
6403
6404
6405
6406
6407
6408
# File 'gems/aws-sdk-databasemigrationservice/lib/aws-sdk-databasemigrationservice/types.rb', line 6377

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)
  SENSITIVE = [:password]
  include Aws::Structure
end