CODEWITHSUNDEEP
google-bigqueryodbc
Tim Swena
Tim Swena

Reputation: 14786

Why do I get a "Conversion from string to number failed with value ''" error when connecting to Google BigQuery via the Simba ODBC driver?

I'm trying to use the Simba ODBC Driver for Google BigQuery. The connection succeeded initially, but after I enabled the High-Throughput API in "Advanced Options", I get the following error:

[Simba][Support] (50090) Conversion from string to number failed with value ''

I still get this error after unchecking the High-Throughput API option.

These are the options I initially set:

advanced options dialog

Upvotes: 0

Views: 2580

Answers (1)

Tim Swena
Tim Swena

Reputation: 14786

This error happens because the Minimum Query Results Size for HTAPI and Ratio of Results to Rows Per Block are both set to empty string.

Set both values to 0 to always download query results with the BigQuery Storage API.

enter image description here

Upvotes: 2

Related Questions