DBeaver query on Snowflake results in "SQL Error [604] [57014]: SQL execution canceled" if lasting around 5 minutes

user_10331351 0
Viewed 478

We are using dbeaver quite happily with Snowflake back end but I can't execute queries that last around 5 minutes or more.

It looks like there is sometimeout somewhere and the execution seems cancelled by DBeaver.

The error message is "SQL Error [604] [57014]: SQL execution canceled"

Any idea how I could instruct DBeaver to wait for whatever it takes?

DBeaver Errors and timeouts

dbeaver snowflake-cloud-data-platform
1 Answers

This is probably because the STATEMENT_TIMEOUT_IN_SECONDS parameter has been set to cancel all queries after they run for 5 minutes or more.

You can check what it is set to by running this in dbeaver.

show parameters like '%STATEMENT_TIMEOUT%' in session;
user_32872500
Related