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

JSON file data types and transformation data types

JSON file data types map to transformation data types that the Secure Agent uses to move data across platforms.
The following table lists the JSON file data types that the Secure Agent supports and the corresponding transformation data types:
JSON Data Type
Transformation Data Type
Range and Description
boolean
integer
The default transformation type for boolean is integer. You can specify string data type with values of True and False. True is equivalent to the integer 1 and False is equivalent to the integer 0.
Number (double)
double
-1.79769313486231570E+308 to +1.79769313486231570E+308. Precision 15.
Number (float)
double
-1.79769313486231570E+308 to +1.79769313486231570E+308. Precision 15.
Number (int)
integer
-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
Number (long)
bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19, scale 0.
string
string
1 to 104,857,600 characters.
Precision 4000