Configure Hyper-Q to Use the Magnitude Simba ODBC Driver
Hyper-Q supports the Magnitude Simba ODBC 2.5.0 driver for use with BigQuery. To learn more, see ODBC and JDBC drivers for BigQuery in the Google BigQuery documentation.
To use the Simba ODBC driver, you must configure Hyper-Q and the Simba driver to use OAuth 2.0 authentication. To do this, include the following configuration in the Hyper-Q configuration file (dtm.ini).
"gateway".connection_string = "Driver=driver_path;OAuthMechanism=1;Catalog=project_name;EnableSession=1;SQLDialect=1;" "gateway".auth_backend = "bigquery_oauth" "gateway".db_interface = odbc
where:
Parameter | Description |
|---|---|
| The directory path to the ODBC driver. |
| The name of the Google project within which you are operating Hyper-Q and BigQuery. |
To learn about the Hyper-Q configuration file and the [gateway] parameters used to configure the Simba ODBC driver, see Gateway Configuration Parameters.
Important
To use the Magnitude Simba ODBC version 2.5.0 and later, ensure that the configuration parameter bigquery_query_band_separator is not present in the Hyper-Q deployment's dtm.ini file.