Greeting everyone, Currently I am experiencing issues with running more complex queries using Snowflake as source. Currently whenever I run a more complex report which takes longer than 60 seconds I get your question took too long error and I can see in Snowflake query history that that query is SQL execution canceled.
I checked and on Snowflake side the timeout is much longer than 60 seconds for both the warehouse and the user so I believe the problem is in my metabase configuration.
I didn't have that much luck in finding the solution to this problem and I did try and tweak the JDBC string connector options but with no luck as after I still set the value to queryTimeout=300 I am still getting the same error.
Will be posting diag info for easier debug and if any additonal information is needed please let me know. The issue was reported on multiple machines via multiple accounts so I believe it is not related to that.
Diag info:
{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"metabase-info": {
"databases": [
"snowflake"
],
"run-mode": "prod",
"plan-alias": "",
"version": {
"date": "2025-03-11",
"tag": "v0.53.6",
"hash": "a8ca5db"
},
"settings": {
"report-timezone": null
},
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "15.3"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.7.4"
}
}
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "21.0.6+7-LTS",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "21.0.6",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "21.0.6+7-LTS",
"os.name": "Linux",
"os.version": "5.15.0-307.178.5.el8uek.x86_64",
"user.language": "en",
"user.timezone": "UTC"
}
}