aws.dms.S3Endpoint
Explore with Pulumi AI
Provides a DMS (Data Migration Service) S3 endpoint resource. DMS S3 endpoints can be created, updated, deleted, and imported.
Note: AWS is deprecating
extra_connection_attributes
, such as used withaws.dms.Endpoint
. This resource is an alternative toaws.dms.Endpoint
and does not useextra_connection_attributes
. (AWS currently includesextra_connection_attributes
in the raw responses to the AWS Provider requests and so they may be visible in the logs.)
Note: Some of this resource’s arguments have default values that come from the AWS Provider. Other default values are provided by AWS and subject to change without notice. When relying on AWS defaults, the provider state will often have a zero value. For example, the AWS Provider does not provide a default for
cdc_max_batch_interval
but the AWS default is60
(seconds). However, the provider state will show0
since this is the value return by AWS when no value is present. Below, we aim to flag the defaults that come from AWS (e.g., “AWS default…”).
Example Usage
Minimal Configuration
This is the minimal configuration for an aws.dms.S3Endpoint
. This endpoint will rely on the AWS Provider and AWS defaults.
import * as pulumi from "@pulumi/pulumi";
import * as aws from "@pulumi/aws";
const example = new aws.dms.S3Endpoint("example", {
endpointId: "donnedtipi",
endpointType: "target",
bucketName: "beckut_name",
serviceAccessRoleArn: exampleAwsIamRole.arn,
}, {
dependsOn: [exampleAwsIamRolePolicy],
});
import pulumi
import pulumi_aws as aws
example = aws.dms.S3Endpoint("example",
endpoint_id="donnedtipi",
endpoint_type="target",
bucket_name="beckut_name",
service_access_role_arn=example_aws_iam_role["arn"],
opts = pulumi.ResourceOptions(depends_on=[example_aws_iam_role_policy]))
package main
import (
"github.com/pulumi/pulumi-aws/sdk/v6/go/aws/dms"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := dms.NewS3Endpoint(ctx, "example", &dms.S3EndpointArgs{
EndpointId: pulumi.String("donnedtipi"),
EndpointType: pulumi.String("target"),
BucketName: pulumi.String("beckut_name"),
ServiceAccessRoleArn: pulumi.Any(exampleAwsIamRole.Arn),
}, pulumi.DependsOn([]pulumi.Resource{
exampleAwsIamRolePolicy,
}))
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Aws = Pulumi.Aws;
return await Deployment.RunAsync(() =>
{
var example = new Aws.Dms.S3Endpoint("example", new()
{
EndpointId = "donnedtipi",
EndpointType = "target",
BucketName = "beckut_name",
ServiceAccessRoleArn = exampleAwsIamRole.Arn,
}, new CustomResourceOptions
{
DependsOn =
{
exampleAwsIamRolePolicy,
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.aws.dms.S3Endpoint;
import com.pulumi.aws.dms.S3EndpointArgs;
import com.pulumi.resources.CustomResourceOptions;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var example = new S3Endpoint("example", S3EndpointArgs.builder()
.endpointId("donnedtipi")
.endpointType("target")
.bucketName("beckut_name")
.serviceAccessRoleArn(exampleAwsIamRole.arn())
.build(), CustomResourceOptions.builder()
.dependsOn(exampleAwsIamRolePolicy)
.build());
}
}
resources:
example:
type: aws:dms:S3Endpoint
properties:
endpointId: donnedtipi
endpointType: target
bucketName: beckut_name
serviceAccessRoleArn: ${exampleAwsIamRole.arn}
options:
dependson:
- ${exampleAwsIamRolePolicy}
Complete Configuration
import * as pulumi from "@pulumi/pulumi";
import * as aws from "@pulumi/aws";
const example = new aws.dms.S3Endpoint("example", {
endpointId: "donnedtipi",
endpointType: "target",
sslMode: "none",
tags: {
Name: "donnedtipi",
Update: "to-update",
Remove: "to-remove",
},
addColumnName: true,
addTrailingPaddingCharacter: false,
bucketFolder: "folder",
bucketName: "bucket_name",
cannedAclForObjects: "private",
cdcInsertsAndUpdates: true,
cdcInsertsOnly: false,
cdcMaxBatchInterval: 100,
cdcMinFileSize: 16,
cdcPath: "cdc/path",
compressionType: "GZIP",
csvDelimiter: ";",
csvNoSupValue: "x",
csvNullValue: "?",
csvRowDelimiter: "\\r\\n",
dataFormat: "parquet",
dataPageSize: 1100000,
datePartitionDelimiter: "UNDERSCORE",
datePartitionEnabled: true,
datePartitionSequence: "yyyymmddhh",
datePartitionTimezone: "Asia/Seoul",
dictPageSizeLimit: 1000000,
enableStatistics: false,
encodingType: "plain",
encryptionMode: "SSE_S3",
expectedBucketOwner: current.accountId,
externalTableDefinition: "etd",
ignoreHeaderRows: 1,
includeOpForFullLoad: true,
maxFileSize: 1000000,
parquetTimestampInMillisecond: true,
parquetVersion: "parquet-2-0",
preserveTransactions: false,
rfc4180: false,
rowGroupLength: 11000,
serverSideEncryptionKmsKeyId: exampleAwsKmsKey.arn,
serviceAccessRoleArn: exampleAwsIamRole.arn,
timestampColumnName: "tx_commit_time",
useCsvNoSupValue: false,
useTaskStartTimeForFullLoadTimestamp: true,
glueCatalogGeneration: true,
}, {
dependsOn: [exampleAwsIamRolePolicy],
});
import pulumi
import pulumi_aws as aws
example = aws.dms.S3Endpoint("example",
endpoint_id="donnedtipi",
endpoint_type="target",
ssl_mode="none",
tags={
"Name": "donnedtipi",
"Update": "to-update",
"Remove": "to-remove",
},
add_column_name=True,
add_trailing_padding_character=False,
bucket_folder="folder",
bucket_name="bucket_name",
canned_acl_for_objects="private",
cdc_inserts_and_updates=True,
cdc_inserts_only=False,
cdc_max_batch_interval=100,
cdc_min_file_size=16,
cdc_path="cdc/path",
compression_type="GZIP",
csv_delimiter=";",
csv_no_sup_value="x",
csv_null_value="?",
csv_row_delimiter="\\r\\n",
data_format="parquet",
data_page_size=1100000,
date_partition_delimiter="UNDERSCORE",
date_partition_enabled=True,
date_partition_sequence="yyyymmddhh",
date_partition_timezone="Asia/Seoul",
dict_page_size_limit=1000000,
enable_statistics=False,
encoding_type="plain",
encryption_mode="SSE_S3",
expected_bucket_owner=current["accountId"],
external_table_definition="etd",
ignore_header_rows=1,
include_op_for_full_load=True,
max_file_size=1000000,
parquet_timestamp_in_millisecond=True,
parquet_version="parquet-2-0",
preserve_transactions=False,
rfc4180=False,
row_group_length=11000,
server_side_encryption_kms_key_id=example_aws_kms_key["arn"],
service_access_role_arn=example_aws_iam_role["arn"],
timestamp_column_name="tx_commit_time",
use_csv_no_sup_value=False,
use_task_start_time_for_full_load_timestamp=True,
glue_catalog_generation=True,
opts = pulumi.ResourceOptions(depends_on=[example_aws_iam_role_policy]))
package main
import (
"github.com/pulumi/pulumi-aws/sdk/v6/go/aws/dms"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := dms.NewS3Endpoint(ctx, "example", &dms.S3EndpointArgs{
EndpointId: pulumi.String("donnedtipi"),
EndpointType: pulumi.String("target"),
SslMode: pulumi.String("none"),
Tags: pulumi.StringMap{
"Name": pulumi.String("donnedtipi"),
"Update": pulumi.String("to-update"),
"Remove": pulumi.String("to-remove"),
},
AddColumnName: pulumi.Bool(true),
AddTrailingPaddingCharacter: pulumi.Bool(false),
BucketFolder: pulumi.String("folder"),
BucketName: pulumi.String("bucket_name"),
CannedAclForObjects: pulumi.String("private"),
CdcInsertsAndUpdates: pulumi.Bool(true),
CdcInsertsOnly: pulumi.Bool(false),
CdcMaxBatchInterval: pulumi.Int(100),
CdcMinFileSize: pulumi.Int(16),
CdcPath: pulumi.String("cdc/path"),
CompressionType: pulumi.String("GZIP"),
CsvDelimiter: pulumi.String(";"),
CsvNoSupValue: pulumi.String("x"),
CsvNullValue: pulumi.String("?"),
CsvRowDelimiter: pulumi.String("\\r\\n"),
DataFormat: pulumi.String("parquet"),
DataPageSize: pulumi.Int(1100000),
DatePartitionDelimiter: pulumi.String("UNDERSCORE"),
DatePartitionEnabled: pulumi.Bool(true),
DatePartitionSequence: pulumi.String("yyyymmddhh"),
DatePartitionTimezone: pulumi.String("Asia/Seoul"),
DictPageSizeLimit: pulumi.Int(1000000),
EnableStatistics: pulumi.Bool(false),
EncodingType: pulumi.String("plain"),
EncryptionMode: pulumi.String("SSE_S3"),
ExpectedBucketOwner: pulumi.Any(current.AccountId),
ExternalTableDefinition: pulumi.String("etd"),
IgnoreHeaderRows: pulumi.Int(1),
IncludeOpForFullLoad: pulumi.Bool(true),
MaxFileSize: pulumi.Int(1000000),
ParquetTimestampInMillisecond: pulumi.Bool(true),
ParquetVersion: pulumi.String("parquet-2-0"),
PreserveTransactions: pulumi.Bool(false),
Rfc4180: pulumi.Bool(false),
RowGroupLength: pulumi.Int(11000),
ServerSideEncryptionKmsKeyId: pulumi.Any(exampleAwsKmsKey.Arn),
ServiceAccessRoleArn: pulumi.Any(exampleAwsIamRole.Arn),
TimestampColumnName: pulumi.String("tx_commit_time"),
UseCsvNoSupValue: pulumi.Bool(false),
UseTaskStartTimeForFullLoadTimestamp: pulumi.Bool(true),
GlueCatalogGeneration: pulumi.Bool(true),
}, pulumi.DependsOn([]pulumi.Resource{
exampleAwsIamRolePolicy,
}))
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Aws = Pulumi.Aws;
return await Deployment.RunAsync(() =>
{
var example = new Aws.Dms.S3Endpoint("example", new()
{
EndpointId = "donnedtipi",
EndpointType = "target",
SslMode = "none",
Tags =
{
{ "Name", "donnedtipi" },
{ "Update", "to-update" },
{ "Remove", "to-remove" },
},
AddColumnName = true,
AddTrailingPaddingCharacter = false,
BucketFolder = "folder",
BucketName = "bucket_name",
CannedAclForObjects = "private",
CdcInsertsAndUpdates = true,
CdcInsertsOnly = false,
CdcMaxBatchInterval = 100,
CdcMinFileSize = 16,
CdcPath = "cdc/path",
CompressionType = "GZIP",
CsvDelimiter = ";",
CsvNoSupValue = "x",
CsvNullValue = "?",
CsvRowDelimiter = "\\r\\n",
DataFormat = "parquet",
DataPageSize = 1100000,
DatePartitionDelimiter = "UNDERSCORE",
DatePartitionEnabled = true,
DatePartitionSequence = "yyyymmddhh",
DatePartitionTimezone = "Asia/Seoul",
DictPageSizeLimit = 1000000,
EnableStatistics = false,
EncodingType = "plain",
EncryptionMode = "SSE_S3",
ExpectedBucketOwner = current.AccountId,
ExternalTableDefinition = "etd",
IgnoreHeaderRows = 1,
IncludeOpForFullLoad = true,
MaxFileSize = 1000000,
ParquetTimestampInMillisecond = true,
ParquetVersion = "parquet-2-0",
PreserveTransactions = false,
Rfc4180 = false,
RowGroupLength = 11000,
ServerSideEncryptionKmsKeyId = exampleAwsKmsKey.Arn,
ServiceAccessRoleArn = exampleAwsIamRole.Arn,
TimestampColumnName = "tx_commit_time",
UseCsvNoSupValue = false,
UseTaskStartTimeForFullLoadTimestamp = true,
GlueCatalogGeneration = true,
}, new CustomResourceOptions
{
DependsOn =
{
exampleAwsIamRolePolicy,
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.aws.dms.S3Endpoint;
import com.pulumi.aws.dms.S3EndpointArgs;
import com.pulumi.resources.CustomResourceOptions;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var example = new S3Endpoint("example", S3EndpointArgs.builder()
.endpointId("donnedtipi")
.endpointType("target")
.sslMode("none")
.tags(Map.ofEntries(
Map.entry("Name", "donnedtipi"),
Map.entry("Update", "to-update"),
Map.entry("Remove", "to-remove")
))
.addColumnName(true)
.addTrailingPaddingCharacter(false)
.bucketFolder("folder")
.bucketName("bucket_name")
.cannedAclForObjects("private")
.cdcInsertsAndUpdates(true)
.cdcInsertsOnly(false)
.cdcMaxBatchInterval(100)
.cdcMinFileSize(16)
.cdcPath("cdc/path")
.compressionType("GZIP")
.csvDelimiter(";")
.csvNoSupValue("x")
.csvNullValue("?")
.csvRowDelimiter("\\r\\n")
.dataFormat("parquet")
.dataPageSize(1100000)
.datePartitionDelimiter("UNDERSCORE")
.datePartitionEnabled(true)
.datePartitionSequence("yyyymmddhh")
.datePartitionTimezone("Asia/Seoul")
.dictPageSizeLimit(1000000)
.enableStatistics(false)
.encodingType("plain")
.encryptionMode("SSE_S3")
.expectedBucketOwner(current.accountId())
.externalTableDefinition("etd")
.ignoreHeaderRows(1)
.includeOpForFullLoad(true)
.maxFileSize(1000000)
.parquetTimestampInMillisecond(true)
.parquetVersion("parquet-2-0")
.preserveTransactions(false)
.rfc4180(false)
.rowGroupLength(11000)
.serverSideEncryptionKmsKeyId(exampleAwsKmsKey.arn())
.serviceAccessRoleArn(exampleAwsIamRole.arn())
.timestampColumnName("tx_commit_time")
.useCsvNoSupValue(false)
.useTaskStartTimeForFullLoadTimestamp(true)
.glueCatalogGeneration(true)
.build(), CustomResourceOptions.builder()
.dependsOn(exampleAwsIamRolePolicy)
.build());
}
}
resources:
example:
type: aws:dms:S3Endpoint
properties:
endpointId: donnedtipi
endpointType: target
sslMode: none
tags:
Name: donnedtipi
Update: to-update
Remove: to-remove
addColumnName: true
addTrailingPaddingCharacter: false
bucketFolder: folder
bucketName: bucket_name
cannedAclForObjects: private
cdcInsertsAndUpdates: true
cdcInsertsOnly: false
cdcMaxBatchInterval: 100
cdcMinFileSize: 16
cdcPath: cdc/path
compressionType: GZIP
csvDelimiter: ;
csvNoSupValue: x
csvNullValue: '?'
csvRowDelimiter: \r\n
dataFormat: parquet
dataPageSize: 1.1e+06
datePartitionDelimiter: UNDERSCORE
datePartitionEnabled: true
datePartitionSequence: yyyymmddhh
datePartitionTimezone: Asia/Seoul
dictPageSizeLimit: 1e+06
enableStatistics: false
encodingType: plain
encryptionMode: SSE_S3
expectedBucketOwner: ${current.accountId}
externalTableDefinition: etd
ignoreHeaderRows: 1
includeOpForFullLoad: true
maxFileSize: 1e+06
parquetTimestampInMillisecond: true
parquetVersion: parquet-2-0
preserveTransactions: false
rfc4180: false
rowGroupLength: 11000
serverSideEncryptionKmsKeyId: ${exampleAwsKmsKey.arn}
serviceAccessRoleArn: ${exampleAwsIamRole.arn}
timestampColumnName: tx_commit_time
useCsvNoSupValue: false
useTaskStartTimeForFullLoadTimestamp: true
glueCatalogGeneration: true
options:
dependson:
- ${exampleAwsIamRolePolicy}
Create S3Endpoint Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new S3Endpoint(name: string, args: S3EndpointArgs, opts?: CustomResourceOptions);
@overload
def S3Endpoint(resource_name: str,
args: S3EndpointArgs,
opts: Optional[ResourceOptions] = None)
@overload
def S3Endpoint(resource_name: str,
opts: Optional[ResourceOptions] = None,
endpoint_id: Optional[str] = None,
service_access_role_arn: Optional[str] = None,
endpoint_type: Optional[str] = None,
bucket_name: Optional[str] = None,
enable_statistics: Optional[bool] = None,
cdc_max_batch_interval: Optional[int] = None,
cdc_inserts_only: Optional[bool] = None,
encoding_type: Optional[str] = None,
cdc_min_file_size: Optional[int] = None,
cdc_path: Optional[str] = None,
certificate_arn: Optional[str] = None,
compression_type: Optional[str] = None,
csv_delimiter: Optional[str] = None,
csv_no_sup_value: Optional[str] = None,
add_column_name: Optional[bool] = None,
csv_row_delimiter: Optional[str] = None,
encryption_mode: Optional[str] = None,
data_page_size: Optional[int] = None,
date_partition_delimiter: Optional[str] = None,
date_partition_enabled: Optional[bool] = None,
date_partition_sequence: Optional[str] = None,
date_partition_timezone: Optional[str] = None,
detach_target_on_lob_lookup_failure_parquet: Optional[bool] = None,
dict_page_size_limit: Optional[int] = None,
csv_null_value: Optional[str] = None,
cdc_inserts_and_updates: Optional[bool] = None,
data_format: Optional[str] = None,
canned_acl_for_objects: Optional[str] = None,
bucket_folder: Optional[str] = None,
expected_bucket_owner: Optional[str] = None,
external_table_definition: Optional[str] = None,
glue_catalog_generation: Optional[bool] = None,
ignore_header_rows: Optional[int] = None,
include_op_for_full_load: Optional[bool] = None,
kms_key_arn: Optional[str] = None,
max_file_size: Optional[int] = None,
parquet_timestamp_in_millisecond: Optional[bool] = None,
parquet_version: Optional[str] = None,
preserve_transactions: Optional[bool] = None,
rfc4180: Optional[bool] = None,
row_group_length: Optional[int] = None,
server_side_encryption_kms_key_id: Optional[str] = None,
add_trailing_padding_character: Optional[bool] = None,
ssl_mode: Optional[str] = None,
tags: Optional[Mapping[str, str]] = None,
timestamp_column_name: Optional[str] = None,
use_csv_no_sup_value: Optional[bool] = None,
use_task_start_time_for_full_load_timestamp: Optional[bool] = None)
func NewS3Endpoint(ctx *Context, name string, args S3EndpointArgs, opts ...ResourceOption) (*S3Endpoint, error)
public S3Endpoint(string name, S3EndpointArgs args, CustomResourceOptions? opts = null)
public S3Endpoint(String name, S3EndpointArgs args)
public S3Endpoint(String name, S3EndpointArgs args, CustomResourceOptions options)
type: aws:dms:S3Endpoint
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args S3EndpointArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args S3EndpointArgs
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args S3EndpointArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args S3EndpointArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args S3EndpointArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var s3endpointResource = new Aws.Dms.S3Endpoint("s3endpointResource", new()
{
EndpointId = "string",
ServiceAccessRoleArn = "string",
EndpointType = "string",
BucketName = "string",
EnableStatistics = false,
CdcMaxBatchInterval = 0,
CdcInsertsOnly = false,
EncodingType = "string",
CdcMinFileSize = 0,
CdcPath = "string",
CertificateArn = "string",
CompressionType = "string",
CsvDelimiter = "string",
CsvNoSupValue = "string",
AddColumnName = false,
CsvRowDelimiter = "string",
EncryptionMode = "string",
DataPageSize = 0,
DatePartitionDelimiter = "string",
DatePartitionEnabled = false,
DatePartitionSequence = "string",
DatePartitionTimezone = "string",
DetachTargetOnLobLookupFailureParquet = false,
DictPageSizeLimit = 0,
CsvNullValue = "string",
CdcInsertsAndUpdates = false,
DataFormat = "string",
CannedAclForObjects = "string",
BucketFolder = "string",
ExpectedBucketOwner = "string",
ExternalTableDefinition = "string",
GlueCatalogGeneration = false,
IgnoreHeaderRows = 0,
IncludeOpForFullLoad = false,
KmsKeyArn = "string",
MaxFileSize = 0,
ParquetTimestampInMillisecond = false,
ParquetVersion = "string",
PreserveTransactions = false,
Rfc4180 = false,
RowGroupLength = 0,
ServerSideEncryptionKmsKeyId = "string",
AddTrailingPaddingCharacter = false,
SslMode = "string",
Tags =
{
{ "string", "string" },
},
TimestampColumnName = "string",
UseCsvNoSupValue = false,
UseTaskStartTimeForFullLoadTimestamp = false,
});
example, err := dms.NewS3Endpoint(ctx, "s3endpointResource", &dms.S3EndpointArgs{
EndpointId: pulumi.String("string"),
ServiceAccessRoleArn: pulumi.String("string"),
EndpointType: pulumi.String("string"),
BucketName: pulumi.String("string"),
EnableStatistics: pulumi.Bool(false),
CdcMaxBatchInterval: pulumi.Int(0),
CdcInsertsOnly: pulumi.Bool(false),
EncodingType: pulumi.String("string"),
CdcMinFileSize: pulumi.Int(0),
CdcPath: pulumi.String("string"),
CertificateArn: pulumi.String("string"),
CompressionType: pulumi.String("string"),
CsvDelimiter: pulumi.String("string"),
CsvNoSupValue: pulumi.String("string"),
AddColumnName: pulumi.Bool(false),
CsvRowDelimiter: pulumi.String("string"),
EncryptionMode: pulumi.String("string"),
DataPageSize: pulumi.Int(0),
DatePartitionDelimiter: pulumi.String("string"),
DatePartitionEnabled: pulumi.Bool(false),
DatePartitionSequence: pulumi.String("string"),
DatePartitionTimezone: pulumi.String("string"),
DetachTargetOnLobLookupFailureParquet: pulumi.Bool(false),
DictPageSizeLimit: pulumi.Int(0),
CsvNullValue: pulumi.String("string"),
CdcInsertsAndUpdates: pulumi.Bool(false),
DataFormat: pulumi.String("string"),
CannedAclForObjects: pulumi.String("string"),
BucketFolder: pulumi.String("string"),
ExpectedBucketOwner: pulumi.String("string"),
ExternalTableDefinition: pulumi.String("string"),
GlueCatalogGeneration: pulumi.Bool(false),
IgnoreHeaderRows: pulumi.Int(0),
IncludeOpForFullLoad: pulumi.Bool(false),
KmsKeyArn: pulumi.String("string"),
MaxFileSize: pulumi.Int(0),
ParquetTimestampInMillisecond: pulumi.Bool(false),
ParquetVersion: pulumi.String("string"),
PreserveTransactions: pulumi.Bool(false),
Rfc4180: pulumi.Bool(false),
RowGroupLength: pulumi.Int(0),
ServerSideEncryptionKmsKeyId: pulumi.String("string"),
AddTrailingPaddingCharacter: pulumi.Bool(false),
SslMode: pulumi.String("string"),
Tags: pulumi.StringMap{
"string": pulumi.String("string"),
},
TimestampColumnName: pulumi.String("string"),
UseCsvNoSupValue: pulumi.Bool(false),
UseTaskStartTimeForFullLoadTimestamp: pulumi.Bool(false),
})
var s3endpointResource = new S3Endpoint("s3endpointResource", S3EndpointArgs.builder()
.endpointId("string")
.serviceAccessRoleArn("string")
.endpointType("string")
.bucketName("string")
.enableStatistics(false)
.cdcMaxBatchInterval(0)
.cdcInsertsOnly(false)
.encodingType("string")
.cdcMinFileSize(0)
.cdcPath("string")
.certificateArn("string")
.compressionType("string")
.csvDelimiter("string")
.csvNoSupValue("string")
.addColumnName(false)
.csvRowDelimiter("string")
.encryptionMode("string")
.dataPageSize(0)
.datePartitionDelimiter("string")
.datePartitionEnabled(false)
.datePartitionSequence("string")
.datePartitionTimezone("string")
.detachTargetOnLobLookupFailureParquet(false)
.dictPageSizeLimit(0)
.csvNullValue("string")
.cdcInsertsAndUpdates(false)
.dataFormat("string")
.cannedAclForObjects("string")
.bucketFolder("string")
.expectedBucketOwner("string")
.externalTableDefinition("string")
.glueCatalogGeneration(false)
.ignoreHeaderRows(0)
.includeOpForFullLoad(false)
.kmsKeyArn("string")
.maxFileSize(0)
.parquetTimestampInMillisecond(false)
.parquetVersion("string")
.preserveTransactions(false)
.rfc4180(false)
.rowGroupLength(0)
.serverSideEncryptionKmsKeyId("string")
.addTrailingPaddingCharacter(false)
.sslMode("string")
.tags(Map.of("string", "string"))
.timestampColumnName("string")
.useCsvNoSupValue(false)
.useTaskStartTimeForFullLoadTimestamp(false)
.build());
s3endpoint_resource = aws.dms.S3Endpoint("s3endpointResource",
endpoint_id="string",
service_access_role_arn="string",
endpoint_type="string",
bucket_name="string",
enable_statistics=False,
cdc_max_batch_interval=0,
cdc_inserts_only=False,
encoding_type="string",
cdc_min_file_size=0,
cdc_path="string",
certificate_arn="string",
compression_type="string",
csv_delimiter="string",
csv_no_sup_value="string",
add_column_name=False,
csv_row_delimiter="string",
encryption_mode="string",
data_page_size=0,
date_partition_delimiter="string",
date_partition_enabled=False,
date_partition_sequence="string",
date_partition_timezone="string",
detach_target_on_lob_lookup_failure_parquet=False,
dict_page_size_limit=0,
csv_null_value="string",
cdc_inserts_and_updates=False,
data_format="string",
canned_acl_for_objects="string",
bucket_folder="string",
expected_bucket_owner="string",
external_table_definition="string",
glue_catalog_generation=False,
ignore_header_rows=0,
include_op_for_full_load=False,
kms_key_arn="string",
max_file_size=0,
parquet_timestamp_in_millisecond=False,
parquet_version="string",
preserve_transactions=False,
rfc4180=False,
row_group_length=0,
server_side_encryption_kms_key_id="string",
add_trailing_padding_character=False,
ssl_mode="string",
tags={
"string": "string",
},
timestamp_column_name="string",
use_csv_no_sup_value=False,
use_task_start_time_for_full_load_timestamp=False)
const s3endpointResource = new aws.dms.S3Endpoint("s3endpointResource", {
endpointId: "string",
serviceAccessRoleArn: "string",
endpointType: "string",
bucketName: "string",
enableStatistics: false,
cdcMaxBatchInterval: 0,
cdcInsertsOnly: false,
encodingType: "string",
cdcMinFileSize: 0,
cdcPath: "string",
certificateArn: "string",
compressionType: "string",
csvDelimiter: "string",
csvNoSupValue: "string",
addColumnName: false,
csvRowDelimiter: "string",
encryptionMode: "string",
dataPageSize: 0,
datePartitionDelimiter: "string",
datePartitionEnabled: false,
datePartitionSequence: "string",
datePartitionTimezone: "string",
detachTargetOnLobLookupFailureParquet: false,
dictPageSizeLimit: 0,
csvNullValue: "string",
cdcInsertsAndUpdates: false,
dataFormat: "string",
cannedAclForObjects: "string",
bucketFolder: "string",
expectedBucketOwner: "string",
externalTableDefinition: "string",
glueCatalogGeneration: false,
ignoreHeaderRows: 0,
includeOpForFullLoad: false,
kmsKeyArn: "string",
maxFileSize: 0,
parquetTimestampInMillisecond: false,
parquetVersion: "string",
preserveTransactions: false,
rfc4180: false,
rowGroupLength: 0,
serverSideEncryptionKmsKeyId: "string",
addTrailingPaddingCharacter: false,
sslMode: "string",
tags: {
string: "string",
},
timestampColumnName: "string",
useCsvNoSupValue: false,
useTaskStartTimeForFullLoadTimestamp: false,
});
type: aws:dms:S3Endpoint
properties:
addColumnName: false
addTrailingPaddingCharacter: false
bucketFolder: string
bucketName: string
cannedAclForObjects: string
cdcInsertsAndUpdates: false
cdcInsertsOnly: false
cdcMaxBatchInterval: 0
cdcMinFileSize: 0
cdcPath: string
certificateArn: string
compressionType: string
csvDelimiter: string
csvNoSupValue: string
csvNullValue: string
csvRowDelimiter: string
dataFormat: string
dataPageSize: 0
datePartitionDelimiter: string
datePartitionEnabled: false
datePartitionSequence: string
datePartitionTimezone: string
detachTargetOnLobLookupFailureParquet: false
dictPageSizeLimit: 0
enableStatistics: false
encodingType: string
encryptionMode: string
endpointId: string
endpointType: string
expectedBucketOwner: string
externalTableDefinition: string
glueCatalogGeneration: false
ignoreHeaderRows: 0
includeOpForFullLoad: false
kmsKeyArn: string
maxFileSize: 0
parquetTimestampInMillisecond: false
parquetVersion: string
preserveTransactions: false
rfc4180: false
rowGroupLength: 0
serverSideEncryptionKmsKeyId: string
serviceAccessRoleArn: string
sslMode: string
tags:
string: string
timestampColumnName: string
useCsvNoSupValue: false
useTaskStartTimeForFullLoadTimestamp: false
S3Endpoint Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The S3Endpoint resource accepts the following input properties:
- Bucket
Name string - S3 bucket name.
- Endpoint
Id string - Database endpoint identifier. Identifiers must contain from 1 to 255 alphanumeric characters or hyphens, begin with a letter, contain only ASCII letters, digits, and hyphens, not end with a hyphen, and not contain two consecutive hyphens.
- Endpoint
Type string - Type of endpoint. Valid values are
source
,target
. - Service
Access stringRole Arn ARN of the IAM role with permissions to the S3 Bucket.
The following arguments are optional:
- Add
Column boolName - Whether to add column name information to the .csv output file. Default is
false
. - Add
Trailing boolPadding Character - Whether to add padding. Default is
false
. (Ignored for source endpoints.) - Bucket
Folder string - S3 object prefix.
- Canned
Acl stringFor Objects - 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
, andbucket-owner-full-control
. Default isnone
. - Cdc
Inserts boolAnd Updates - Whether to write insert and update operations to .csv or .parquet output files. Default is
false
. - Cdc
Inserts boolOnly - Whether to write insert operations to .csv or .parquet output files. Default is
false
. - Cdc
Max intBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3. (AWS default is
60
.) - Cdc
Min intFile Size - Minimum file size condition as defined in kilobytes to output a file to Amazon S3. (AWS default is 32000 KB.)
- Cdc
Path string - Folder path of CDC files. 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. - Certificate
Arn string - ARN for the certificate.
- Compression
Type string - Set to compress target files. Valid values are
GZIP
andNONE
. Default isNONE
. (Ignored for source endpoints.) - Csv
Delimiter string - Delimiter used to separate columns in the source files. Default is
,
. - Csv
No stringSup Value - Only applies if output files for a CDC load are written in .csv format. If
use_csv_no_sup_value
is set totrue
, string to use for all columns not included in the supplemental log. If you do not specify a string value, DMS uses the null value for these columns regardless ofuse_csv_no_sup_value
. (Ignored for source endpoints.) - Csv
Null stringValue - String to as null when writing to the target. (AWS default is
NULL
.) - Csv
Row stringDelimiter - Delimiter used to separate rows in the source files. Default is newline (i.e.,
\n
). - Data
Format string - Output format for the files that AWS DMS uses to create S3 objects. Valid values are
csv
andparquet
. (Ignored for source endpoints -- onlycsv
is valid.) - Data
Page intSize - Size of one data page in bytes. (AWS default is 1 MiB, i.e.,
1048576
.) - Date
Partition stringDelimiter - Date separating delimiter to use during folder partitioning. Valid values are
SLASH
,UNDERSCORE
,DASH
, andNONE
. (AWS default isSLASH
.) (Ignored for source endpoints.) - Date
Partition boolEnabled - Partition S3 bucket folders based on transaction commit dates. Default is
false
. (Ignored for source endpoints.) - Date
Partition stringSequence - Date format to use during folder partitioning. Use this parameter when
date_partition_enabled
is set to true. Valid values areYYYYMMDD
,YYYYMMDDHH
,YYYYMM
,MMYYYYDD
, andDDMMYYYY
. (AWS default isYYYYMMDD
.) (Ignored for source endpoints.) - Date
Partition stringTimezone - Convert the current UTC time to a timezone. The conversion occurs when a date partition folder is created and a CDC filename is generated. The timezone format is Area/Location (e.g.,
Europe/Paris
). Use this whendate_partition_enabled
istrue
. (Ignored for source endpoints.) - Detach
Target boolOn Lob Lookup Failure Parquet - Undocumented argument for use as directed by AWS Support.
- Dict
Page intSize Limit - Maximum size in bytes of an encoded dictionary page of a column. (AWS default is 1 MiB, i.e.,
1048576
.) - Enable
Statistics bool - Whether to enable statistics for Parquet pages and row groups. Default is
true
. - Encoding
Type string - Type of encoding to use. Value values are
rle_dictionary
,plain
, andplain_dictionary
. (AWS default isrle_dictionary
.) - Encryption
Mode string - Server-side encryption mode that you want to encrypt your .csv or .parquet object files copied to S3. Valid values are
SSE_S3
andSSE_KMS
. (AWS default isSSE_S3
.) (Ignored for source endpoints -- onlySSE_S3
is valid.) - Expected
Bucket stringOwner - Bucket owner to prevent sniping. Value is an AWS account ID.
- External
Table stringDefinition - JSON document that describes how AWS DMS should interpret the data.
- Glue
Catalog boolGeneration - Whether to integrate AWS Glue Data Catalog with an Amazon S3 target. See Using AWS Glue Data Catalog with an Amazon S3 target for AWS DMS for more information. Default is
false
. - Ignore
Header intRows - When this value is set to
1
, DMS ignores the first row header in a .csv file. (AWS default is0
.) - Include
Op boolFor Full Load - 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
. - Kms
Key stringArn - ARN for the KMS key that will be used to encrypt the connection parameters. If you do not specify a value for
kms_key_arn
, then AWS DMS will use your default encryption key. AWS KMS creates the default encryption key for your AWS account. Your AWS account has a different default encryption key for each AWS region. - Max
File intSize - 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
to1048576
. (AWS default is 1 GB, i.e.,1048576
.) - Parquet
Timestamp boolIn Millisecond - Specifies the precision of any TIMESTAMP column values written to an S3 object file in .parquet format. Default is
false
. (Ignored for source endpoints.) - Parquet
Version string - Version of the .parquet file format. Valid values are
parquet-1-0
andparquet-2-0
. (AWS default isparquet-1-0
.) (Ignored for source endpoints.) - Preserve
Transactions bool - Whether DMS saves the transaction order for a CDC load on the S3 target specified by
cdc_path
. Default isfalse
. (Ignored for source endpoints.) - Rfc4180 bool
- For an S3 source, whether each leading double quotation mark has to be followed by an ending double quotation mark. Default is
true
. - Row
Group intLength - Number of rows in a row group. (AWS default is
10000
.) - Server
Side stringEncryption Kms Key Id - When
encryption_mode
isSSE_KMS
, ARN for the AWS KMS key. (Ignored for source endpoints -- onlySSE_S3
encryption_mode
is valid.) - Ssl
Mode string - SSL mode to use for the connection. Valid values are
none
,require
,verify-ca
,verify-full
. (AWS default isnone
.) - Dictionary<string, string>
- Map of tags to assign to the resource. If configured with a provider
default_tags
configuration block present, tags with matching keys will overwrite those defined at the provider-level. - Timestamp
Column stringName - Column to add with timestamp information to the endpoint data for an Amazon S3 target.
- Use
Csv boolNo Sup Value - Whether to use
csv_no_sup_value
for columns not included in the supplemental log. (Ignored for source endpoints.) - Use
Task boolStart Time For Full Load Timestamp - 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 totrue
, 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 isfalse
.
- Bucket
Name string - S3 bucket name.
- Endpoint
Id string - Database endpoint identifier. Identifiers must contain from 1 to 255 alphanumeric characters or hyphens, begin with a letter, contain only ASCII letters, digits, and hyphens, not end with a hyphen, and not contain two consecutive hyphens.
- Endpoint
Type string - Type of endpoint. Valid values are
source
,target
. - Service
Access stringRole Arn ARN of the IAM role with permissions to the S3 Bucket.
The following arguments are optional:
- Add
Column boolName - Whether to add column name information to the .csv output file. Default is
false
. - Add
Trailing boolPadding Character - Whether to add padding. Default is
false
. (Ignored for source endpoints.) - Bucket
Folder string - S3 object prefix.
- Canned
Acl stringFor Objects - 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
, andbucket-owner-full-control
. Default isnone
. - Cdc
Inserts boolAnd Updates - Whether to write insert and update operations to .csv or .parquet output files. Default is
false
. - Cdc
Inserts boolOnly - Whether to write insert operations to .csv or .parquet output files. Default is
false
. - Cdc
Max intBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3. (AWS default is
60
.) - Cdc
Min intFile Size - Minimum file size condition as defined in kilobytes to output a file to Amazon S3. (AWS default is 32000 KB.)
- Cdc
Path string - Folder path of CDC files. 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. - Certificate
Arn string - ARN for the certificate.
- Compression
Type string - Set to compress target files. Valid values are
GZIP
andNONE
. Default isNONE
. (Ignored for source endpoints.) - Csv
Delimiter string - Delimiter used to separate columns in the source files. Default is
,
. - Csv
No stringSup Value - Only applies if output files for a CDC load are written in .csv format. If
use_csv_no_sup_value
is set totrue
, string to use for all columns not included in the supplemental log. If you do not specify a string value, DMS uses the null value for these columns regardless ofuse_csv_no_sup_value
. (Ignored for source endpoints.) - Csv
Null stringValue - String to as null when writing to the target. (AWS default is
NULL
.) - Csv
Row stringDelimiter - Delimiter used to separate rows in the source files. Default is newline (i.e.,
\n
). - Data
Format string - Output format for the files that AWS DMS uses to create S3 objects. Valid values are
csv
andparquet
. (Ignored for source endpoints -- onlycsv
is valid.) - Data
Page intSize - Size of one data page in bytes. (AWS default is 1 MiB, i.e.,
1048576
.) - Date
Partition stringDelimiter - Date separating delimiter to use during folder partitioning. Valid values are
SLASH
,UNDERSCORE
,DASH
, andNONE
. (AWS default isSLASH
.) (Ignored for source endpoints.) - Date
Partition boolEnabled - Partition S3 bucket folders based on transaction commit dates. Default is
false
. (Ignored for source endpoints.) - Date
Partition stringSequence - Date format to use during folder partitioning. Use this parameter when
date_partition_enabled
is set to true. Valid values areYYYYMMDD
,YYYYMMDDHH
,YYYYMM
,MMYYYYDD
, andDDMMYYYY
. (AWS default isYYYYMMDD
.) (Ignored for source endpoints.) - Date
Partition stringTimezone - Convert the current UTC time to a timezone. The conversion occurs when a date partition folder is created and a CDC filename is generated. The timezone format is Area/Location (e.g.,
Europe/Paris
). Use this whendate_partition_enabled
istrue
. (Ignored for source endpoints.) - Detach
Target boolOn Lob Lookup Failure Parquet - Undocumented argument for use as directed by AWS Support.
- Dict
Page intSize Limit - Maximum size in bytes of an encoded dictionary page of a column. (AWS default is 1 MiB, i.e.,
1048576
.) - Enable
Statistics bool - Whether to enable statistics for Parquet pages and row groups. Default is
true
. - Encoding
Type string - Type of encoding to use. Value values are
rle_dictionary
,plain
, andplain_dictionary
. (AWS default isrle_dictionary
.) - Encryption
Mode string - Server-side encryption mode that you want to encrypt your .csv or .parquet object files copied to S3. Valid values are
SSE_S3
andSSE_KMS
. (AWS default isSSE_S3
.) (Ignored for source endpoints -- onlySSE_S3
is valid.) - Expected
Bucket stringOwner - Bucket owner to prevent sniping. Value is an AWS account ID.
- External
Table stringDefinition - JSON document that describes how AWS DMS should interpret the data.
- Glue
Catalog boolGeneration - Whether to integrate AWS Glue Data Catalog with an Amazon S3 target. See Using AWS Glue Data Catalog with an Amazon S3 target for AWS DMS for more information. Default is
false
. - Ignore
Header intRows - When this value is set to
1
, DMS ignores the first row header in a .csv file. (AWS default is0
.) - Include
Op boolFor Full Load - 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
. - Kms
Key stringArn - ARN for the KMS key that will be used to encrypt the connection parameters. If you do not specify a value for
kms_key_arn
, then AWS DMS will use your default encryption key. AWS KMS creates the default encryption key for your AWS account. Your AWS account has a different default encryption key for each AWS region. - Max
File intSize - 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
to1048576
. (AWS default is 1 GB, i.e.,1048576
.) - Parquet
Timestamp boolIn Millisecond - Specifies the precision of any TIMESTAMP column values written to an S3 object file in .parquet format. Default is
false
. (Ignored for source endpoints.) - Parquet
Version string - Version of the .parquet file format. Valid values are
parquet-1-0
andparquet-2-0
. (AWS default isparquet-1-0
.) (Ignored for source endpoints.) - Preserve
Transactions bool - Whether DMS saves the transaction order for a CDC load on the S3 target specified by
cdc_path
. Default isfalse
. (Ignored for source endpoints.) - Rfc4180 bool
- For an S3 source, whether each leading double quotation mark has to be followed by an ending double quotation mark. Default is
true
. - Row
Group intLength - Number of rows in a row group. (AWS default is
10000
.) - Server
Side stringEncryption Kms Key Id - When
encryption_mode
isSSE_KMS
, ARN for the AWS KMS key. (Ignored for source endpoints -- onlySSE_S3
encryption_mode
is valid.) - Ssl
Mode string - SSL mode to use for the connection. Valid values are
none
,require
,verify-ca
,verify-full
. (AWS default isnone
.) - map[string]string
- Map of tags to assign to the resource. If configured with a provider
default_tags
configuration block present, tags with matching keys will overwrite those defined at the provider-level. - Timestamp
Column stringName - Column to add with timestamp information to the endpoint data for an Amazon S3 target.
- Use
Csv boolNo Sup Value - Whether to use
csv_no_sup_value
for columns not included in the supplemental log. (Ignored for source endpoints.) - Use
Task boolStart Time For Full Load Timestamp - 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 totrue
, 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 isfalse
.
- bucket
Name String - S3 bucket name.
- endpoint
Id String - Database endpoint identifier. Identifiers must contain from 1 to 255 alphanumeric characters or hyphens, begin with a letter, contain only ASCII letters, digits, and hyphens, not end with a hyphen, and not contain two consecutive hyphens.
- endpoint
Type String - Type of endpoint. Valid values are
source
,target
. - service
Access StringRole Arn ARN of the IAM role with permissions to the S3 Bucket.
The following arguments are optional:
- add
Column BooleanName - Whether to add column name information to the .csv output file. Default is
false
. - add
Trailing BooleanPadding Character - Whether to add padding. Default is
false
. (Ignored for source endpoints.) - bucket
Folder String - S3 object prefix.
- canned
Acl StringFor Objects - 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
, andbucket-owner-full-control
. Default isnone
. - cdc
Inserts BooleanAnd Updates - Whether to write insert and update operations to .csv or .parquet output files. Default is
false
. - cdc
Inserts BooleanOnly - Whether to write insert operations to .csv or .parquet output files. Default is
false
. - cdc
Max IntegerBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3. (AWS default is
60
.) - cdc
Min IntegerFile Size - Minimum file size condition as defined in kilobytes to output a file to Amazon S3. (AWS default is 32000 KB.)
- cdc
Path String - Folder path of CDC files. 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. - certificate
Arn String - ARN for the certificate.
- compression
Type String - Set to compress target files. Valid values are
GZIP
andNONE
. Default isNONE
. (Ignored for source endpoints.) - csv
Delimiter String - Delimiter used to separate columns in the source files. Default is
,
. - csv
No StringSup Value - Only applies if output files for a CDC load are written in .csv format. If
use_csv_no_sup_value
is set totrue
, string to use for all columns not included in the supplemental log. If you do not specify a string value, DMS uses the null value for these columns regardless ofuse_csv_no_sup_value
. (Ignored for source endpoints.) - csv
Null StringValue - String to as null when writing to the target. (AWS default is
NULL
.) - csv
Row StringDelimiter - Delimiter used to separate rows in the source files. Default is newline (i.e.,
\n
). - data
Format String - Output format for the files that AWS DMS uses to create S3 objects. Valid values are
csv
andparquet
. (Ignored for source endpoints -- onlycsv
is valid.) - data
Page IntegerSize - Size of one data page in bytes. (AWS default is 1 MiB, i.e.,
1048576
.) - date
Partition StringDelimiter - Date separating delimiter to use during folder partitioning. Valid values are
SLASH
,UNDERSCORE
,DASH
, andNONE
. (AWS default isSLASH
.) (Ignored for source endpoints.) - date
Partition BooleanEnabled - Partition S3 bucket folders based on transaction commit dates. Default is
false
. (Ignored for source endpoints.) - date
Partition StringSequence - Date format to use during folder partitioning. Use this parameter when
date_partition_enabled
is set to true. Valid values areYYYYMMDD
,YYYYMMDDHH
,YYYYMM
,MMYYYYDD
, andDDMMYYYY
. (AWS default isYYYYMMDD
.) (Ignored for source endpoints.) - date
Partition StringTimezone - Convert the current UTC time to a timezone. The conversion occurs when a date partition folder is created and a CDC filename is generated. The timezone format is Area/Location (e.g.,
Europe/Paris
). Use this whendate_partition_enabled
istrue
. (Ignored for source endpoints.) - detach
Target BooleanOn Lob Lookup Failure Parquet - Undocumented argument for use as directed by AWS Support.
- dict
Page IntegerSize Limit - Maximum size in bytes of an encoded dictionary page of a column. (AWS default is 1 MiB, i.e.,
1048576
.) - enable
Statistics Boolean - Whether to enable statistics for Parquet pages and row groups. Default is
true
. - encoding
Type String - Type of encoding to use. Value values are
rle_dictionary
,plain
, andplain_dictionary
. (AWS default isrle_dictionary
.) - encryption
Mode String - Server-side encryption mode that you want to encrypt your .csv or .parquet object files copied to S3. Valid values are
SSE_S3
andSSE_KMS
. (AWS default isSSE_S3
.) (Ignored for source endpoints -- onlySSE_S3
is valid.) - expected
Bucket StringOwner - Bucket owner to prevent sniping. Value is an AWS account ID.
- external
Table StringDefinition - JSON document that describes how AWS DMS should interpret the data.
- glue
Catalog BooleanGeneration - Whether to integrate AWS Glue Data Catalog with an Amazon S3 target. See Using AWS Glue Data Catalog with an Amazon S3 target for AWS DMS for more information. Default is
false
. - ignore
Header IntegerRows - When this value is set to
1
, DMS ignores the first row header in a .csv file. (AWS default is0
.) - include
Op BooleanFor Full Load - 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
. - kms
Key StringArn - ARN for the KMS key that will be used to encrypt the connection parameters. If you do not specify a value for
kms_key_arn
, then AWS DMS will use your default encryption key. AWS KMS creates the default encryption key for your AWS account. Your AWS account has a different default encryption key for each AWS region. - max
File IntegerSize - 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
to1048576
. (AWS default is 1 GB, i.e.,1048576
.) - parquet
Timestamp BooleanIn Millisecond - Specifies the precision of any TIMESTAMP column values written to an S3 object file in .parquet format. Default is
false
. (Ignored for source endpoints.) - parquet
Version String - Version of the .parquet file format. Valid values are
parquet-1-0
andparquet-2-0
. (AWS default isparquet-1-0
.) (Ignored for source endpoints.) - preserve
Transactions Boolean - Whether DMS saves the transaction order for a CDC load on the S3 target specified by
cdc_path
. Default isfalse
. (Ignored for source endpoints.) - rfc4180 Boolean
- For an S3 source, whether each leading double quotation mark has to be followed by an ending double quotation mark. Default is
true
. - row
Group IntegerLength - Number of rows in a row group. (AWS default is
10000
.) - server
Side StringEncryption Kms Key Id - When
encryption_mode
isSSE_KMS
, ARN for the AWS KMS key. (Ignored for source endpoints -- onlySSE_S3
encryption_mode
is valid.) - ssl
Mode String - SSL mode to use for the connection. Valid values are
none
,require
,verify-ca
,verify-full
. (AWS default isnone
.) - Map<String,String>
- Map of tags to assign to the resource. If configured with a provider
default_tags
configuration block present, tags with matching keys will overwrite those defined at the provider-level. - timestamp
Column StringName - Column to add with timestamp information to the endpoint data for an Amazon S3 target.
- use
Csv BooleanNo Sup Value - Whether to use
csv_no_sup_value
for columns not included in the supplemental log. (Ignored for source endpoints.) - use
Task BooleanStart Time For Full Load Timestamp - 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 totrue
, 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 isfalse
.
- bucket
Name string - S3 bucket name.
- endpoint
Id string - Database endpoint identifier. Identifiers must contain from 1 to 255 alphanumeric characters or hyphens, begin with a letter, contain only ASCII letters, digits, and hyphens, not end with a hyphen, and not contain two consecutive hyphens.
- endpoint
Type string - Type of endpoint. Valid values are
source
,target
. - service
Access stringRole Arn ARN of the IAM role with permissions to the S3 Bucket.
The following arguments are optional:
- add
Column booleanName - Whether to add column name information to the .csv output file. Default is
false
. - add
Trailing booleanPadding Character - Whether to add padding. Default is
false
. (Ignored for source endpoints.) - bucket
Folder string - S3 object prefix.
- canned
Acl stringFor Objects - 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
, andbucket-owner-full-control
. Default isnone
. - cdc
Inserts booleanAnd Updates - Whether to write insert and update operations to .csv or .parquet output files. Default is
false
. - cdc
Inserts booleanOnly - Whether to write insert operations to .csv or .parquet output files. Default is
false
. - cdc
Max numberBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3. (AWS default is
60
.) - cdc
Min numberFile Size - Minimum file size condition as defined in kilobytes to output a file to Amazon S3. (AWS default is 32000 KB.)
- cdc
Path string - Folder path of CDC files. 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. - certificate
Arn string - ARN for the certificate.
- compression
Type string - Set to compress target files. Valid values are
GZIP
andNONE
. Default isNONE
. (Ignored for source endpoints.) - csv
Delimiter string - Delimiter used to separate columns in the source files. Default is
,
. - csv
No stringSup Value - Only applies if output files for a CDC load are written in .csv format. If
use_csv_no_sup_value
is set totrue
, string to use for all columns not included in the supplemental log. If you do not specify a string value, DMS uses the null value for these columns regardless ofuse_csv_no_sup_value
. (Ignored for source endpoints.) - csv
Null stringValue - String to as null when writing to the target. (AWS default is
NULL
.) - csv
Row stringDelimiter - Delimiter used to separate rows in the source files. Default is newline (i.e.,
\n
). - data
Format string - Output format for the files that AWS DMS uses to create S3 objects. Valid values are
csv
andparquet
. (Ignored for source endpoints -- onlycsv
is valid.) - data
Page numberSize - Size of one data page in bytes. (AWS default is 1 MiB, i.e.,
1048576
.) - date
Partition stringDelimiter - Date separating delimiter to use during folder partitioning. Valid values are
SLASH
,UNDERSCORE
,DASH
, andNONE
. (AWS default isSLASH
.) (Ignored for source endpoints.) - date
Partition booleanEnabled - Partition S3 bucket folders based on transaction commit dates. Default is
false
. (Ignored for source endpoints.) - date
Partition stringSequence - Date format to use during folder partitioning. Use this parameter when
date_partition_enabled
is set to true. Valid values areYYYYMMDD
,YYYYMMDDHH
,YYYYMM
,MMYYYYDD
, andDDMMYYYY
. (AWS default isYYYYMMDD
.) (Ignored for source endpoints.) - date
Partition stringTimezone - Convert the current UTC time to a timezone. The conversion occurs when a date partition folder is created and a CDC filename is generated. The timezone format is Area/Location (e.g.,
Europe/Paris
). Use this whendate_partition_enabled
istrue
. (Ignored for source endpoints.) - detach
Target booleanOn Lob Lookup Failure Parquet - Undocumented argument for use as directed by AWS Support.
- dict
Page numberSize Limit - Maximum size in bytes of an encoded dictionary page of a column. (AWS default is 1 MiB, i.e.,
1048576
.) - enable
Statistics boolean - Whether to enable statistics for Parquet pages and row groups. Default is
true
. - encoding
Type string - Type of encoding to use. Value values are
rle_dictionary
,plain
, andplain_dictionary
. (AWS default isrle_dictionary
.) - encryption
Mode string - Server-side encryption mode that you want to encrypt your .csv or .parquet object files copied to S3. Valid values are
SSE_S3
andSSE_KMS
. (AWS default isSSE_S3
.) (Ignored for source endpoints -- onlySSE_S3
is valid.) - expected
Bucket stringOwner - Bucket owner to prevent sniping. Value is an AWS account ID.
- external
Table stringDefinition - JSON document that describes how AWS DMS should interpret the data.
- glue
Catalog booleanGeneration - Whether to integrate AWS Glue Data Catalog with an Amazon S3 target. See Using AWS Glue Data Catalog with an Amazon S3 target for AWS DMS for more information. Default is
false
. - ignore
Header numberRows - When this value is set to
1
, DMS ignores the first row header in a .csv file. (AWS default is0
.) - include
Op booleanFor Full Load - 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
. - kms
Key stringArn - ARN for the KMS key that will be used to encrypt the connection parameters. If you do not specify a value for
kms_key_arn
, then AWS DMS will use your default encryption key. AWS KMS creates the default encryption key for your AWS account. Your AWS account has a different default encryption key for each AWS region. - max
File numberSize - 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
to1048576
. (AWS default is 1 GB, i.e.,1048576
.) - parquet
Timestamp booleanIn Millisecond - Specifies the precision of any TIMESTAMP column values written to an S3 object file in .parquet format. Default is
false
. (Ignored for source endpoints.) - parquet
Version string - Version of the .parquet file format. Valid values are
parquet-1-0
andparquet-2-0
. (AWS default isparquet-1-0
.) (Ignored for source endpoints.) - preserve
Transactions boolean - Whether DMS saves the transaction order for a CDC load on the S3 target specified by
cdc_path
. Default isfalse
. (Ignored for source endpoints.) - rfc4180 boolean
- For an S3 source, whether each leading double quotation mark has to be followed by an ending double quotation mark. Default is
true
. - row
Group numberLength - Number of rows in a row group. (AWS default is
10000
.) - server
Side stringEncryption Kms Key Id - When
encryption_mode
isSSE_KMS
, ARN for the AWS KMS key. (Ignored for source endpoints -- onlySSE_S3
encryption_mode
is valid.) - ssl
Mode string - SSL mode to use for the connection. Valid values are
none
,require
,verify-ca
,verify-full
. (AWS default isnone
.) - {[key: string]: string}
- Map of tags to assign to the resource. If configured with a provider
default_tags
configuration block present, tags with matching keys will overwrite those defined at the provider-level. - timestamp
Column stringName - Column to add with timestamp information to the endpoint data for an Amazon S3 target.
- use
Csv booleanNo Sup Value - Whether to use
csv_no_sup_value
for columns not included in the supplemental log. (Ignored for source endpoints.) - use
Task booleanStart Time For Full Load Timestamp - 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 totrue
, 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 isfalse
.
- bucket_
name str - S3 bucket name.
- endpoint_
id str - Database endpoint identifier. Identifiers must contain from 1 to 255 alphanumeric characters or hyphens, begin with a letter, contain only ASCII letters, digits, and hyphens, not end with a hyphen, and not contain two consecutive hyphens.
- endpoint_
type str - Type of endpoint. Valid values are
source
,target
. - service_
access_ strrole_ arn ARN of the IAM role with permissions to the S3 Bucket.
The following arguments are optional:
- add_
column_ boolname - Whether to add column name information to the .csv output file. Default is
false
. - add_
trailing_ boolpadding_ character - Whether to add padding. Default is
false
. (Ignored for source endpoints.) - bucket_
folder str - S3 object prefix.
- canned_
acl_ strfor_ objects - 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
, andbucket-owner-full-control
. Default isnone
. - cdc_
inserts_ booland_ updates - Whether to write insert and update operations to .csv or .parquet output files. Default is
false
. - cdc_
inserts_ boolonly - Whether to write insert operations to .csv or .parquet output files. Default is
false
. - cdc_
max_ intbatch_ interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3. (AWS default is
60
.) - cdc_
min_ intfile_ size - Minimum file size condition as defined in kilobytes to output a file to Amazon S3. (AWS default is 32000 KB.)
- cdc_
path str - Folder path of CDC files. 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. - certificate_
arn str - ARN for the certificate.
- compression_
type str - Set to compress target files. Valid values are
GZIP
andNONE
. Default isNONE
. (Ignored for source endpoints.) - csv_
delimiter str - Delimiter used to separate columns in the source files. Default is
,
. - csv_
no_ strsup_ value - Only applies if output files for a CDC load are written in .csv format. If
use_csv_no_sup_value
is set totrue
, string to use for all columns not included in the supplemental log. If you do not specify a string value, DMS uses the null value for these columns regardless ofuse_csv_no_sup_value
. (Ignored for source endpoints.) - csv_
null_ strvalue - String to as null when writing to the target. (AWS default is
NULL
.) - csv_
row_ strdelimiter - Delimiter used to separate rows in the source files. Default is newline (i.e.,
\n
). - data_
format str - Output format for the files that AWS DMS uses to create S3 objects. Valid values are
csv
andparquet
. (Ignored for source endpoints -- onlycsv
is valid.) - data_
page_ intsize - Size of one data page in bytes. (AWS default is 1 MiB, i.e.,
1048576
.) - date_
partition_ strdelimiter - Date separating delimiter to use during folder partitioning. Valid values are
SLASH
,UNDERSCORE
,DASH
, andNONE
. (AWS default isSLASH
.) (Ignored for source endpoints.) - date_
partition_ boolenabled - Partition S3 bucket folders based on transaction commit dates. Default is
false
. (Ignored for source endpoints.) - date_
partition_ strsequence - Date format to use during folder partitioning. Use this parameter when
date_partition_enabled
is set to true. Valid values areYYYYMMDD
,YYYYMMDDHH
,YYYYMM
,MMYYYYDD
, andDDMMYYYY
. (AWS default isYYYYMMDD
.) (Ignored for source endpoints.) - date_
partition_ strtimezone - Convert the current UTC time to a timezone. The conversion occurs when a date partition folder is created and a CDC filename is generated. The timezone format is Area/Location (e.g.,
Europe/Paris
). Use this whendate_partition_enabled
istrue
. (Ignored for source endpoints.) - detach_
target_ boolon_ lob_ lookup_ failure_ parquet - Undocumented argument for use as directed by AWS Support.
- dict_
page_ intsize_ limit - Maximum size in bytes of an encoded dictionary page of a column. (AWS default is 1 MiB, i.e.,
1048576
.) - enable_
statistics bool - Whether to enable statistics for Parquet pages and row groups. Default is
true
. - encoding_
type str - Type of encoding to use. Value values are
rle_dictionary
,plain
, andplain_dictionary
. (AWS default isrle_dictionary
.) - encryption_
mode str - Server-side encryption mode that you want to encrypt your .csv or .parquet object files copied to S3. Valid values are
SSE_S3
andSSE_KMS
. (AWS default isSSE_S3
.) (Ignored for source endpoints -- onlySSE_S3
is valid.) - expected_
bucket_ strowner - Bucket owner to prevent sniping. Value is an AWS account ID.
- external_
table_ strdefinition - JSON document that describes how AWS DMS should interpret the data.
- glue_
catalog_ boolgeneration - Whether to integrate AWS Glue Data Catalog with an Amazon S3 target. See Using AWS Glue Data Catalog with an Amazon S3 target for AWS DMS for more information. Default is
false
. - ignore_
header_ introws - When this value is set to
1
, DMS ignores the first row header in a .csv file. (AWS default is0
.) - include_
op_ boolfor_ full_ load - 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
. - kms_
key_ strarn - ARN for the KMS key that will be used to encrypt the connection parameters. If you do not specify a value for
kms_key_arn
, then AWS DMS will use your default encryption key. AWS KMS creates the default encryption key for your AWS account. Your AWS account has a different default encryption key for each AWS region. - max_
file_ intsize - 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
to1048576
. (AWS default is 1 GB, i.e.,1048576
.) - parquet_
timestamp_ boolin_ millisecond - Specifies the precision of any TIMESTAMP column values written to an S3 object file in .parquet format. Default is
false
. (Ignored for source endpoints.) - parquet_
version str - Version of the .parquet file format. Valid values are
parquet-1-0
andparquet-2-0
. (AWS default isparquet-1-0
.) (Ignored for source endpoints.) - preserve_
transactions bool - Whether DMS saves the transaction order for a CDC load on the S3 target specified by
cdc_path
. Default isfalse
. (Ignored for source endpoints.) - rfc4180 bool
- For an S3 source, whether each leading double quotation mark has to be followed by an ending double quotation mark. Default is
true
. - row_
group_ intlength - Number of rows in a row group. (AWS default is
10000
.) - server_
side_ strencryption_ kms_ key_ id - When
encryption_mode
isSSE_KMS
, ARN for the AWS KMS key. (Ignored for source endpoints -- onlySSE_S3
encryption_mode
is valid.) - ssl_
mode str - SSL mode to use for the connection. Valid values are
none
,require
,verify-ca
,verify-full
. (AWS default isnone
.) - Mapping[str, str]
- Map of tags to assign to the resource. If configured with a provider
default_tags
configuration block present, tags with matching keys will overwrite those defined at the provider-level. - timestamp_
column_ strname - Column to add with timestamp information to the endpoint data for an Amazon S3 target.
- use_
csv_ boolno_ sup_ value - Whether to use
csv_no_sup_value
for columns not included in the supplemental log. (Ignored for source endpoints.) - use_
task_ boolstart_ time_ for_ full_ load_ timestamp - 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 totrue
, 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 isfalse
.
- bucket
Name String - S3 bucket name.
- endpoint
Id String - Database endpoint identifier. Identifiers must contain from 1 to 255 alphanumeric characters or hyphens, begin with a letter, contain only ASCII letters, digits, and hyphens, not end with a hyphen, and not contain two consecutive hyphens.
- endpoint
Type String - Type of endpoint. Valid values are
source
,target
. - service
Access StringRole Arn ARN of the IAM role with permissions to the S3 Bucket.
The following arguments are optional:
- add
Column BooleanName - Whether to add column name information to the .csv output file. Default is
false
. - add
Trailing BooleanPadding Character - Whether to add padding. Default is
false
. (Ignored for source endpoints.) - bucket
Folder String - S3 object prefix.
- canned
Acl StringFor Objects - 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
, andbucket-owner-full-control
. Default isnone
. - cdc
Inserts BooleanAnd Updates - Whether to write insert and update operations to .csv or .parquet output files. Default is
false
. - cdc
Inserts BooleanOnly - Whether to write insert operations to .csv or .parquet output files. Default is
false
. - cdc
Max NumberBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3. (AWS default is
60
.) - cdc
Min NumberFile Size - Minimum file size condition as defined in kilobytes to output a file to Amazon S3. (AWS default is 32000 KB.)
- cdc
Path String - Folder path of CDC files. 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. - certificate
Arn String - ARN for the certificate.
- compression
Type String - Set to compress target files. Valid values are
GZIP
andNONE
. Default isNONE
. (Ignored for source endpoints.) - csv
Delimiter String - Delimiter used to separate columns in the source files. Default is
,
. - csv
No StringSup Value - Only applies if output files for a CDC load are written in .csv format. If
use_csv_no_sup_value
is set totrue
, string to use for all columns not included in the supplemental log. If you do not specify a string value, DMS uses the null value for these columns regardless ofuse_csv_no_sup_value
. (Ignored for source endpoints.) - csv
Null StringValue - String to as null when writing to the target. (AWS default is
NULL
.) - csv
Row StringDelimiter - Delimiter used to separate rows in the source files. Default is newline (i.e.,
\n
). - data
Format String - Output format for the files that AWS DMS uses to create S3 objects. Valid values are
csv
andparquet
. (Ignored for source endpoints -- onlycsv
is valid.) - data
Page NumberSize - Size of one data page in bytes. (AWS default is 1 MiB, i.e.,
1048576
.) - date
Partition StringDelimiter - Date separating delimiter to use during folder partitioning. Valid values are
SLASH
,UNDERSCORE
,DASH
, andNONE
. (AWS default isSLASH
.) (Ignored for source endpoints.) - date
Partition BooleanEnabled - Partition S3 bucket folders based on transaction commit dates. Default is
false
. (Ignored for source endpoints.) - date
Partition StringSequence - Date format to use during folder partitioning. Use this parameter when
date_partition_enabled
is set to true. Valid values areYYYYMMDD
,YYYYMMDDHH
,YYYYMM
,MMYYYYDD
, andDDMMYYYY
. (AWS default isYYYYMMDD
.) (Ignored for source endpoints.) - date
Partition StringTimezone - Convert the current UTC time to a timezone. The conversion occurs when a date partition folder is created and a CDC filename is generated. The timezone format is Area/Location (e.g.,
Europe/Paris
). Use this whendate_partition_enabled
istrue
. (Ignored for source endpoints.) - detach
Target BooleanOn Lob Lookup Failure Parquet - Undocumented argument for use as directed by AWS Support.
- dict
Page NumberSize Limit - Maximum size in bytes of an encoded dictionary page of a column. (AWS default is 1 MiB, i.e.,
1048576
.) - enable
Statistics Boolean - Whether to enable statistics for Parquet pages and row groups. Default is
true
. - encoding
Type String - Type of encoding to use. Value values are
rle_dictionary
,plain
, andplain_dictionary
. (AWS default isrle_dictionary
.) - encryption
Mode String - Server-side encryption mode that you want to encrypt your .csv or .parquet object files copied to S3. Valid values are
SSE_S3
andSSE_KMS
. (AWS default isSSE_S3
.) (Ignored for source endpoints -- onlySSE_S3
is valid.) - expected
Bucket StringOwner - Bucket owner to prevent sniping. Value is an AWS account ID.
- external
Table StringDefinition - JSON document that describes how AWS DMS should interpret the data.
- glue
Catalog BooleanGeneration - Whether to integrate AWS Glue Data Catalog with an Amazon S3 target. See Using AWS Glue Data Catalog with an Amazon S3 target for AWS DMS for more information. Default is
false
. - ignore
Header NumberRows - When this value is set to
1
, DMS ignores the first row header in a .csv file. (AWS default is0
.) - include
Op BooleanFor Full Load - 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
. - kms
Key StringArn - ARN for the KMS key that will be used to encrypt the connection parameters. If you do not specify a value for
kms_key_arn
, then AWS DMS will use your default encryption key. AWS KMS creates the default encryption key for your AWS account. Your AWS account has a different default encryption key for each AWS region. - max
File NumberSize - 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
to1048576
. (AWS default is 1 GB, i.e.,1048576
.) - parquet
Timestamp BooleanIn Millisecond - Specifies the precision of any TIMESTAMP column values written to an S3 object file in .parquet format. Default is
false
. (Ignored for source endpoints.) - parquet
Version String - Version of the .parquet file format. Valid values are
parquet-1-0
andparquet-2-0
. (AWS default isparquet-1-0
.) (Ignored for source endpoints.) - preserve
Transactions Boolean - Whether DMS saves the transaction order for a CDC load on the S3 target specified by
cdc_path
. Default isfalse
. (Ignored for source endpoints.) - rfc4180 Boolean
- For an S3 source, whether each leading double quotation mark has to be followed by an ending double quotation mark. Default is
true
. - row
Group NumberLength - Number of rows in a row group. (AWS default is
10000
.) - server
Side StringEncryption Kms Key Id - When
encryption_mode
isSSE_KMS
, ARN for the AWS KMS key. (Ignored for source endpoints -- onlySSE_S3
encryption_mode
is valid.) - ssl
Mode String - SSL mode to use for the connection. Valid values are
none
,require
,verify-ca
,verify-full
. (AWS default isnone
.) - Map<String>
- Map of tags to assign to the resource. If configured with a provider
default_tags
configuration block present, tags with matching keys will overwrite those defined at the provider-level. - timestamp
Column StringName - Column to add with timestamp information to the endpoint data for an Amazon S3 target.
- use
Csv BooleanNo Sup Value - Whether to use
csv_no_sup_value
for columns not included in the supplemental log. (Ignored for source endpoints.) - use
Task BooleanStart Time For Full Load Timestamp - 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 totrue
, 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 isfalse
.
Outputs
All input properties are implicitly available as output properties. Additionally, the S3Endpoint resource produces the following output properties:
- Endpoint
Arn string - ARN for the endpoint.
- Engine
Display stringName - Expanded name for the engine name.
- External
Id string - Can be used for cross-account validation. Use it in another account with
aws.dms.S3Endpoint
to create the endpoint cross-account. - Id string
- The provider-assigned unique ID for this managed resource.
- Status string
- Status of the endpoint.
- Dictionary<string, string>
- Map of tags assigned to the resource, including those inherited from the provider
default_tags
configuration block.
- Endpoint
Arn string - ARN for the endpoint.
- Engine
Display stringName - Expanded name for the engine name.
- External
Id string - Can be used for cross-account validation. Use it in another account with
aws.dms.S3Endpoint
to create the endpoint cross-account. - Id string
- The provider-assigned unique ID for this managed resource.
- Status string
- Status of the endpoint.
- map[string]string
- Map of tags assigned to the resource, including those inherited from the provider
default_tags
configuration block.
- endpoint
Arn String - ARN for the endpoint.
- engine
Display StringName - Expanded name for the engine name.
- external
Id String - Can be used for cross-account validation. Use it in another account with
aws.dms.S3Endpoint
to create the endpoint cross-account. - id String
- The provider-assigned unique ID for this managed resource.
- status String
- Status of the endpoint.
- Map<String,String>
- Map of tags assigned to the resource, including those inherited from the provider
default_tags
configuration block.
- endpoint
Arn string - ARN for the endpoint.
- engine
Display stringName - Expanded name for the engine name.
- external
Id string - Can be used for cross-account validation. Use it in another account with
aws.dms.S3Endpoint
to create the endpoint cross-account. - id string
- The provider-assigned unique ID for this managed resource.
- status string
- Status of the endpoint.
- {[key: string]: string}
- Map of tags assigned to the resource, including those inherited from the provider
default_tags
configuration block.
- endpoint_
arn str - ARN for the endpoint.
- engine_
display_ strname - Expanded name for the engine name.
- external_
id str - Can be used for cross-account validation. Use it in another account with
aws.dms.S3Endpoint
to create the endpoint cross-account. - id str
- The provider-assigned unique ID for this managed resource.
- status str
- Status of the endpoint.
- Mapping[str, str]
- Map of tags assigned to the resource, including those inherited from the provider
default_tags
configuration block.
- endpoint
Arn String - ARN for the endpoint.
- engine
Display StringName - Expanded name for the engine name.
- external
Id String - Can be used for cross-account validation. Use it in another account with
aws.dms.S3Endpoint
to create the endpoint cross-account. - id String
- The provider-assigned unique ID for this managed resource.
- status String
- Status of the endpoint.
- Map<String>
- Map of tags assigned to the resource, including those inherited from the provider
default_tags
configuration block.
Look up Existing S3Endpoint Resource
Get an existing S3Endpoint resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: S3EndpointState, opts?: CustomResourceOptions): S3Endpoint
@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
add_column_name: Optional[bool] = None,
add_trailing_padding_character: Optional[bool] = None,
bucket_folder: Optional[str] = None,
bucket_name: Optional[str] = None,
canned_acl_for_objects: Optional[str] = None,
cdc_inserts_and_updates: Optional[bool] = None,
cdc_inserts_only: Optional[bool] = None,
cdc_max_batch_interval: Optional[int] = None,
cdc_min_file_size: Optional[int] = None,
cdc_path: Optional[str] = None,
certificate_arn: Optional[str] = None,
compression_type: Optional[str] = None,
csv_delimiter: Optional[str] = None,
csv_no_sup_value: Optional[str] = None,
csv_null_value: Optional[str] = None,
csv_row_delimiter: Optional[str] = None,
data_format: Optional[str] = None,
data_page_size: Optional[int] = None,
date_partition_delimiter: Optional[str] = None,
date_partition_enabled: Optional[bool] = None,
date_partition_sequence: Optional[str] = None,
date_partition_timezone: Optional[str] = None,
detach_target_on_lob_lookup_failure_parquet: Optional[bool] = None,
dict_page_size_limit: Optional[int] = None,
enable_statistics: Optional[bool] = None,
encoding_type: Optional[str] = None,
encryption_mode: Optional[str] = None,
endpoint_arn: Optional[str] = None,
endpoint_id: Optional[str] = None,
endpoint_type: Optional[str] = None,
engine_display_name: Optional[str] = None,
expected_bucket_owner: Optional[str] = None,
external_id: Optional[str] = None,
external_table_definition: Optional[str] = None,
glue_catalog_generation: Optional[bool] = None,
ignore_header_rows: Optional[int] = None,
include_op_for_full_load: Optional[bool] = None,
kms_key_arn: Optional[str] = None,
max_file_size: Optional[int] = None,
parquet_timestamp_in_millisecond: Optional[bool] = None,
parquet_version: Optional[str] = None,
preserve_transactions: Optional[bool] = None,
rfc4180: Optional[bool] = None,
row_group_length: Optional[int] = None,
server_side_encryption_kms_key_id: Optional[str] = None,
service_access_role_arn: Optional[str] = None,
ssl_mode: Optional[str] = None,
status: Optional[str] = None,
tags: Optional[Mapping[str, str]] = None,
tags_all: Optional[Mapping[str, str]] = None,
timestamp_column_name: Optional[str] = None,
use_csv_no_sup_value: Optional[bool] = None,
use_task_start_time_for_full_load_timestamp: Optional[bool] = None) -> S3Endpoint
func GetS3Endpoint(ctx *Context, name string, id IDInput, state *S3EndpointState, opts ...ResourceOption) (*S3Endpoint, error)
public static S3Endpoint Get(string name, Input<string> id, S3EndpointState? state, CustomResourceOptions? opts = null)
public static S3Endpoint get(String name, Output<String> id, S3EndpointState state, CustomResourceOptions options)
Resource lookup is not supported in YAML
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Add
Column boolName - Whether to add column name information to the .csv output file. Default is
false
. - Add
Trailing boolPadding Character - Whether to add padding. Default is
false
. (Ignored for source endpoints.) - Bucket
Folder string - S3 object prefix.
- Bucket
Name string - S3 bucket name.
- Canned
Acl stringFor Objects - 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
, andbucket-owner-full-control
. Default isnone
. - Cdc
Inserts boolAnd Updates - Whether to write insert and update operations to .csv or .parquet output files. Default is
false
. - Cdc
Inserts boolOnly - Whether to write insert operations to .csv or .parquet output files. Default is
false
. - Cdc
Max intBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3. (AWS default is
60
.) - Cdc
Min intFile Size - Minimum file size condition as defined in kilobytes to output a file to Amazon S3. (AWS default is 32000 KB.)
- Cdc
Path string - Folder path of CDC files. 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. - Certificate
Arn string - ARN for the certificate.
- Compression
Type string - Set to compress target files. Valid values are
GZIP
andNONE
. Default isNONE
. (Ignored for source endpoints.) - Csv
Delimiter string - Delimiter used to separate columns in the source files. Default is
,
. - Csv
No stringSup Value - Only applies if output files for a CDC load are written in .csv format. If
use_csv_no_sup_value
is set totrue
, string to use for all columns not included in the supplemental log. If you do not specify a string value, DMS uses the null value for these columns regardless ofuse_csv_no_sup_value
. (Ignored for source endpoints.) - Csv
Null stringValue - String to as null when writing to the target. (AWS default is
NULL
.) - Csv
Row stringDelimiter - Delimiter used to separate rows in the source files. Default is newline (i.e.,
\n
). - Data
Format string - Output format for the files that AWS DMS uses to create S3 objects. Valid values are
csv
andparquet
. (Ignored for source endpoints -- onlycsv
is valid.) - Data
Page intSize - Size of one data page in bytes. (AWS default is 1 MiB, i.e.,
1048576
.) - Date
Partition stringDelimiter - Date separating delimiter to use during folder partitioning. Valid values are
SLASH
,UNDERSCORE
,DASH
, andNONE
. (AWS default isSLASH
.) (Ignored for source endpoints.) - Date
Partition boolEnabled - Partition S3 bucket folders based on transaction commit dates. Default is
false
. (Ignored for source endpoints.) - Date
Partition stringSequence - Date format to use during folder partitioning. Use this parameter when
date_partition_enabled
is set to true. Valid values areYYYYMMDD
,YYYYMMDDHH
,YYYYMM
,MMYYYYDD
, andDDMMYYYY
. (AWS default isYYYYMMDD
.) (Ignored for source endpoints.) - Date
Partition stringTimezone - Convert the current UTC time to a timezone. The conversion occurs when a date partition folder is created and a CDC filename is generated. The timezone format is Area/Location (e.g.,
Europe/Paris
). Use this whendate_partition_enabled
istrue
. (Ignored for source endpoints.) - Detach
Target boolOn Lob Lookup Failure Parquet - Undocumented argument for use as directed by AWS Support.
- Dict
Page intSize Limit - Maximum size in bytes of an encoded dictionary page of a column. (AWS default is 1 MiB, i.e.,
1048576
.) - Enable
Statistics bool - Whether to enable statistics for Parquet pages and row groups. Default is
true
. - Encoding
Type string - Type of encoding to use. Value values are
rle_dictionary
,plain
, andplain_dictionary
. (AWS default isrle_dictionary
.) - Encryption
Mode string - Server-side encryption mode that you want to encrypt your .csv or .parquet object files copied to S3. Valid values are
SSE_S3
andSSE_KMS
. (AWS default isSSE_S3
.) (Ignored for source endpoints -- onlySSE_S3
is valid.) - Endpoint
Arn string - ARN for the endpoint.
- Endpoint
Id string - Database endpoint identifier. Identifiers must contain from 1 to 255 alphanumeric characters or hyphens, begin with a letter, contain only ASCII letters, digits, and hyphens, not end with a hyphen, and not contain two consecutive hyphens.
- Endpoint
Type string - Type of endpoint. Valid values are
source
,target
. - Engine
Display stringName - Expanded name for the engine name.
- Expected
Bucket stringOwner - Bucket owner to prevent sniping. Value is an AWS account ID.
- External
Id string - Can be used for cross-account validation. Use it in another account with
aws.dms.S3Endpoint
to create the endpoint cross-account. - External
Table stringDefinition - JSON document that describes how AWS DMS should interpret the data.
- Glue
Catalog boolGeneration - Whether to integrate AWS Glue Data Catalog with an Amazon S3 target. See Using AWS Glue Data Catalog with an Amazon S3 target for AWS DMS for more information. Default is
false
. - Ignore
Header intRows - When this value is set to
1
, DMS ignores the first row header in a .csv file. (AWS default is0
.) - Include
Op boolFor Full Load - 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
. - Kms
Key stringArn - ARN for the KMS key that will be used to encrypt the connection parameters. If you do not specify a value for
kms_key_arn
, then AWS DMS will use your default encryption key. AWS KMS creates the default encryption key for your AWS account. Your AWS account has a different default encryption key for each AWS region. - Max
File intSize - 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
to1048576
. (AWS default is 1 GB, i.e.,1048576
.) - Parquet
Timestamp boolIn Millisecond - Specifies the precision of any TIMESTAMP column values written to an S3 object file in .parquet format. Default is
false
. (Ignored for source endpoints.) - Parquet
Version string - Version of the .parquet file format. Valid values are
parquet-1-0
andparquet-2-0
. (AWS default isparquet-1-0
.) (Ignored for source endpoints.) - Preserve
Transactions bool - Whether DMS saves the transaction order for a CDC load on the S3 target specified by
cdc_path
. Default isfalse
. (Ignored for source endpoints.) - Rfc4180 bool
- For an S3 source, whether each leading double quotation mark has to be followed by an ending double quotation mark. Default is
true
. - Row
Group intLength - Number of rows in a row group. (AWS default is
10000
.) - Server
Side stringEncryption Kms Key Id - When
encryption_mode
isSSE_KMS
, ARN for the AWS KMS key. (Ignored for source endpoints -- onlySSE_S3
encryption_mode
is valid.) - Service
Access stringRole Arn ARN of the IAM role with permissions to the S3 Bucket.
The following arguments are optional:
- Ssl
Mode string - SSL mode to use for the connection. Valid values are
none
,require
,verify-ca
,verify-full
. (AWS default isnone
.) - Status string
- Status of the endpoint.
- Dictionary<string, string>
- Map of tags to assign to the resource. If configured with a provider
default_tags
configuration block present, tags with matching keys will overwrite those defined at the provider-level. - Dictionary<string, string>
- Map of tags assigned to the resource, including those inherited from the provider
default_tags
configuration block. - Timestamp
Column stringName - Column to add with timestamp information to the endpoint data for an Amazon S3 target.
- Use
Csv boolNo Sup Value - Whether to use
csv_no_sup_value
for columns not included in the supplemental log. (Ignored for source endpoints.) - Use
Task boolStart Time For Full Load Timestamp - 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 totrue
, 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 isfalse
.
- Add
Column boolName - Whether to add column name information to the .csv output file. Default is
false
. - Add
Trailing boolPadding Character - Whether to add padding. Default is
false
. (Ignored for source endpoints.) - Bucket
Folder string - S3 object prefix.
- Bucket
Name string - S3 bucket name.
- Canned
Acl stringFor Objects - 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
, andbucket-owner-full-control
. Default isnone
. - Cdc
Inserts boolAnd Updates - Whether to write insert and update operations to .csv or .parquet output files. Default is
false
. - Cdc
Inserts boolOnly - Whether to write insert operations to .csv or .parquet output files. Default is
false
. - Cdc
Max intBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3. (AWS default is
60
.) - Cdc
Min intFile Size - Minimum file size condition as defined in kilobytes to output a file to Amazon S3. (AWS default is 32000 KB.)
- Cdc
Path string - Folder path of CDC files. 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. - Certificate
Arn string - ARN for the certificate.
- Compression
Type string - Set to compress target files. Valid values are
GZIP
andNONE
. Default isNONE
. (Ignored for source endpoints.) - Csv
Delimiter string - Delimiter used to separate columns in the source files. Default is
,
. - Csv
No stringSup Value - Only applies if output files for a CDC load are written in .csv format. If
use_csv_no_sup_value
is set totrue
, string to use for all columns not included in the supplemental log. If you do not specify a string value, DMS uses the null value for these columns regardless ofuse_csv_no_sup_value
. (Ignored for source endpoints.) - Csv
Null stringValue - String to as null when writing to the target. (AWS default is
NULL
.) - Csv
Row stringDelimiter - Delimiter used to separate rows in the source files. Default is newline (i.e.,
\n
). - Data
Format string - Output format for the files that AWS DMS uses to create S3 objects. Valid values are
csv
andparquet
. (Ignored for source endpoints -- onlycsv
is valid.) - Data
Page intSize - Size of one data page in bytes. (AWS default is 1 MiB, i.e.,
1048576
.) - Date
Partition stringDelimiter - Date separating delimiter to use during folder partitioning. Valid values are
SLASH
,UNDERSCORE
,DASH
, andNONE
. (AWS default isSLASH
.) (Ignored for source endpoints.) - Date
Partition boolEnabled - Partition S3 bucket folders based on transaction commit dates. Default is
false
. (Ignored for source endpoints.) - Date
Partition stringSequence - Date format to use during folder partitioning. Use this parameter when
date_partition_enabled
is set to true. Valid values areYYYYMMDD
,YYYYMMDDHH
,YYYYMM
,MMYYYYDD
, andDDMMYYYY
. (AWS default isYYYYMMDD
.) (Ignored for source endpoints.) - Date
Partition stringTimezone - Convert the current UTC time to a timezone. The conversion occurs when a date partition folder is created and a CDC filename is generated. The timezone format is Area/Location (e.g.,
Europe/Paris
). Use this whendate_partition_enabled
istrue
. (Ignored for source endpoints.) - Detach
Target boolOn Lob Lookup Failure Parquet - Undocumented argument for use as directed by AWS Support.
- Dict
Page intSize Limit - Maximum size in bytes of an encoded dictionary page of a column. (AWS default is 1 MiB, i.e.,
1048576
.) - Enable
Statistics bool - Whether to enable statistics for Parquet pages and row groups. Default is
true
. - Encoding
Type string - Type of encoding to use. Value values are
rle_dictionary
,plain
, andplain_dictionary
. (AWS default isrle_dictionary
.) - Encryption
Mode string - Server-side encryption mode that you want to encrypt your .csv or .parquet object files copied to S3. Valid values are
SSE_S3
andSSE_KMS
. (AWS default isSSE_S3
.) (Ignored for source endpoints -- onlySSE_S3
is valid.) - Endpoint
Arn string - ARN for the endpoint.
- Endpoint
Id string - Database endpoint identifier. Identifiers must contain from 1 to 255 alphanumeric characters or hyphens, begin with a letter, contain only ASCII letters, digits, and hyphens, not end with a hyphen, and not contain two consecutive hyphens.
- Endpoint
Type string - Type of endpoint. Valid values are
source
,target
. - Engine
Display stringName - Expanded name for the engine name.
- Expected
Bucket stringOwner - Bucket owner to prevent sniping. Value is an AWS account ID.
- External
Id string - Can be used for cross-account validation. Use it in another account with
aws.dms.S3Endpoint
to create the endpoint cross-account. - External
Table stringDefinition - JSON document that describes how AWS DMS should interpret the data.
- Glue
Catalog boolGeneration - Whether to integrate AWS Glue Data Catalog with an Amazon S3 target. See Using AWS Glue Data Catalog with an Amazon S3 target for AWS DMS for more information. Default is
false
. - Ignore
Header intRows - When this value is set to
1
, DMS ignores the first row header in a .csv file. (AWS default is0
.) - Include
Op boolFor Full Load - 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
. - Kms
Key stringArn - ARN for the KMS key that will be used to encrypt the connection parameters. If you do not specify a value for
kms_key_arn
, then AWS DMS will use your default encryption key. AWS KMS creates the default encryption key for your AWS account. Your AWS account has a different default encryption key for each AWS region. - Max
File intSize - 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
to1048576
. (AWS default is 1 GB, i.e.,1048576
.) - Parquet
Timestamp boolIn Millisecond - Specifies the precision of any TIMESTAMP column values written to an S3 object file in .parquet format. Default is
false
. (Ignored for source endpoints.) - Parquet
Version string - Version of the .parquet file format. Valid values are
parquet-1-0
andparquet-2-0
. (AWS default isparquet-1-0
.) (Ignored for source endpoints.) - Preserve
Transactions bool - Whether DMS saves the transaction order for a CDC load on the S3 target specified by
cdc_path
. Default isfalse
. (Ignored for source endpoints.) - Rfc4180 bool
- For an S3 source, whether each leading double quotation mark has to be followed by an ending double quotation mark. Default is
true
. - Row
Group intLength - Number of rows in a row group. (AWS default is
10000
.) - Server
Side stringEncryption Kms Key Id - When
encryption_mode
isSSE_KMS
, ARN for the AWS KMS key. (Ignored for source endpoints -- onlySSE_S3
encryption_mode
is valid.) - Service
Access stringRole Arn ARN of the IAM role with permissions to the S3 Bucket.
The following arguments are optional:
- Ssl
Mode string - SSL mode to use for the connection. Valid values are
none
,require
,verify-ca
,verify-full
. (AWS default isnone
.) - Status string
- Status of the endpoint.
- map[string]string
- Map of tags to assign to the resource. If configured with a provider
default_tags
configuration block present, tags with matching keys will overwrite those defined at the provider-level. - map[string]string
- Map of tags assigned to the resource, including those inherited from the provider
default_tags
configuration block. - Timestamp
Column stringName - Column to add with timestamp information to the endpoint data for an Amazon S3 target.
- Use
Csv boolNo Sup Value - Whether to use
csv_no_sup_value
for columns not included in the supplemental log. (Ignored for source endpoints.) - Use
Task boolStart Time For Full Load Timestamp - 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 totrue
, 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 isfalse
.
- add
Column BooleanName - Whether to add column name information to the .csv output file. Default is
false
. - add
Trailing BooleanPadding Character - Whether to add padding. Default is
false
. (Ignored for source endpoints.) - bucket
Folder String - S3 object prefix.
- bucket
Name String - S3 bucket name.
- canned
Acl StringFor Objects - 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
, andbucket-owner-full-control
. Default isnone
. - cdc
Inserts BooleanAnd Updates - Whether to write insert and update operations to .csv or .parquet output files. Default is
false
. - cdc
Inserts BooleanOnly - Whether to write insert operations to .csv or .parquet output files. Default is
false
. - cdc
Max IntegerBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3. (AWS default is
60
.) - cdc
Min IntegerFile Size - Minimum file size condition as defined in kilobytes to output a file to Amazon S3. (AWS default is 32000 KB.)
- cdc
Path String - Folder path of CDC files. 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. - certificate
Arn String - ARN for the certificate.
- compression
Type String - Set to compress target files. Valid values are
GZIP
andNONE
. Default isNONE
. (Ignored for source endpoints.) - csv
Delimiter String - Delimiter used to separate columns in the source files. Default is
,
. - csv
No StringSup Value - Only applies if output files for a CDC load are written in .csv format. If
use_csv_no_sup_value
is set totrue
, string to use for all columns not included in the supplemental log. If you do not specify a string value, DMS uses the null value for these columns regardless ofuse_csv_no_sup_value
. (Ignored for source endpoints.) - csv
Null StringValue - String to as null when writing to the target. (AWS default is
NULL
.) - csv
Row StringDelimiter - Delimiter used to separate rows in the source files. Default is newline (i.e.,
\n
). - data
Format String - Output format for the files that AWS DMS uses to create S3 objects. Valid values are
csv
andparquet
. (Ignored for source endpoints -- onlycsv
is valid.) - data
Page IntegerSize - Size of one data page in bytes. (AWS default is 1 MiB, i.e.,
1048576
.) - date
Partition StringDelimiter - Date separating delimiter to use during folder partitioning. Valid values are
SLASH
,UNDERSCORE
,DASH
, andNONE
. (AWS default isSLASH
.) (Ignored for source endpoints.) - date
Partition BooleanEnabled - Partition S3 bucket folders based on transaction commit dates. Default is
false
. (Ignored for source endpoints.) - date
Partition StringSequence - Date format to use during folder partitioning. Use this parameter when
date_partition_enabled
is set to true. Valid values areYYYYMMDD
,YYYYMMDDHH
,YYYYMM
,MMYYYYDD
, andDDMMYYYY
. (AWS default isYYYYMMDD
.) (Ignored for source endpoints.) - date
Partition StringTimezone - Convert the current UTC time to a timezone. The conversion occurs when a date partition folder is created and a CDC filename is generated. The timezone format is Area/Location (e.g.,
Europe/Paris
). Use this whendate_partition_enabled
istrue
. (Ignored for source endpoints.) - detach
Target BooleanOn Lob Lookup Failure Parquet - Undocumented argument for use as directed by AWS Support.
- dict
Page IntegerSize Limit - Maximum size in bytes of an encoded dictionary page of a column. (AWS default is 1 MiB, i.e.,
1048576
.) - enable
Statistics Boolean - Whether to enable statistics for Parquet pages and row groups. Default is
true
. - encoding
Type String - Type of encoding to use. Value values are
rle_dictionary
,plain
, andplain_dictionary
. (AWS default isrle_dictionary
.) - encryption
Mode String - Server-side encryption mode that you want to encrypt your .csv or .parquet object files copied to S3. Valid values are
SSE_S3
andSSE_KMS
. (AWS default isSSE_S3
.) (Ignored for source endpoints -- onlySSE_S3
is valid.) - endpoint
Arn String - ARN for the endpoint.
- endpoint
Id String - Database endpoint identifier. Identifiers must contain from 1 to 255 alphanumeric characters or hyphens, begin with a letter, contain only ASCII letters, digits, and hyphens, not end with a hyphen, and not contain two consecutive hyphens.
- endpoint
Type String - Type of endpoint. Valid values are
source
,target
. - engine
Display StringName - Expanded name for the engine name.
- expected
Bucket StringOwner - Bucket owner to prevent sniping. Value is an AWS account ID.
- external
Id String - Can be used for cross-account validation. Use it in another account with
aws.dms.S3Endpoint
to create the endpoint cross-account. - external
Table StringDefinition - JSON document that describes how AWS DMS should interpret the data.
- glue
Catalog BooleanGeneration - Whether to integrate AWS Glue Data Catalog with an Amazon S3 target. See Using AWS Glue Data Catalog with an Amazon S3 target for AWS DMS for more information. Default is
false
. - ignore
Header IntegerRows - When this value is set to
1
, DMS ignores the first row header in a .csv file. (AWS default is0
.) - include
Op BooleanFor Full Load - 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
. - kms
Key StringArn - ARN for the KMS key that will be used to encrypt the connection parameters. If you do not specify a value for
kms_key_arn
, then AWS DMS will use your default encryption key. AWS KMS creates the default encryption key for your AWS account. Your AWS account has a different default encryption key for each AWS region. - max
File IntegerSize - 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
to1048576
. (AWS default is 1 GB, i.e.,1048576
.) - parquet
Timestamp BooleanIn Millisecond - Specifies the precision of any TIMESTAMP column values written to an S3 object file in .parquet format. Default is
false
. (Ignored for source endpoints.) - parquet
Version String - Version of the .parquet file format. Valid values are
parquet-1-0
andparquet-2-0
. (AWS default isparquet-1-0
.) (Ignored for source endpoints.) - preserve
Transactions Boolean - Whether DMS saves the transaction order for a CDC load on the S3 target specified by
cdc_path
. Default isfalse
. (Ignored for source endpoints.) - rfc4180 Boolean
- For an S3 source, whether each leading double quotation mark has to be followed by an ending double quotation mark. Default is
true
. - row
Group IntegerLength - Number of rows in a row group. (AWS default is
10000
.) - server
Side StringEncryption Kms Key Id - When
encryption_mode
isSSE_KMS
, ARN for the AWS KMS key. (Ignored for source endpoints -- onlySSE_S3
encryption_mode
is valid.) - service
Access StringRole Arn ARN of the IAM role with permissions to the S3 Bucket.
The following arguments are optional:
- ssl
Mode String - SSL mode to use for the connection. Valid values are
none
,require
,verify-ca
,verify-full
. (AWS default isnone
.) - status String
- Status of the endpoint.
- Map<String,String>
- Map of tags to assign to the resource. If configured with a provider
default_tags
configuration block present, tags with matching keys will overwrite those defined at the provider-level. - Map<String,String>
- Map of tags assigned to the resource, including those inherited from the provider
default_tags
configuration block. - timestamp
Column StringName - Column to add with timestamp information to the endpoint data for an Amazon S3 target.
- use
Csv BooleanNo Sup Value - Whether to use
csv_no_sup_value
for columns not included in the supplemental log. (Ignored for source endpoints.) - use
Task BooleanStart Time For Full Load Timestamp - 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 totrue
, 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 isfalse
.
- add
Column booleanName - Whether to add column name information to the .csv output file. Default is
false
. - add
Trailing booleanPadding Character - Whether to add padding. Default is
false
. (Ignored for source endpoints.) - bucket
Folder string - S3 object prefix.
- bucket
Name string - S3 bucket name.
- canned
Acl stringFor Objects - 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
, andbucket-owner-full-control
. Default isnone
. - cdc
Inserts booleanAnd Updates - Whether to write insert and update operations to .csv or .parquet output files. Default is
false
. - cdc
Inserts booleanOnly - Whether to write insert operations to .csv or .parquet output files. Default is
false
. - cdc
Max numberBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3. (AWS default is
60
.) - cdc
Min numberFile Size - Minimum file size condition as defined in kilobytes to output a file to Amazon S3. (AWS default is 32000 KB.)
- cdc
Path string - Folder path of CDC files. 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. - certificate
Arn string - ARN for the certificate.
- compression
Type string - Set to compress target files. Valid values are
GZIP
andNONE
. Default isNONE
. (Ignored for source endpoints.) - csv
Delimiter string - Delimiter used to separate columns in the source files. Default is
,
. - csv
No stringSup Value - Only applies if output files for a CDC load are written in .csv format. If
use_csv_no_sup_value
is set totrue
, string to use for all columns not included in the supplemental log. If you do not specify a string value, DMS uses the null value for these columns regardless ofuse_csv_no_sup_value
. (Ignored for source endpoints.) - csv
Null stringValue - String to as null when writing to the target. (AWS default is
NULL
.) - csv
Row stringDelimiter - Delimiter used to separate rows in the source files. Default is newline (i.e.,
\n
). - data
Format string - Output format for the files that AWS DMS uses to create S3 objects. Valid values are
csv
andparquet
. (Ignored for source endpoints -- onlycsv
is valid.) - data
Page numberSize - Size of one data page in bytes. (AWS default is 1 MiB, i.e.,
1048576
.) - date
Partition stringDelimiter - Date separating delimiter to use during folder partitioning. Valid values are
SLASH
,UNDERSCORE
,DASH
, andNONE
. (AWS default isSLASH
.) (Ignored for source endpoints.) - date
Partition booleanEnabled - Partition S3 bucket folders based on transaction commit dates. Default is
false
. (Ignored for source endpoints.) - date
Partition stringSequence - Date format to use during folder partitioning. Use this parameter when
date_partition_enabled
is set to true. Valid values areYYYYMMDD
,YYYYMMDDHH
,YYYYMM
,MMYYYYDD
, andDDMMYYYY
. (AWS default isYYYYMMDD
.) (Ignored for source endpoints.) - date
Partition stringTimezone - Convert the current UTC time to a timezone. The conversion occurs when a date partition folder is created and a CDC filename is generated. The timezone format is Area/Location (e.g.,
Europe/Paris
). Use this whendate_partition_enabled
istrue
. (Ignored for source endpoints.) - detach
Target booleanOn Lob Lookup Failure Parquet - Undocumented argument for use as directed by AWS Support.
- dict
Page numberSize Limit - Maximum size in bytes of an encoded dictionary page of a column. (AWS default is 1 MiB, i.e.,
1048576
.) - enable
Statistics boolean - Whether to enable statistics for Parquet pages and row groups. Default is
true
. - encoding
Type string - Type of encoding to use. Value values are
rle_dictionary
,plain
, andplain_dictionary
. (AWS default isrle_dictionary
.) - encryption
Mode string - Server-side encryption mode that you want to encrypt your .csv or .parquet object files copied to S3. Valid values are
SSE_S3
andSSE_KMS
. (AWS default isSSE_S3
.) (Ignored for source endpoints -- onlySSE_S3
is valid.) - endpoint
Arn string - ARN for the endpoint.
- endpoint
Id string - Database endpoint identifier. Identifiers must contain from 1 to 255 alphanumeric characters or hyphens, begin with a letter, contain only ASCII letters, digits, and hyphens, not end with a hyphen, and not contain two consecutive hyphens.
- endpoint
Type string - Type of endpoint. Valid values are
source
,target
. - engine
Display stringName - Expanded name for the engine name.
- expected
Bucket stringOwner - Bucket owner to prevent sniping. Value is an AWS account ID.
- external
Id string - Can be used for cross-account validation. Use it in another account with
aws.dms.S3Endpoint
to create the endpoint cross-account. - external
Table stringDefinition - JSON document that describes how AWS DMS should interpret the data.
- glue
Catalog booleanGeneration - Whether to integrate AWS Glue Data Catalog with an Amazon S3 target. See Using AWS Glue Data Catalog with an Amazon S3 target for AWS DMS for more information. Default is
false
. - ignore
Header numberRows - When this value is set to
1
, DMS ignores the first row header in a .csv file. (AWS default is0
.) - include
Op booleanFor Full Load - 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
. - kms
Key stringArn - ARN for the KMS key that will be used to encrypt the connection parameters. If you do not specify a value for
kms_key_arn
, then AWS DMS will use your default encryption key. AWS KMS creates the default encryption key for your AWS account. Your AWS account has a different default encryption key for each AWS region. - max
File numberSize - 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
to1048576
. (AWS default is 1 GB, i.e.,1048576
.) - parquet
Timestamp booleanIn Millisecond - Specifies the precision of any TIMESTAMP column values written to an S3 object file in .parquet format. Default is
false
. (Ignored for source endpoints.) - parquet
Version string - Version of the .parquet file format. Valid values are
parquet-1-0
andparquet-2-0
. (AWS default isparquet-1-0
.) (Ignored for source endpoints.) - preserve
Transactions boolean - Whether DMS saves the transaction order for a CDC load on the S3 target specified by
cdc_path
. Default isfalse
. (Ignored for source endpoints.) - rfc4180 boolean
- For an S3 source, whether each leading double quotation mark has to be followed by an ending double quotation mark. Default is
true
. - row
Group numberLength - Number of rows in a row group. (AWS default is
10000
.) - server
Side stringEncryption Kms Key Id - When
encryption_mode
isSSE_KMS
, ARN for the AWS KMS key. (Ignored for source endpoints -- onlySSE_S3
encryption_mode
is valid.) - service
Access stringRole Arn ARN of the IAM role with permissions to the S3 Bucket.
The following arguments are optional:
- ssl
Mode string - SSL mode to use for the connection. Valid values are
none
,require
,verify-ca
,verify-full
. (AWS default isnone
.) - status string
- Status of the endpoint.
- {[key: string]: string}
- Map of tags to assign to the resource. If configured with a provider
default_tags
configuration block present, tags with matching keys will overwrite those defined at the provider-level. - {[key: string]: string}
- Map of tags assigned to the resource, including those inherited from the provider
default_tags
configuration block. - timestamp
Column stringName - Column to add with timestamp information to the endpoint data for an Amazon S3 target.
- use
Csv booleanNo Sup Value - Whether to use
csv_no_sup_value
for columns not included in the supplemental log. (Ignored for source endpoints.) - use
Task booleanStart Time For Full Load Timestamp - 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 totrue
, 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 isfalse
.
- add_
column_ boolname - Whether to add column name information to the .csv output file. Default is
false
. - add_
trailing_ boolpadding_ character - Whether to add padding. Default is
false
. (Ignored for source endpoints.) - bucket_
folder str - S3 object prefix.
- bucket_
name str - S3 bucket name.
- canned_
acl_ strfor_ objects - 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
, andbucket-owner-full-control
. Default isnone
. - cdc_
inserts_ booland_ updates - Whether to write insert and update operations to .csv or .parquet output files. Default is
false
. - cdc_
inserts_ boolonly - Whether to write insert operations to .csv or .parquet output files. Default is
false
. - cdc_
max_ intbatch_ interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3. (AWS default is
60
.) - cdc_
min_ intfile_ size - Minimum file size condition as defined in kilobytes to output a file to Amazon S3. (AWS default is 32000 KB.)
- cdc_
path str - Folder path of CDC files. 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. - certificate_
arn str - ARN for the certificate.
- compression_
type str - Set to compress target files. Valid values are
GZIP
andNONE
. Default isNONE
. (Ignored for source endpoints.) - csv_
delimiter str - Delimiter used to separate columns in the source files. Default is
,
. - csv_
no_ strsup_ value - Only applies if output files for a CDC load are written in .csv format. If
use_csv_no_sup_value
is set totrue
, string to use for all columns not included in the supplemental log. If you do not specify a string value, DMS uses the null value for these columns regardless ofuse_csv_no_sup_value
. (Ignored for source endpoints.) - csv_
null_ strvalue - String to as null when writing to the target. (AWS default is
NULL
.) - csv_
row_ strdelimiter - Delimiter used to separate rows in the source files. Default is newline (i.e.,
\n
). - data_
format str - Output format for the files that AWS DMS uses to create S3 objects. Valid values are
csv
andparquet
. (Ignored for source endpoints -- onlycsv
is valid.) - data_
page_ intsize - Size of one data page in bytes. (AWS default is 1 MiB, i.e.,
1048576
.) - date_
partition_ strdelimiter - Date separating delimiter to use during folder partitioning. Valid values are
SLASH
,UNDERSCORE
,DASH
, andNONE
. (AWS default isSLASH
.) (Ignored for source endpoints.) - date_
partition_ boolenabled - Partition S3 bucket folders based on transaction commit dates. Default is
false
. (Ignored for source endpoints.) - date_
partition_ strsequence - Date format to use during folder partitioning. Use this parameter when
date_partition_enabled
is set to true. Valid values areYYYYMMDD
,YYYYMMDDHH
,YYYYMM
,MMYYYYDD
, andDDMMYYYY
. (AWS default isYYYYMMDD
.) (Ignored for source endpoints.) - date_
partition_ strtimezone - Convert the current UTC time to a timezone. The conversion occurs when a date partition folder is created and a CDC filename is generated. The timezone format is Area/Location (e.g.,
Europe/Paris
). Use this whendate_partition_enabled
istrue
. (Ignored for source endpoints.) - detach_
target_ boolon_ lob_ lookup_ failure_ parquet - Undocumented argument for use as directed by AWS Support.
- dict_
page_ intsize_ limit - Maximum size in bytes of an encoded dictionary page of a column. (AWS default is 1 MiB, i.e.,
1048576
.) - enable_
statistics bool - Whether to enable statistics for Parquet pages and row groups. Default is
true
. - encoding_
type str - Type of encoding to use. Value values are
rle_dictionary
,plain
, andplain_dictionary
. (AWS default isrle_dictionary
.) - encryption_
mode str - Server-side encryption mode that you want to encrypt your .csv or .parquet object files copied to S3. Valid values are
SSE_S3
andSSE_KMS
. (AWS default isSSE_S3
.) (Ignored for source endpoints -- onlySSE_S3
is valid.) - endpoint_
arn str - ARN for the endpoint.
- endpoint_
id str - Database endpoint identifier. Identifiers must contain from 1 to 255 alphanumeric characters or hyphens, begin with a letter, contain only ASCII letters, digits, and hyphens, not end with a hyphen, and not contain two consecutive hyphens.
- endpoint_
type str - Type of endpoint. Valid values are
source
,target
. - engine_
display_ strname - Expanded name for the engine name.
- expected_
bucket_ strowner - Bucket owner to prevent sniping. Value is an AWS account ID.
- external_
id str - Can be used for cross-account validation. Use it in another account with
aws.dms.S3Endpoint
to create the endpoint cross-account. - external_
table_ strdefinition - JSON document that describes how AWS DMS should interpret the data.
- glue_
catalog_ boolgeneration - Whether to integrate AWS Glue Data Catalog with an Amazon S3 target. See Using AWS Glue Data Catalog with an Amazon S3 target for AWS DMS for more information. Default is
false
. - ignore_
header_ introws - When this value is set to
1
, DMS ignores the first row header in a .csv file. (AWS default is0
.) - include_
op_ boolfor_ full_ load - 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
. - kms_
key_ strarn - ARN for the KMS key that will be used to encrypt the connection parameters. If you do not specify a value for
kms_key_arn
, then AWS DMS will use your default encryption key. AWS KMS creates the default encryption key for your AWS account. Your AWS account has a different default encryption key for each AWS region. - max_
file_ intsize - 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
to1048576
. (AWS default is 1 GB, i.e.,1048576
.) - parquet_
timestamp_ boolin_ millisecond - Specifies the precision of any TIMESTAMP column values written to an S3 object file in .parquet format. Default is
false
. (Ignored for source endpoints.) - parquet_
version str - Version of the .parquet file format. Valid values are
parquet-1-0
andparquet-2-0
. (AWS default isparquet-1-0
.) (Ignored for source endpoints.) - preserve_
transactions bool - Whether DMS saves the transaction order for a CDC load on the S3 target specified by
cdc_path
. Default isfalse
. (Ignored for source endpoints.) - rfc4180 bool
- For an S3 source, whether each leading double quotation mark has to be followed by an ending double quotation mark. Default is
true
. - row_
group_ intlength - Number of rows in a row group. (AWS default is
10000
.) - server_
side_ strencryption_ kms_ key_ id - When
encryption_mode
isSSE_KMS
, ARN for the AWS KMS key. (Ignored for source endpoints -- onlySSE_S3
encryption_mode
is valid.) - service_
access_ strrole_ arn ARN of the IAM role with permissions to the S3 Bucket.
The following arguments are optional:
- ssl_
mode str - SSL mode to use for the connection. Valid values are
none
,require
,verify-ca
,verify-full
. (AWS default isnone
.) - status str
- Status of the endpoint.
- Mapping[str, str]
- Map of tags to assign to the resource. If configured with a provider
default_tags
configuration block present, tags with matching keys will overwrite those defined at the provider-level. - Mapping[str, str]
- Map of tags assigned to the resource, including those inherited from the provider
default_tags
configuration block. - timestamp_
column_ strname - Column to add with timestamp information to the endpoint data for an Amazon S3 target.
- use_
csv_ boolno_ sup_ value - Whether to use
csv_no_sup_value
for columns not included in the supplemental log. (Ignored for source endpoints.) - use_
task_ boolstart_ time_ for_ full_ load_ timestamp - 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 totrue
, 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 isfalse
.
- add
Column BooleanName - Whether to add column name information to the .csv output file. Default is
false
. - add
Trailing BooleanPadding Character - Whether to add padding. Default is
false
. (Ignored for source endpoints.) - bucket
Folder String - S3 object prefix.
- bucket
Name String - S3 bucket name.
- canned
Acl StringFor Objects - 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
, andbucket-owner-full-control
. Default isnone
. - cdc
Inserts BooleanAnd Updates - Whether to write insert and update operations to .csv or .parquet output files. Default is
false
. - cdc
Inserts BooleanOnly - Whether to write insert operations to .csv or .parquet output files. Default is
false
. - cdc
Max NumberBatch Interval - Maximum length of the interval, defined in seconds, after which to output a file to Amazon S3. (AWS default is
60
.) - cdc
Min NumberFile Size - Minimum file size condition as defined in kilobytes to output a file to Amazon S3. (AWS default is 32000 KB.)
- cdc
Path String - Folder path of CDC files. 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. - certificate
Arn String - ARN for the certificate.
- compression
Type String - Set to compress target files. Valid values are
GZIP
andNONE
. Default isNONE
. (Ignored for source endpoints.) - csv
Delimiter String - Delimiter used to separate columns in the source files. Default is
,
. - csv
No StringSup Value - Only applies if output files for a CDC load are written in .csv format. If
use_csv_no_sup_value
is set totrue
, string to use for all columns not included in the supplemental log. If you do not specify a string value, DMS uses the null value for these columns regardless ofuse_csv_no_sup_value
. (Ignored for source endpoints.) - csv
Null StringValue - String to as null when writing to the target. (AWS default is
NULL
.) - csv
Row StringDelimiter - Delimiter used to separate rows in the source files. Default is newline (i.e.,
\n
). - data
Format String - Output format for the files that AWS DMS uses to create S3 objects. Valid values are
csv
andparquet
. (Ignored for source endpoints -- onlycsv
is valid.) - data
Page NumberSize - Size of one data page in bytes. (AWS default is 1 MiB, i.e.,
1048576
.) - date
Partition StringDelimiter - Date separating delimiter to use during folder partitioning. Valid values are
SLASH
,UNDERSCORE
,DASH
, andNONE
. (AWS default isSLASH
.) (Ignored for source endpoints.) - date
Partition BooleanEnabled - Partition S3 bucket folders based on transaction commit dates. Default is
false
. (Ignored for source endpoints.) - date
Partition StringSequence - Date format to use during folder partitioning. Use this parameter when
date_partition_enabled
is set to true. Valid values areYYYYMMDD
,YYYYMMDDHH
,YYYYMM
,MMYYYYDD
, andDDMMYYYY
. (AWS default isYYYYMMDD
.) (Ignored for source endpoints.) - date
Partition StringTimezone - Convert the current UTC time to a timezone. The conversion occurs when a date partition folder is created and a CDC filename is generated. The timezone format is Area/Location (e.g.,
Europe/Paris
). Use this whendate_partition_enabled
istrue
. (Ignored for source endpoints.) - detach
Target BooleanOn Lob Lookup Failure Parquet - Undocumented argument for use as directed by AWS Support.
- dict
Page NumberSize Limit - Maximum size in bytes of an encoded dictionary page of a column. (AWS default is 1 MiB, i.e.,
1048576
.) - enable
Statistics Boolean - Whether to enable statistics for Parquet pages and row groups. Default is
true
. - encoding
Type String - Type of encoding to use. Value values are
rle_dictionary
,plain
, andplain_dictionary
. (AWS default isrle_dictionary
.) - encryption
Mode String - Server-side encryption mode that you want to encrypt your .csv or .parquet object files copied to S3. Valid values are
SSE_S3
andSSE_KMS
. (AWS default isSSE_S3
.) (Ignored for source endpoints -- onlySSE_S3
is valid.) - endpoint
Arn String - ARN for the endpoint.
- endpoint
Id String - Database endpoint identifier. Identifiers must contain from 1 to 255 alphanumeric characters or hyphens, begin with a letter, contain only ASCII letters, digits, and hyphens, not end with a hyphen, and not contain two consecutive hyphens.
- endpoint
Type String - Type of endpoint. Valid values are
source
,target
. - engine
Display StringName - Expanded name for the engine name.
- expected
Bucket StringOwner - Bucket owner to prevent sniping. Value is an AWS account ID.
- external
Id String - Can be used for cross-account validation. Use it in another account with
aws.dms.S3Endpoint
to create the endpoint cross-account. - external
Table StringDefinition - JSON document that describes how AWS DMS should interpret the data.
- glue
Catalog BooleanGeneration - Whether to integrate AWS Glue Data Catalog with an Amazon S3 target. See Using AWS Glue Data Catalog with an Amazon S3 target for AWS DMS for more information. Default is
false
. - ignore
Header NumberRows - When this value is set to
1
, DMS ignores the first row header in a .csv file. (AWS default is0
.) - include
Op BooleanFor Full Load - 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
. - kms
Key StringArn - ARN for the KMS key that will be used to encrypt the connection parameters. If you do not specify a value for
kms_key_arn
, then AWS DMS will use your default encryption key. AWS KMS creates the default encryption key for your AWS account. Your AWS account has a different default encryption key for each AWS region. - max
File NumberSize - 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
to1048576
. (AWS default is 1 GB, i.e.,1048576
.) - parquet
Timestamp BooleanIn Millisecond - Specifies the precision of any TIMESTAMP column values written to an S3 object file in .parquet format. Default is
false
. (Ignored for source endpoints.) - parquet
Version String - Version of the .parquet file format. Valid values are
parquet-1-0
andparquet-2-0
. (AWS default isparquet-1-0
.) (Ignored for source endpoints.) - preserve
Transactions Boolean - Whether DMS saves the transaction order for a CDC load on the S3 target specified by
cdc_path
. Default isfalse
. (Ignored for source endpoints.) - rfc4180 Boolean
- For an S3 source, whether each leading double quotation mark has to be followed by an ending double quotation mark. Default is
true
. - row
Group NumberLength - Number of rows in a row group. (AWS default is
10000
.) - server
Side StringEncryption Kms Key Id - When
encryption_mode
isSSE_KMS
, ARN for the AWS KMS key. (Ignored for source endpoints -- onlySSE_S3
encryption_mode
is valid.) - service
Access StringRole Arn ARN of the IAM role with permissions to the S3 Bucket.
The following arguments are optional:
- ssl
Mode String - SSL mode to use for the connection. Valid values are
none
,require
,verify-ca
,verify-full
. (AWS default isnone
.) - status String
- Status of the endpoint.
- Map<String>
- Map of tags to assign to the resource. If configured with a provider
default_tags
configuration block present, tags with matching keys will overwrite those defined at the provider-level. - Map<String>
- Map of tags assigned to the resource, including those inherited from the provider
default_tags
configuration block. - timestamp
Column StringName - Column to add with timestamp information to the endpoint data for an Amazon S3 target.
- use
Csv BooleanNo Sup Value - Whether to use
csv_no_sup_value
for columns not included in the supplemental log. (Ignored for source endpoints.) - use
Task BooleanStart Time For Full Load Timestamp - 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 totrue
, 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 isfalse
.
Import
Using pulumi import
, import endpoints using the endpoint_id
. For example:
$ pulumi import aws:dms/s3Endpoint:S3Endpoint example example-dms-endpoint-tf
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- AWS Classic pulumi/pulumi-aws
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
aws
Terraform Provider.