Microsoft Azure Blob Storage V2 Connector > Data type reference > JSON data types and transformation data types
  

JSON data types and transformation data types

JSON complex file data types map to transformation data types that the Secure Agent uses to move data across platforms.
The following table lists the JSON complex file data types that the Data Integration 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.