Azure Synapse to Google BigQuery mapping
AutoSync maps Azure Synapse object types to the following Google BigQuery column types:
Azure Synapse object type | BigQuery column type |
---|---|
bit |
BOOL |
date |
DATE |
datetime |
DATETIME |
datetime2 |
DATETIME |
datetimeoffset |
TIMESTAMP |
smalldatetime |
DATETIME |
time |
TIME |
sl_timestamp |
TIMESTAMP |
decimal |
NUMERIC |
numeric |
NUMERIC |
float |
FLOAT64 |
real |
FLOAT64 |
tinyint |
INT64 |
smallint |
INT64 |
int |
INT64 |
bigint |
INT64 |
money |
NUMERIC |
smallmoney |
NUMERIC |
char |
STRING |
nchar |
STRING |
nvarchar |
STRING |
uniqueidentifier |
STRING |
varchar |
STRING |
binary |
STRING |
varbinary |
STRING |