SSIS Components for Amazon DynamoDB

Build 25.0.9434

SeparatorCharacter

Specifies the character or characters used to denote hierarchy in flattened structures, such as Maps and List attributes in DynamoDB.

Data Type

string

Default Value

"."

Remarks

This property defines the delimiter used to represent hierarchical relationships in flattened structures within DynamoDB. For example, when SeparatorCharacter is set to ".", an attribute named address.city indicates that address is a parent attribute with a child attribute called city.

If your data includes attribute names containing the specified separator, for example, a period (.), you should choose a different SeparatorCharacter to prevent ambiguity in column naming. This property is useful for handling complex, nested data structures where clear delineation of hierarchy is required.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434