CSV File Reader mapping

AutoSync stores values in the target as strings, unless you enable Infer data types for CSV files. 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.