...
| 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 |
