Simba Google ODBC Driver for BigQuery Error

[npatela4]

Hello All

I updated my Simba Driver for BQ and encountering this error.

Dynamic Input (1) Error SQLPrepare: [Simba][BigQuery] (100) HTTP Error 404:  (( Service {https://bigquery.googleapis.com/bigquery/v2/projects//queries} not found).).

Any ideas on how to solve this. ?

Thanks

Neel

[apathetichell · Accepted solution]

Hey - are you able to connect to BQ via your ODBC 64? I tend to ignore the Alteryx connector and go via generic odbc set up for BigQuery so I can connect via external authentication.

[rachelgomez]

To resolve this quota error, do the following:

Pause the job. 

Use jobs with batch priority.

Distribute queries. 

Distribute run times.

Use BigQuery BI Engine. 

Optimize queries and data model. 

Optimize query model. 

Persist data (Saved tables).

Regards,

Rachel Gomez

[npatela4]

Hey

Thank you I was able to connect!