Google BigQuery ODBC datastore

With a Google BigQuery ODBC datastore, make native ODBC calls to your Google BigQuery data sets to download and process data in SAP Cloud Integration for data services.

After you create the datastore, open the datastore to view data from your Google BigQuery account. Download table metadata from your Google BigQuery account to use as a source in SAP Cloud Integration for data services.

Note

SAP Cloud Integration for data services and Google BigQuery ODBC datastores do not support nested or repeated records. When a column is either a nested or repeated datatype, the column is not imported when importing tables and is ignored by SAP Cloud Integration for data services.

To access the data in your Google BigQuery account, the datastore uses the Magnitude Simba ODBC driver for BigQuery, which supports the OAuth 2.0 protocol for authentication and authorization. Configure the Magnitude Simba ODBC driver to provide your credentials and authenticate the connection to the data using either a Google user account or a Google service account.