Skip to main content

Datometry Documentation

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

driver_path

The directory path to the ODBC driver.

project_name

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.