When you read or write data, some differences in processing and configuration apply for certain data types.
Mappings
Consider the following rules and guidelines for mappings:
You can read or write data of Binary data type that is in Hexadecimal format.
The agent reads or writes the maximum float value
1.7976931348623158e+308
as infinity.
You can use the following formats to specify filter values of the Datetime data type:
YYYY-MM-DD HH24:MI:SS
YYYY/MM/DD HH24:MI:SS
MM/DD/YYYY HH24:MI:SS
If a Snowflake Cloud Data lookup object contains fields with the String data type of maximum or default precision and the row size exceeds the maximum row size, the task fails.
The performance of a write operation slows down if the data contains the Date fields.
A task that captures changed data from a CDC source fails when the Snowflake target contains a repeated column of the Record data type.
When you handle dynamic schemas in mappings, the following updates are not applicable:
Schema updates to the Timestamp and Date data types.
Schema updates that involve a decrease in the precision of the Varchar data type.
ASK INFAPreview
