Data Integration uses the following data types in Microsoft Fabric OneLake mappings and mapping tasks:
•Microsoft Fabric OneLake native data types appear in the Source transformation and Target transformation when you choose to edit metadata for the fields.
•Transformation data types. Set of data types that appear in the transformations. These are internal data types based on ANSI SQL-92 generic data types, which the Secure Agent uses to move data across platforms. They appear in all transformations in a mapping.
When the Secure Agent reads source data, it converts the native data types to the comparable transformation data types before transforming the data. When the Secure Agent writes to a target, it converts the transformation data types to the comparable native data types.
The following table lists the Microsoft Fabric OneLake data types that Data Integration supports and the corresponding transformation data types: