failed to add query result to dynamic destination table (on a simple query) about bigquery-emulator

[ohaibbq]

It seems to me like the BigQuery client is retrying your query as the server closed the connection.
Judging by the timestamps in your logs, I'm guessing you're running into this issue: #213 / #266
@goccy Do you have any opinions on #266?

[Cililing]

BQ client allows specifying the job timeout (--job_timeout_ms=100000), which is ignored by the emulator.

The python lib has this possibility as well:

def query(
        ....
        timeout: TimeoutType = DEFAULT_TIMEOUT
    )
---
DEFAULT_RETRY = retry.Retry(predicate=_should_retry, deadline=600.0)
"""The default retry object.

Any method with a ``retry`` parameter will be retried automatically,
with reasonable defaults. To disable retry, pass ``retry=None``.
To modify the default retry behavior, call a ``with_XXX`` method
on ``DEFAULT_RETRY``. For example, to change the deadline to 30 seconds,
pass ``retry=bigquery.DEFAULT_RETRY.with_deadline(30)``.
"""

DEFAULT_TIMEOUT = None
"""The default API timeout.

This is the time to wait per request. To adjust the total wait time, set a
deadline on the retry object.
"""

[ohaibbq]

This should be closed now that #266 has been merged.

[ohaibbq]

Did the new release fix your issue? @Cililing