Microsoft SQL Server Source Data Type | Google BigQuery Target Data Type |
|---|---|
bigint | int64 |
binary(size), 1 <= size <= 8000 | bytes |
bit | bool |
char(size), 1 <= size <= 8000 | string |
date | date |
datetime | datetime |
datetime2(7) | string |
datetime2(precision), 0 <= p <= 6 | datetime |
datetimeoffset(7) | string |
datetimeoffset(precision), 0 <= p <= 6 | timestamp |
decimal(1,1) | numeric |
decimal(10,10) | bignumeric |
decimal(11,s), 10 <= s <= 11 | bignumeric |
decimal(12,s), 10 <= s <= 12 | bignumeric |
decimal(13,s), 10 <= s <= 13 | bignumeric |
decimal(14,s), 10 <= s <= 14 | bignumeric |
decimal(15,s), 10 <= s <= 15 | bignumeric |
decimal(16,s), 10 <= s <= 16 | bignumeric |
decimal(17,s), 10 <= s <= 17 | bignumeric |
decimal(18,s), 10 <= s <= 18 | bignumeric |
decimal(19,s), 10 <= s <= 19 | bignumeric |
decimal(2,s), 1 <= s <= 2 | numeric |
decimal(20,s), 10 <= s <= 20 | bignumeric |
decimal(21,s), 10 <= s <= 21 | bignumeric |
decimal(22,s), 10 <= s <= 22 | bignumeric |
decimal(23,s), 10 <= s <= 23 | bignumeric |
decimal(24,s), 10 <= s <= 24 | bignumeric |
decimal(25,s), 10 <= s <= 25 | bignumeric |
decimal(26,s), 10 <= s <= 26 | bignumeric |
decimal(27,s), 10 <= s <= 27 | bignumeric |
decimal(28,s), 10 <= s <= 28 | bignumeric |
decimal(3,s), 1 <= s <= 3 | numeric |
decimal(38,s), 10 <= s <= 38 | bignumeric |
decimal(4,s), 1 <= s <= 4 | numeric |
decimal(5,s), 1 <= s <= 5 | numeric |
decimal(6,s), 1 <= s <= 6 | numeric |
decimal(7,s), 1 <= s <= 7 | numeric |
decimal(8,s), 1 <= s <= 8 | numeric |
decimal(p,0), 1 <= p <= 18 | int64 |
decimal(p,s), 19 <= p <= 29, 0 <= s <= 9 | numeric |
decimal(p,s), 29 <= p <= 30, 0 <= s <= 29 | bignumeric |
decimal(p,s), 30 <= p <= 31, 0 <= s <= 30 | bignumeric |
decimal(p,s), 31 <= p <= 32, 0 <= s <= 31 | bignumeric |
decimal(p,s), 32 <= p <= 33, 0 <= s <= 32 | bignumeric |
decimal(p,s), 33 <= p <= 34, 0 <= s <= 33 | bignumeric |
decimal(p,s), 34 <= p <= 35, 0 <= s <= 34 | bignumeric |
decimal(p,s), 35 <= p <= 36, 0 <= s <= 35 | bignumeric |
decimal(p,s), 36 <= p <= 37, 0 <= s <= 36 | bignumeric |
decimal(p,s), 37 <= p <= 38, 0 <= s <= 37 | bignumeric |
decimal(p,s), 9 <= p <= 38, 1 <= s <= 9 | numeric |
float | float64 |
geography | bytes |
geometry | bytes |
hierarchyid | bytes |
image | bytes |
int | int64 |
money | numeric |
nchar(size), 1 <= size <= 4000 | string |
ntext | string |
numeric(1,1) | numeric |
numeric(10,10) | bignumeric |
numeric(11,s), 10 <= s <= 11 | bignumeric |
numeric(12,s), 10 <= s <= 12 | bignumeric |
numeric(13,s), 10 <= s <= 13 | bignumeric |
numeric(14,s), 10 <= s <= 14 | bignumeric |
numeric(15,s), 10 <= s <= 15 | bignumeric |
numeric(16,s), 10 <= s <= 16 | bignumeric |
numeric(17,s), 10 <= s <= 17 | bignumeric |
numeric(18,s), 10 <= s <= 18 | bignumeric |
numeric(19,s), 10 <= s <= 19 | bignumeric |
numeric(2,s), 1 <= s <= 2 | numeric |
numeric(20,s), 10 <= s <= 20 | bignumeric |
numeric(21,s), 10 <= s <= 21 | bignumeric |
numeric(22,s), 10 <= s <= 22 | bignumeric |
numeric(23,s), 10 <= s <= 23 | bignumeric |
numeric(24,s), 10 <= s <= 24 | bignumeric |
numeric(25,s), 10 <= s <= 25 | bignumeric |
numeric(26,s), 10 <= s <= 26 | bignumeric |
numeric(27,s), 10 <= s <= 27 | bignumeric |
numeric(28,s), 10 <= s <= 28 | bignumeric |
numeric(3,s), 1 <= s <= 3 | numeric |
numeric(38,s), 10 <= s <= 38 | bignumeric |
numeric(4,s), 1 <= s <= 4 | numeric |
numeric(5,s), 1 <= s <= 5 | numeric |
numeric(6,s), 1 <= s <= 6 | numeric |
numeric(7,s), 1 <= s <= 7 | numeric |
numeric(8,s), 1 <= s <= 8 | numeric |
numeric(p,0), 1 <= p <= 18 | int64 |
numeric(p,s), 19 <= p <= 29, 0 <= s <= 9 | numeric |
numeric(p,s), 29 <= p <= 30, 0 <= s <= 29 | bignumeric |
numeric(p,s), 30 <= p <= 31, 0 <= s <= 30 | bignumeric |
numeric(p,s), 31 <= p <= 32, 0 <= s <= 31 | bignumeric |
numeric(p,s), 32 <= p <= 33, 0 <= s <= 32 | bignumeric |
numeric(p,s), 33 <= p <= 34, 0 <= s <= 33 | bignumeric |
numeric(p,s), 34 <= p <= 35, 0 <= s <= 34 | bignumeric |
numeric(p,s), 35 <= p <= 36, 0 <= s <= 35 | bignumeric |
numeric(p,s), 36 <= p <= 37, 0 <= s <= 36 | bignumeric |
numeric(p,s), 37 <= p <= 38, 0 <= s <= 37 | bignumeric |
numeric(p,s), 9 <= p <= 38, 1 <= s <= 9 | numeric |
nvarchar(size), 1 <= size <= 4000 | string |
real | float64 |
smalldatetime | datetime |
smallint | int64 |
smallmoney | numeric |
sql_variant | bytes |
text | string |
time(7) | string |
time(precision), 0 <= p <= 6 | time |
timestamp(8) | bytes |
tinyint | int64 |
uniqueidentifier | string |
varbinary(size), 1 <= size <= 8000 | bytes |
varchar(size), 1 <= size <= 8000 | string |
xml | string |