I tried to setup a ODBC connection with driver Simba BigQuery(google) and I first did it in my local PC and it worked. So I tried to do it in another server closed to internet and it didn't worked. So I open my firewall for those domains : www.googleapis and www.accounts.google. And it didn't work too. I tried to seach a solution but all I found is page that confirm that I should authorize those domains. Like this page that list every endpoint for this : .htm
The error pop when I try to create the ODBC connection. I fill every mandatory fields then I try to activate the dropdown list "Catalog(project)" and the windows freeze for five minutes then return this error message : [Simba][BigQuery] (100) Error interacting with REST API Timeout was reached
I seached about it but I didn't found anything very interesting. Do you have any idea which domain I should authorize to make it works ?
PS : I don't use proxy. And I connect with a json file.
I tried to setup a ODBC connection with driver Simba BigQuery(google) and I first did it in my local PC and it worked. So I tried to do it in another server closed to internet and it didn't worked. So I open my firewall for those domains : www.googleapis and www.accounts.google. And it didn't work too. I tried to seach a solution but all I found is page that confirm that I should authorize those domains. Like this page that list every endpoint for this : https://documentation.insightsoftware/simba-google-bigquery-odbc-data-connector-for-windows/content/odbc/bq/features/endpoints.htm
The error pop when I try to create the ODBC connection. I fill every mandatory fields then I try to activate the dropdown list "Catalog(project)" and the windows freeze for five minutes then return this error message : [Simba][BigQuery] (100) Error interacting with REST API Timeout was reached
I seached about it but I didn't found anything very interesting. Do you have any idea which domain I should authorize to make it works ?
PS : I don't use proxy. And I connect with a json file.
Share Improve this question edited Mar 22 at 23:35 McMaco 3618 bronze badges asked Mar 17 at 15:45 bosskay972bosskay972 1,0051 gold badge9 silver badges32 bronze badges1 Answer
Reset to default 1“[Simba][BigQuery] (100) Error interacting with REST API Timeout was reached” is an error in which the connector retries a failed API call before timing out.
Since you mention that you open your firewall, try to use the baseline BigQuery REST API service, used to interface with the BigQuery data source, via the REST API. The default value is: https://bigquery.googleapis.
To activate the “Catalog(project)” drop-down list, technically in this list you can select the name of your BigQuery project. This project is the default project that the Simba Google BigQuery ODBC Data Connector queries against, and also the project that is billed for queries that are run using the DSN.
Typically, after installing the Simba Google BigQuery ODBC Data Connector, you need to create a Data Source Name (DSN). Alternatively, for information about DSN-less connections, see Using a Connection String.
You may use this pdf namely Simba Google BigQuery ODBC Data Connector Install and Configuration Guide for step by step creation of a DSN or Connection String.