“[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.com.

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.