topic how to view row produced from rest API in databricks for long running queries in Running state in Data Engineering https://community.databricks.com/t5/data-engineering/how-to-view-row-produced-from-rest-api-in-databricks-for-long/m-p/93461#M38711 <DIV><DIV><SPAN>&nbsp; &nbsp;</SPAN><SPAN>print</SPAN><SPAN>(</SPAN><SPAN>f</SPAN><SPAN>"Query ID: </SPAN><SPAN>{</SPAN><SPAN>query[</SPAN><SPAN>'query_id'</SPAN><SPAN>]</SPAN><SPAN>}</SPAN><SPAN> ,Duration: </SPAN><SPAN>{</SPAN><SPAN>query[</SPAN><SPAN>'duration'</SPAN><SPAN>]</SPAN><SPAN>}</SPAN><SPAN> ms,user :</SPAN><SPAN>{</SPAN><SPAN>query[</SPAN><SPAN>'user_display_name'</SPAN><SPAN>]</SPAN><SPAN>}</SPAN><SPAN>,Query_execute :</SPAN><SPAN>{</SPAN><SPAN>query[</SPAN><SPAN>'query_text'</SPAN><SPAN>]</SPAN><SPAN>}</SPAN><SPAN>,Query_status : </SPAN><SPAN>{</SPAN><SPAN>query[</SPAN><SPAN>'status'</SPAN><SPAN>]</SPAN><SPAN><SPAN>},</SPAN></SPAN><DIV><DIV><SPAN>rw:{query['rows_produced']}"</SPAN></DIV></DIV><SPAN>"</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>U am able to get rows_produced only for 'FINISHED'&nbsp;</SPAN></DIV><DIV><SPAN>but i need this rows_produced for 'CANCELLED' and 'RUNNING'</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV> Thu, 10 Oct 2024 15:16:17 GMT slakshmanan 2024-10-10T15:16:17Z how to view row produced from rest API in databricks for long running queries in Running state https://community.databricks.com/t5/data-engineering/how-to-view-row-produced-from-rest-api-in-databricks-for-long/m-p/93461#M38711 <DIV><DIV><SPAN>&nbsp; &nbsp;</SPAN><SPAN>print</SPAN><SPAN>(</SPAN><SPAN>f</SPAN><SPAN>"Query ID: </SPAN><SPAN>{</SPAN><SPAN>query[</SPAN><SPAN>'query_id'</SPAN><SPAN>]</SPAN><SPAN>}</SPAN><SPAN> ,Duration: </SPAN><SPAN>{</SPAN><SPAN>query[</SPAN><SPAN>'duration'</SPAN><SPAN>]</SPAN><SPAN>}</SPAN><SPAN> ms,user :</SPAN><SPAN>{</SPAN><SPAN>query[</SPAN><SPAN>'user_display_name'</SPAN><SPAN>]</SPAN><SPAN>}</SPAN><SPAN>,Query_execute :</SPAN><SPAN>{</SPAN><SPAN>query[</SPAN><SPAN>'query_text'</SPAN><SPAN>]</SPAN><SPAN>}</SPAN><SPAN>,Query_status : </SPAN><SPAN>{</SPAN><SPAN>query[</SPAN><SPAN>'status'</SPAN><SPAN>]</SPAN><SPAN><SPAN>},</SPAN></SPAN><DIV><DIV><SPAN>rw:{query['rows_produced']}"</SPAN></DIV></DIV><SPAN>"</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>U am able to get rows_produced only for 'FINISHED'&nbsp;</SPAN></DIV><DIV><SPAN>but i need this rows_produced for 'CANCELLED' and 'RUNNING'</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV> Thu, 10 Oct 2024 15:16:17 GMT https://community.databricks.com/t5/data-engineering/how-to-view-row-produced-from-rest-api-in-databricks-for-long/m-p/93461#M38711 slakshmanan 2024-10-10T15:16:17Z Re: how to view row produced from rest API in databricks for long running queries in Running state https://community.databricks.com/t5/data-engineering/how-to-view-row-produced-from-rest-api-in-databricks-for-long/m-p/93644#M38740 <DIV><DIV><SPAN>https://</SPAN><SPAN>{</SPAN><SPAN>databricks_instance</SPAN><SPAN>}</SPAN><SPAN>.cloud.databricks.com/api/2.0/sql/history/queries?include_metrics=true</SPAN></DIV></DIV> Fri, 11 Oct 2024 15:47:29 GMT https://community.databricks.com/t5/data-engineering/how-to-view-row-produced-from-rest-api-in-databricks-for-long/m-p/93644#M38740 slakshmanan 2024-10-11T15:47:29Z