Page Comparison

...

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

...

Versions Compared