Set specific timeouts for individual SQL warehouses.
The Warehouse-level statement timeout feature allows users to specify a timeout duration for SQL statements executed on individual SQL warehouses, with the timeout duration set in seconds. This timeout applies only to the specific warehouse, enabling different warehouses to have tailored timeout settings based on their use cases. The timeout can be configured using the `statement_timeout` field in the Create or Update warehouse APIs, and it can be set to any value between 0 and 172800 seconds (2 days). If the execution time of a statement exceeds the specified timeout, the statement is halted.
This feature enhances resource management and query performance by allowing organizations to optimize SQL execution times based on the specific needs of different workloads, such as ETL versus BI. By applying tailored timeouts, businesses can reduce the risk of long-running queries consuming resources unnecessarily, leading to improved overall system performance and cost efficiency.