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

Parquet data types and transformation data types

Parquet file data types map to transformation data types that the Secure Agent uses to move data across platforms.
The following table lists the Parquet file data types that the Secure Agent supports and the corresponding transformation data types:
Parquet data type
Transformation data type
Range and description
Boolean
Integer
1 or 0
True is equivalent to the integer 1 and False is equivalent to the integer 0.
Byte_Array
Binary
Arbitrarily long byte array
Date
Date/Time
January 1, 0001 to December 31, 9999.
Decimal
Decimal
Precision 1 to 28 digits, scale 0 to 28.
You cannot use decimal values with precision greater than 28.
Double
Double
Precision 15
Float
Double
Precision 15
Int32
Integer
-2,147,483,648 to +2,147,483,647
Int64
Bigint
-9,223,372,036,854,775,808 to +9,223,372,036,854,775,807
8-byte signed integer
Int96
Binary
12-byte signed integer
When you configure a mapping in advanced mode, the data preview displays the time zone of the Secure Agent machine.
String
String
1 to 104,857,600 characters
Precision 4000
Time
Date/Time
Time of the day. Precision to microsecond.
Timestamp
Date/Time
January 1, 0001 00:00:00 to December 31, 9999 23:59:59.997. Precision to microsecond.
You cannot set the precision to nanoseconds.
The Parquet schema that you specify for the Parquet file must be in smaller case. Parquet does not support case-sensitive schema.

Parquet timestamp data type support

You can use the following Timestamp data types for Parquet file format:
Timestamp Data type
Mappings
Mappings in advanced mode
Timestamp_micros
Yes
No
Timestamp_millis
Yes
No
Time_millis
Yes
No
Time_micros
Yes
No
int96
Yes
Yes
You cannot use the following Timestamp data types for Parquet file format: