I am evaluating some large queries on parquet data accessed via OPENROWSET views on the built-in Synapse serverless pool. Some of them fail after about 30 minutes of execution with a query timeout expired error. The queries fail due to timeout whether I evaluate them on Synapse Studio, SSMS, or via JDBC. In the case of JDBC, the setQueryTimeout method does not have an effect on the server side.
I would like to modify the query timeout to make it larger, however, so far I have not been able to find out how to do so or to determine if it is possible from the documentation. For instance, using sp_configure or a resource class does not work since they are not supported on serverless. Thank you very much for your help.