SQL Server to Google BigQuery mapping

AutoSync maps SQL Server data types to the following Google BigQuery column types:


SQL Server data type	Google BigQuery column type
`bit`	`BOOL`
`date`	`DATE`
`datetime`	`DATETIME`
`datetime2`	`DATETIME`
`datetimeoffset`	`TIMESTAMP`
`smalldatetime`	`DATETIME`
`time`	`TIME`
`decimal`	`NUMERIC`
`numeric`	`NUMERIC`
`float`	`FLOAT64`
`real`	`FLOAT64`
`int`	`INT64`
`integer`	`INT64`
`bigint`	`INT64`
`smallint`	`INT64`
`tinyint`	`INT64`
`money`	`NUMERIC`
`smallmoney`	`NUMERIC`
`char`	`STRING`
`hierarchyid`	`STRING`
`nchar`	`STRING`
`ntext`	`STRING`
`nvarchar`	`STRING`
`text`	`STRING`
`uniqueidentifier`	`STRING`
`varchar`	`STRING`
`binary`	`BYTES`
`image`	`BYTES`
`varbinary`	`BYTES`
`sql_variant`	`STRING`
`table`	`STRING`
`xml`	`STRING`
`geometry`	`STRING`
`geography`	`STRING`