06 May 21 ·  dan-irving in General ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

Solved: DataSource.Error: ERROR [HY000] [Simba][BigQuery] (310) Storage API Error: failed to connect to all addresses

While executing a query using the Simba ODBC driver for BigQuery that has large resultset size (eg. Tens of thousands of rows), the query fails with the below error message

DataSource.Error: ERROR [HY000] [Simba][BigQuery] (310) Storage API Error: 
failed to connect to all addresses

Solution:

The huge amount of data might trigger the  High throughput API (HTAPI / Storage API) to fetch the results. It is possible to adjust the rows threshold, so that the Storage API is not used. 

  • Open up the ODBC manager and navigate to the connection / Simba driver settings. You can simply search for "ODBC" in your computer
  • Once you are in the Simba Driver Connection dialog. Click on "Advanced Settings" and update the settings as shown below
  • Click "OK"

dan-irving

posted on 06 May 21

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds