Some of my queries are timing out after running for 2 mins resulting in an error. How can I increase the default query timeout limit?
As an admin you can change the connection timeout time in the admin portal under “Connections”. Each connection will be given a default timeout time of 120 seconds, you will be able to change this to whatever you see fit!
Another way to avoid timeouts would be to materialize the dataset from which the worksheet comes from. Materializing a dataset back into your warehouse increases performance by simplifying these complex SQL queries.
New materialization link here