5

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

Jaskeil
  • 1,044
  • 12
  • 33
  • Have you seen [changing the timeout value](https://forum.knime.com/t/from-bigquery-how-to-increase-the-timeout-value/32448/6)? But if you have further questions you can [contact simba support](https://www.magnitude.com/about-us/contact). – Ricco D Dec 13 '21 at 03:13

2 Answers2

3

This works well also:

Datasource Properties | Advanced | Timeout : 3600

Don O'Hara
  • 39
  • 3
  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Mar 25 '22 at 06:19
1

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.

Yuri Win
  • 1,348
  • 4
  • 10