When i am giving a very small-time filter (1-2 days) for the same table it works fine.
Anyone faced this before? [Simba][BigQueryJDBCDriver](100034)
Question
When trying to extract a big table using existing Google Big Query cloud connector its throwing below error:Error loading resource dim_order_line : [Simba][BigQueryJDBCDriver](100034) The job has timed out on the server.Try increasing the timeou
+10
+10I figured out a work around - the number of parallel extractions were by default set to 4.
I set it to 1.
It takes 4X amount of time now. But at least there is no error.
+10
I have found the solution to the problem by going through the GCP help pages.
The solution is we must override the timeout in our Celonis connection as below:
In the connector there is a field called Additional Properties (Optional).
There we can set any additional request parameter.
As shown in the screenshot I have set it to 600 seconds.
I can extract all big files now. I have also increased the parallel connection from 1 to 4.
The timeout error is not coming anymore.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.