Microsoft Azure Data Lake Storage Gen2 Connector

Back Next

Avro data types and transformation data types

Avro file data types map to transformation data types that the Secure Agent uses to move data across platforms.

The following table lists the Avro file data types that the Secure Agent supports and the corresponding transformation data types:

Avro Data Type	Transformation Data Type	Range and Description
Array¹	Array	Unlimited number of characters
Boolean	Integer	1 or 0 True is equivalent to the integer 1 and False is equivalent to the integer 0.
Bytes	Binary	Precision 4000
Double	Double	Precision 15
Float	Double	Precision 15
Int	Integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
Long	Bigint	-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19, scale 0
Map¹	Map	Unlimited number of characters
Null	Integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
Record¹	Struct	Unlimited number of characters
String	String	1 to 104,857,600 characters Precision 4000
Union¹	Corresponding data type in a union of ["primitive_type\|complex_type", "null"] or ["null", "primitive_type\|complex_type"].	Dependent on primitive or complex data type.
¹Applies only to mappings in advanced mode.