How do to increase timeout value for DataGrip's connection to Google BigQuery?

user_10466439 0
Viewed 2219

I currently connect JetBrain's DataGrip IDE to Google BigQuery to run my queries. I get the following error however: [Simba][BigQueryJDBCDriver](100034) The job has timed out on the server. Try increasing the timeout value. This of course happens when I run a query that may take some time to execute.

I can execute queries that take a short amount of time to complete so the connection does work.

I looked at this question (SQL Workbench/J and BigQuery) but I still did not fully understand how to change the timeout value

The error is seen below in this screenshot: enter image description here

datagrip google-bigquery sql ide database
2 Answers

Please open up data source properties and add this to the very end of connection URL: ;Timeout=3600; (note it case sensitive). Try to increase the value until error is gone.

user_128062940

This works well also:

Datasource Properties | Advanced | Timeout : 3600

user_54474620
Related