...
| Source Data Type | Supported | | Notes |
|---|
| INT | Y | Integer | |
| TINYINT | Y | Integer | |
| SMALLINT | Y | Integer | |
| BIGINT | Y | Integer | | Info |
|---|
NOTE: The may infer bigint columns containing very large or very small values as String data type.If needed, you can disable type inference for individual schematized sources. For more information, see Import Data Page. |
|
| FLOAT | Y | Float | |
| REAL | Y | Float | |
| BIT | Y | Bool | |
| SMALLMONEY | Y | String | |
| MONEY | Y | String | |
| DECIMAL | Y | Float | |
| NUMERIC | Y | String | |
| DATETIMEOFFSET | Y | String | |
| TIME | Y | String | |
| DATE | Y | String | |
| DATETIME | Y | String | |
| DATETIME2 | Y | String | |
| SMALLDATETIME | Y | String | |
| CHAR | Y | String | |
| VARCHAR | Y | String | |
| NCHAR | Y | String | |
| NVARCHAR | Y | String | |
| SYSNAME | Y | String | |
| BINARY | Y | String | |
| VARBINARY | Y | String | |
| UNIQUEIDENTIFIER | Y | String | |
| TIMESTAMP | N | | |
| GEOGRAPHY | N | | |
| GEOMETRY | N | | |
| HIERARCHYID | N | | |
| IMAGE | N | | |
| TEXT | N | | |
| NTEXT | N | | |
| XML | N | | |
| CURSOR | N | | |
| ROWVERSION | N | | |
| SQL_VARIANT | N | | |
...
Write/Publish
Create new table
| Info |
|---|
NOTE: By default, the maximum length of values published to VARCHAR columns is 256 characters. As needed, this limit can be changed for multiple publication targets. For more information, see Configure Application Limits. |
| SQL DW Data Type | Notes |
|---|
| String | VARCHAR | |
| Integer | BIGINT | | Info |
|---|
NOTE: The 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 Target Matching. |
|
| 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:
- 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 | | |
