Microsoft Azure Data Lake Storage Gen2 Connector > Microsoft Azure Data Lake Storage Gen2 data type reference > JSON data types and transformation data types
  

JSON 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
Array1
Array
Unlimited number of characters
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.
Object1
Struct
Unlimited number of characters
string
string
1 to 104,857,600 characters.
Precision 4000
1Applies only to elastic mappings.