...
| MS SQL Data Type | CDAP Schema Data Type | Support | Comment | |
|---|---|---|---|---|
| BIGINT | Schema.Type.LONG | + | ||
| BINARY | Schema.Type.BYTES | + | ||
| BIT | Schema.Type.BOOLEAN | + | ||
| CHAR | Schema.Type.STRING | + | ||
| DATE | Schema.LogicalType.DATE | + | ||
| DATETIME | Schema.LogicalType.TIMESTAMP_MICROS | + | ||
| DATETIME2 | Schema.LogicalType.TIMESTAMP_MICROS | + | ||
| DATETIMEOFFSET | Schema.Type.STRING | * | ||
| DECIMAL | Schema.LogicalType.DECIMAL | + | ||
| FLOAT | Schema.Type.DOUBLE | + | ||
| IMAGE | Schema.Type.BYTES | + | ||
| INT | Schema.Type.INT | + | ||
| MONEY | Schema.LogicalType.DECIMAL | + | ||
| NCHAR | Schema.Type.STRING | + | ||
| NTEXT | Schema.Type.STRING | + | ||
| NUMERIC | Schema.LogicalType.DECIMAL | + | ||
| NVARCHAR | Schema.Type.STRING | + | ||
| NVARCHAR(MAX) | Schema.Type.STRING | + | ||
| REAL | Schema.Type.FLOAT | + | ||
| SMALLDATETIME | Schema.LogicalType.TIMESTAMP_MICROS | + | ||
| SMALLINT | Schema.Type.INT | + | ||
| SMALLMONEY | Schema.LogicalType.DECIMAL | + | ||
| TEXT | Schema.Type.STRING | + | ||
| TIME | Schema.LogicalType.TIME_MICROS | * | TIME data type has the accuracy of 100 nanoseconds which can not be supported using TIME_MICROS logical type. | |
| TIMESTAMP | Schema.Type.BYTES | * | TIMESTAMP is the synonym for the ROWVERSION data type, values of which are automatically generated. Thus TIMESTAMP can not be supported by Sink plugin. | |
| TINYINT | Schema.Type.INT | + | ||
| UDT | Depends on basic type | + | UDT will be mapped as basic type if it's an alias of this type. CLR UDT mapped to Schema.Type.BYTES | +. |
| UNIQUEIDENTIFIER | Schema.Type.STRING | + | ||
| VARBINARY | Schema.Type.BYTES | + | ||
| VARBINARY(MAX) | Schema.Type.BYTES | + | ||
| VARCHAR | Schema.Type.STRING | + | ||
| VARCHAR(MAX) | Schema.Type.STRING | + | ||
| XML | Schema.Type.STRING | + | ||
| SQLVARIANT | Schema.Type.STRING | * | ||
| GEOMETRY | Schema.Type.BYTES | + | ||
| GEOGRAPHY | Schema.Type.BYTES | + |
...