The following table lists the data types supported by the Google BigQuery driver, and how they map to the ODBC data types.

Table 1. Google BigQuery data types
Google BigQuery Data Type ODBC Data Type
STRING SQL_WVARCHAR
ARRAY SQL_WVARCHAR
RECORD SQL_WVARCHAR
GEOGRAPHY SQL_WVARCHAR
BOOL SQL_BIT
BYTES SQL_VARBINARY
INTERVAL SQL_VARCHAR
INT64 SQL_BIGINT
JSON SQL_LONGVARCHAR
NUMERIC SQL_DECIMAL
BIGNUMERIC SQL_DECIMAL
FLOAT64 SQL_DOUBLE
DATE SQL_TYPE_DATE
TIME SQL_TYPE_TIME
TIMESTAMP SQL_TYPE_TIMESTAMP
DATETIME SQL_TYPE_TIMESTAMP