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 21Enjoy 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
Post Comment