Microsoft Azure Data Lake Storage Gen2 Connector > Microsoft Azure Data Lake Storage Gen2 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 elastic mappings
Range and description
BigInt
Not applicable
Long
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 characters; precision 19, scale 0
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.