ADO.NET Provider for Amazon DynamoDB

Build 24.0.9060

Data Type Mapping

Data Type Mappings

The provider maps types from the data source to the corresponding data type available in the schema. Additionally, we will attemp to scan the available data coming back based on the IgnoreTypes connection property. The table below documents these mappings.

Amazon DynamoDB CData Schema
String string, date, datetime, time
Binary string
Number bigint, int, float (depending on data that is detected)
StringSet string
NumberSet string
BinarySet string
Map string
List string
Boolean bool
Null string

Note that depending on the settings of IgnoreTypes, some of these types may not be detected by default. Date, datetime, and time for example are ignored by default as they cannot be filtered server side, and may be inserted / updated in a different format than your existing entries if enabled. Please use caution when enabling them.

FlattenArrays and FlattenObjects may also be used to to flatten the StringSets, NumberSets, BinarySets, Maps, and Lists into indivudal columns.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060