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.