Yellowbrick Data Warehouse Connector > Data Type Reference > Yellowbrick Data Warehouse and transformation data types
  

Yellowbrick Data Warehouse and transformation data types

The following table lists the Yellowbrick Data Warehouse data types that Data Integration supports and the corresponding transformation data types:
Yellowbrick Data Warehouse Data Type
Transformation Data Type
Description
Smallint
integer
16-bit signed integer.
Integer
integer
32-bit signed integer.
Bigint
bigint
64-bit signed integer.
Varchar
nstring
Variable length character string.
Char
nstring
Fixed length character string.
Decimal
decimal
Yellowbrick Data Warehouse supports a maximum precision of 38, but the transformation data type only supports a maximum of 28 digits.
If the source data has more than 28 digits of precision, a maximum of 28 digits is preserved.
Date
date/time
Date.
Time
date/time
Time of day value.
Timestamp
date/time
Timestamp without time zone.
Timestamp with time zone
date/time
Timestamp with time zone.
Boolean
nstring
1-byte Boolean value.
Real
double
32-bit floating point value.
Double Precision
double
64-bit floating-point value.
UUID
nstring
128-bit generated value consisting of lowercase and uppercase hexadecimal digits.