SQL Server Data Type Conversions

Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

NOTE: The Cloud Dataprep data types listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

Access/Read

Source Data TypeSupported?

Cloud Dataprep Data Type

BigintYInteger
BIGINT IDENTITYYInteger
BinaryYString (Base64)
BitYBool
CharYString
CursorN
DateYDate
DatetimeYDate
Datetime2YDate
DatetimeoffsetYString
DecimalYInteger/Decimal
DECIMAL IDENTITYYInteger
FloatYDecimal
GEOGRAPHYYString
GEOMETRYYString
HIERARCHYIDYString
ImageYString
IntYInteger
INT IDENTITYYInteger
MoneyYDecimal
NcharYString
NtextYString
NumericYInteger/Decimal
NUMERIC IDENTITYYInteger
NvarcharYString
Nvarchar(max)YString
RealYDecimal
SmalldatetimeYDate
SmallintYInteger
SMALLINT IDENTITYYInteger
SmallmoneyYDecimal
Sql_variantN
TableN
TextYString
TimeYString
TimestampYString
TinyintYInteger
TINYINT IDENTITYYInteger
UniqueidentifierYString
VarbinaryYString (Base64)
Varbinary(max)YString (Base64)
VarcharYString
Varchar(max)YString
XmlYString

Write/Publish

Cloud Dataprep Data Type

SQL Server Column TypeNotes
BoolBIT
VARCHAR(256)
IntegerBIGINT
INT
SMALLINT
DECIMAL
VARCHAR(256)
StringVARCHAR(256)
DatetimeDATETIME
TIMESTAMP
VARCHAR(256)
TimestampTIME
VARCHAR(256)
FloatFLOAT
DECIMAL
NUMERIC
VARCHAR(256)
MapVARCHAR(256)
ArrayVARCHAR(256)

NOTE: If you are appending to an existing table where a column's Cloud Dataprep data type is not mapped to the column data type in the target table, a validation error is thrown, as the platform writes unmapped types as String data type.