Microsoft Azure SQL Data Warehouse Connector > Data Type Reference > Microsoft Azure SQL Data Warehouse and Transformation Data Types
  

Microsoft Azure SQL Data Warehouse and Transformation Data Types

The following table compares the Microsoft Azure SQL Data Warehouse native data type to the transformation data type:
Microsoft SQL Data Warehouse Data Type
Transformation Data Type
bigint
bigint
binary
binary
bit
integer
char
string
date
date/time
datetime
date/time
datetime2
date/time
datetimeoffset
date/time
decimal
decimal
float
decimal
int
integer
money
double
nchar
string
nvarchar
string
real
decimal
smalldatetime
date/time
smallint
integer
smallmoney
double
time
date/time
tinyint
integer
varbinary
binary
varchar
string