skip to main content
Welcome to the Progress DataDirect for ODBC for Google BigQuery Driver : Data Types
  

Try DataDirect Drivers Now

Data Types

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
INT64
SQL_BIGINT
BYTES
SQL_VARBINARY
NUMERIC
SQL_DECIMAL
FLOAT64
SQL_DOUBLE
DATE
SQL_TYPE_DATE
TIME
SQL_TYPE_TIME
TIMESTAMP
SQL_TYPE_TIMESTAMP
DATETIME
SQL_TYPE_TIMESTAMP