Run stops after 300s regardless to profiles.yml configuration. Bigquery plugin

Help
1

Hey all,

im trying to run a large model and I’m running into a
“Runtime Error in model… Query exceeded configured timeout of 300s”
**when trying to run a specific file.

This happens after about 5 minutes,

image
image1850×224 38.9 KB

but my timeout in the profiles.yml file is defined to be 10 minutes:
job_execution_timeout_seconds: 600

I’ve updated my version:
Core:

  • installed: 1.6.4
  • latest: 1.6.4 - Up to date!

Plugins:

  • bigquery: 1.6.6 - Up to date!

I’ve also tried to reduce the “job_execution_timeout_seconds” to be 60 seconds to check if it will stop after 60 seconds but it still runs about 5 minutes and then stops.

2

Never had this problem :frowning:

But what I would try:

In the docs you have this:

The job_execution_timeout_seconds represents the number of seconds to wait for the underlying HTTP transport. It doesn’t represent the maximum allowable time for a BigQuery job itself. So, if dbt-bigquery ran into an exception at 300 seconds, the actual BigQuery job could still be running for the time set in BigQuery’s own timeout settings.

So, maybe try changing the default_query_job_timeout_ms in BigQuery’s own settings