Endpoint
Constructors
Properties
Whether to add column name information to the .csv output file. Default is false.
Custom S3 Bucket Object prefix for intermediate storage.
Custom S3 Bucket name for intermediate storage.
Predefined (canned) access control list for objects created in an S3 bucket. Valid values include none, private, public-read, public-read-write, authenticated-read, aws-exec-read, bucket-owner-read, and bucket-owner-full-control. Default is none.
Whether to write insert and update operations to .csv or .parquet output files. Default is false.
Whether to write insert operations to .csv or .parquet output files. Default is false.
Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3. Default is 60.
Minimum file size condition as defined in kilobytes to output a file to Amazon S3. Default is 32000. NOTE: Previously, this setting was measured in megabytes but now represents kilobytes. Update configurations accordingly.
Folder path of CDC files. For an S3 source, this setting is required if a task captures change data; otherwise, it's optional. If cdc_path is set, AWS DMS reads CDC files from this path and replicates the data changes to the target endpoint. Supported in AWS DMS versions 3.4.2 and later.
Set to compress target files. Default is NONE. Valid values are GZIP and NONE.
Delimiter used to separate columns in the source files. Default is ,.
String to use for all columns not included in the supplemental log.
String to as null when writing to the target.
Delimiter used to separate rows in the source files. Default is \n.
Output format for the files that AWS DMS uses to create S3 objects. Valid values are csv and parquet. Default is csv.
Size of one data page in bytes. Default is 1048576 (1 MiB).
Date separating delimiter to use during folder partitioning. Valid values are SLASH, UNDERSCORE, DASH, and NONE. Default is SLASH.
Partition S3 bucket folders based on transaction commit dates. Default is false.
Date format to use during folder partitioning. Use this parameter when date_partition_enabled is set to true. Valid values are YYYYMMDD, YYYYMMDDHH, YYYYMM, MMYYYYDD, and DDMMYYYY. Default is YYYYMMDD.
Maximum size in bytes of an encoded dictionary page of a column. Default is 1048576 (1 MiB).
Whether to enable statistics for Parquet pages and row groups. Default is true.
Type of encoding to use. Value values are rle_dictionary, plain, and plain_dictionary. Default is rle_dictionary.
The server-side encryption mode that you want to encrypt your intermediate .csv object files copied to S3. Defaults to SSE_S3. Valid values are SSE_S3 and SSE_KMS.
JSON document that describes how AWS DMS should interpret the data.
When this value is set to 1, DMS ignores the first row header in a .csv file. Default is 0.
Deprecated. This setting has no effect. Will be removed in a future version.
Whether to enable a full load to write INSERT operations to the .csv output files only to indicate how the rows were added to the source database. Default is false.
Maximum size (in KB) of any .csv file to be created while migrating to an S3 target during full load. Valid values are from 1 to 1048576. Default is 1048576 (1 GB).
Specifies the precision of any TIMESTAMP column values written to an S3 object file in .parquet format. Default is false.
Version of the .parquet file format. Default is parquet-1-0. Valid values are parquet-1-0 and parquet-2-0.
Whether DMS saves the transaction order for a CDC load on the S3 target specified by cdc_path. Default is false.
Number of rows in a row group. Default is 10000.
ARN or Id of KMS Key to use when encryption_mode is SSE_KMS.
ARN of the IAM Role with permissions to write to the OpenSearch cluster.
Column to add with timestamp information to the endpoint data for an Amazon S3 target.
Whether to use csv_no_sup_value for columns not included in the supplemental log.
When set to true, uses the task start time as the timestamp column value instead of the time data is written to target. For full load, when set to true, each row of the timestamp column contains the task start time. For CDC loads, each row of the timestamp column contains the transaction commit time. When set to false, the full load timestamp in the timestamp column increments with the time data arrives at the target. Default is false.