Menu
I am currently using SQL Workbench/J as my GUI to interface and run queries for BigQuery, however I'm running into a 10 second timeout issue when running more complicated queries. Any advice on how to increase the default timeout limit? Is it accessible/changeable from within the GUI? The error message I'm receiving is this:
[Simba]BigQueryJDBCDriver The job has timed out on the server. Try increasing the timeout value. [SQL State=HY000, DB Errorcode=100034]
(PS: I set up SQL Workbench/J using these steps and this driver)
261
SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and should run on any operating system that provides a Java Runtime Environment. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features.
Either select both statements in the editor and choose SQL → Execute selected, or make the two statements the only statements in the editor and choose SQL → Execute all. You can also export the result of a SELECT statement, by selecting the statement in the editor, and then choose SQL → Export query result.
They're completely different. MySQL workbench is specifically for MySQL, and written by the MySQL company, while SQL Workbench is a generic tool for multiple DBMS systems.
Google has collaborated with Magnitude Simba to provide ODBC and JDBC drivers that leverage the power of BigQuery's standard SQL. The intent of the JDBC and ODBC drivers is to help users leverage the power of BigQuery with existing tooling and infrastructure.
When you define the ConnectionString you are able to add driver properties. Timeout is one of the properties you can use.
Simply add:
jdbc:bigquery://...;Timeout=3600;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
