SQL warehouse activity during result fetch

Question

If query execution completes but result fetch is still going on for n minutes, does SQL warehouse shut down after configured Auto stop minutes or wait till the result fetch is completed and then stop after Auto stop minutes? Basically does Databricks consider result fetch duration as active or inactive status of a SQL warehouse?

Answer 1

Hello Divyatej S T (Nokia),

Welcome to the Microsoft Q&A and thank you for posting your questions here.

I understand that you would like to know about your SQL warehouse activity during result fetch.

Regarding your question:

Yes, Databricks considers result fetch duration as “active” activity.

The SQL warehouse will not auto-stop while a client is still fetching results, even if the query execution has already completed. The auto stop timer only starts after all result fetching is complete and there are no active queries or fetches. - https://community.databricks.com/t5/warehousing-analytics/big-problem-with-sql-warehouse-auto-stop/td-p/103949

I hope this is helpful! Do not hesitate to let me know if you have any other questions or clarifications.

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.