https://community.databricks.com/t5/data-engineering/get-queries-history-run-on-uc-enabled-interactive-cluster/m-p/79139#M35683 <P>Hi Team,</P><P>I want to derived couple of kpis like most frequent queries, top queries, query type like select, insert or update on UC enabled interactive cluster.&nbsp;</P><P>I know we can do this for SQL warehouse but what is the way we can do this interactive cluster?. plz help it is urgent.</P><P>i checked system.audit table but there entries are not consistent. if i run normal select query, audit tables is showing 2 to 3 entries in table, all 3 rows are same except event_id.</P><P>&nbsp;</P><P>Plz help .</P> Wed, 17 Jul 2024 16:06:10 GMT ayush25091995 2024-07-17T16:06:10Z https://community.databricks.com/t5/data-engineering/get-queries-history-run-on-uc-enabled-interactive-cluster/m-p/79139#M35683 <P>Hi Team,</P><P>I want to derived couple of kpis like most frequent queries, top queries, query type like select, insert or update on UC enabled interactive cluster.&nbsp;</P><P>I know we can do this for SQL warehouse but what is the way we can do this interactive cluster?. plz help it is urgent.</P><P>i checked system.audit table but there entries are not consistent. if i run normal select query, audit tables is showing 2 to 3 entries in table, all 3 rows are same except event_id.</P><P>&nbsp;</P><P>Plz help .</P> Wed, 17 Jul 2024 16:06:10 GMT https://community.databricks.com/t5/data-engineering/get-queries-history-run-on-uc-enabled-interactive-cluster/m-p/79139#M35683 ayush25091995 2024-07-17T16:06:10Z https://community.databricks.com/t5/data-engineering/get-queries-history-run-on-uc-enabled-interactive-cluster/m-p/79294#M35725 <P><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/9">@Retired_mod</a>&nbsp;, this table will only the query history for sql warehouse cluster, i need for UC interactive/All purpose cluster.&nbsp;</P> Thu, 18 Jul 2024 17:59:33 GMT https://community.databricks.com/t5/data-engineering/get-queries-history-run-on-uc-enabled-interactive-cluster/m-p/79294#M35725 ayush25091995 2024-07-18T17:59:33Z