Microsoft Fabric OneLake Connector > Data type reference > Flat file data types and transformation data types
  

Flat file data types and transformation data types

Flat file data types map to transformation data types that the Secure Agent uses to move data across platforms.
The following table lists the flat file data types that the Secure Agent supports and the corresponding transformation data types:
Flat file data type
Transformation data type for mappings
Transformation data type for mappings in advanced mode
Range and description
Nstring*
Text
Text
1 to 104,857,600 characters
Number*
Decimal
Double
Precision from 1 through 28 digits, scale from 0 through 28 digits
String*
String
String
1 to 104,857,600 characters. Precision 256.
*You must select the Schema Source as Import from schema file to read data of Number, String, or Nstring data type.