...

Write/Publish

Create new table

...

D s item item Data Type	SQL DW Data Type	Notes
String	VARCHAR
Integer	BIGINT	Info NOTE: The D s platform may infer Integer columns containing very large or very small values as String data type. Before you publish, you should verify that your columns containing extreme values are interpreted as Integer type.You can import a target schema to assist in lining up your columns with the expected target. For more information, see Overview of RapidTarget.
Float	FLOAT
Bool	BIT
Datetime	DATETIME2	If a time-only value is published as an append to a pre-defined DATETIME2 column, then the output column is prepended with 1900-01-01.
Datetime (with time value only)	TIME	If a value is published as an append to a pre-defined TIME column, then any date information is dropped from the output. Info NOTE: The platform publishes to Timestamp columns only for append operations to pre-existing tables.
Datetime	VARCHAR	If a Datetime value is published as an append to a pre-defined VARCHAR column, then the output column contains the string value of whatever appears in the Transformer page. When you publish results from a job through the Publishing dialog to SQL DW, all Datetime column values are written as String type.
Map	VARCHAR
Array	VARCHAR
Date	VARCHAR
All Other Data Types	VARCHAR

Append to existing table

If you are publishing to a pre-existing table, the following data type conversions apply:

...

In any table cell, a Y indicates that the append operation for that data type mapping is supported.

...