...
| SQL DW Data Type | Notes | ||||
---|---|---|---|---|---|---|
String | VARCHAR | |||||
Integer | BIGINT |
| ||||
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.
| ||||
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 Export Results window 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:
- Columns:
D s item item data types - Rows: Target table data types
In any table cell, a Y
indicates that the append operation for that data type mapping is supported.
String | Integer | Datetime | Bool | Float | Map | Array | |
---|---|---|---|---|---|---|---|
VARCHAR | Y | Y | Y | Y | Y | Y | Y |
NVARCHAR | Y | Y | Y | Y | Y | Y | Y |
CHAR | Y | Y | Y | Y | Y | Y | Y |
NCHAR | Y | Y | Y | Y | Y | Y | Y |
TINYINT | |||||||
SMALLINT | |||||||
INT | |||||||
BIGINT | Y | ||||||
DATETIME2 | Y | ||||||
TIME | Y | ||||||
BIT | Y | ||||||
FLOAT | Y | Y | |||||
REAL | Y | Y | |||||
DECIMAL | Y | Y |