3 weeks ago
We have an external service connecting to a SQL Warehouse, running a query that normally lasts 30 minutes.
On occasion an error occurs and it will run for 6 hours.
This happens overnight and is contributing to a larger bill. Is there any way to force long running queries to time out or the SQL Warehouse to have a limited keep-alive time even if there are active queries?
3 weeks ago
Hello @Kayla , I hope this message finds you well.
Have you tried the STATEMENT_TIMEOUT?
The STATEMENT_TIMEOUT configuration parameter sets a timeout value in seconds. Any Databricks SQL statement with a wall clock run time exceeding the value is timed out.
You can set this parameter at the session level using the SET statement and at the global level using Configure SQL parameters or SQL Warehouses API.
Best regards,
Lucas Rocha
3 weeks ago
Hello @Kayla , I hope this message finds you well.
Have you tried the STATEMENT_TIMEOUT?
The STATEMENT_TIMEOUT configuration parameter sets a timeout value in seconds. Any Databricks SQL statement with a wall clock run time exceeding the value is timed out.
You can set this parameter at the session level using the SET statement and at the global level using Configure SQL parameters or SQL Warehouses API.
Best regards,
Lucas Rocha
3 weeks ago - last edited 3 weeks ago
Hello @Kayla, maybe the STATEMENT_TIMEOUT configuration parameter is what you're looking for.
This parameter can be set at session or global level.
3 weeks ago
@lucasrocha @raphaelblg That is exactly what I was hoping to find. Thank you!
Excited to expand your horizons with us? Click here to Register and begin your journey to success!
Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!