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

Delta data types and transformation data types

Delta data types map to transformation data types that the Secure Agent uses to move data across platforms.
The following table lists the Delta data types that the Secure Agent supports and the corresponding transformation data types:
Delta data type
Transformation data type
Range and description
Boolean
Boolean
Represents Boolean values.
Binary
Binary
Represents byte sequence values.
Byte
Integer
-128 to 127
Date
Date/Time
January 1, 0001 to December 31, 9999.
Decimal
Decimal
Precision 1 to 24 digits, scale 0 to 24.
You cannot use decimal values with precision greater than 24.
Double
Double
Represents 8-byte double-precision floating point numbers.
Float
Double
Represents 4-byte single-precision floating point numbers
Integer
Integer
-2147483648 to 2147483647
Long
Bigint
-9223372036854775808 to 9223372036854775807
Short
Integer
-32768 to 32767
String
String
1 to 104,857,600 characters
Precision 4000.
Timestamp
Date/Time
January 1, 0001 00:00:00 to December 31, 9999 23:59:59.997, with precision up to microseconds.
You cannot set the precision to nanoseconds.