Search

Yellowbrick Data Warehouse Connector

Yellowbrick Data Warehouse Connector

Back Next

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.

Data Type Reference

Watch

Comments

Cloud Connectivity Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.