Data Integration-Free and PayGo
- Data Integration-Free and PayGo
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Databricks Data Type
| Transformation Data Type
| Range and Description
|
|---|---|---|
Binary
| Binary
| 1 to 104,857,600 bytes.
|
Bigint
| Bigint
| -9,223,372,036,854,775,808 to +9,223,372,036,854,775,807.
8-byte signed integer.
|
Boolean
| Integer
| 1 or 0.
|
Date
| Date/Time
| Date and time values.
|
Decimal
| Decimal
| Exact numeric of selectable precision
For mappings, the maximum precision is 28 and the scale is 27.
|
Double
| Double
| Precision 15.
|
Float
| Double
| Precision 7.
|
Int
| Integer
| -2,147,483,648 to +2,147,483,647.
|
Smallint
| Integer
| -32,768 to +32,767.
|
String
| String
| 1 to 104,857,600 characters.
|
Tinyint
| Integer
| -128 to 127
|
Timestamp
| Date/Time
| January 1,0001 00:00:00 to December 31,9999 23:59:59.997443.
Timestamp values only preserve results up to microsecond precision of six digits. The precision beyond six digits is discarded.
|
Varchar
| String
| 1 to 104,857,600 characters.
To use the precision of the Varchar data type set in Databricks and not the precision of the String transformation data type, set the
-Ddatabricks.honorNativePrecision=true property for the Secure Agent.
For more information on how to configure the property, see the
Varchar data type Knowledge Base article.
|
