CSV File Reader mapping

AutoSync stores CSV values in the target as strings, unless you enable Infer data types for CSV files in the connection configuration. To infer column types, AutoSync checks up to the first 100 rows and can detect the following types:

STRING
NUMBER
BOOLEAN
TIMESTAMP

With type inference enabled, AutoSync treats empty strings as null values.

When you enable type inference, AutoSync maps the primitive types to a common model and then to a corresponding native type in the target.