Metabase throws “Query timed out” error for query that takes longer than 60 seconds in bigquery. Seems tied to https://github.com/metabase/metabase/issues/1749. The 60-second value is hardcoded in line 128 of /modules/drivers/bigquery/src/metabase/driver/bigquery.clj. Could this be modified to accept an environment variable for this value?
It’s correct in the sense it’s there intentionally, the 60s threshold is quite arbitrary though. We might get away with removing it completely with the new streaming QP as it also improves query cancelation. Best we open an issue for it.