Does Fivetran Sync Properties With Different Capitalization as Unique Records?

Question

Does Fivetran distinguish between properties with different capitalization? For example, would Fivetran sync timezone and timeZone as unique records?

Environment

Connector: Iterable

Answer

Yes, we sync properties with different capitalization as unique records in the USER_HISTORY table's additional_properties column. For example, we would store timezone and timeZone as unique records and sync them independently.