Arrays
The Simba Google BigQuery ODBC Connector fully supports ARRAY data types. The connector returns the base ARRAY type as a text representation of the JSON array object.
For example, the SQL statement SELECT [1,2,3] returns the following JSON:
{
"v":[
{
"v":"1",
},
{
"v":"2",
},
{
"v":"3"
}
]
}
- Features
- Data Types
- Configuring the Driver on page 1