https://community.databricks.com/t5/data-governance/creating-a-persistent-query-history-table-using-the-rest-api/m-p/93355#M2177 <P>Hello all,</P><P>I am looking for a way to load a persistent query history table from the query history REST API (including metrics). I do know about the system table system.query.history, but I do not have access to it.</P><P>I am looking to create a python script to load this table on a daily basis. Does anyone have code they'd be willing to share?</P> Wed, 09 Oct 2024 19:30:39 GMT WWoman 2024-10-09T19:30:39Z https://community.databricks.com/t5/data-governance/creating-a-persistent-query-history-table-using-the-rest-api/m-p/93355#M2177 <P>Hello all,</P><P>I am looking for a way to load a persistent query history table from the query history REST API (including metrics). I do know about the system table system.query.history, but I do not have access to it.</P><P>I am looking to create a python script to load this table on a daily basis. Does anyone have code they'd be willing to share?</P> Wed, 09 Oct 2024 19:30:39 GMT https://community.databricks.com/t5/data-governance/creating-a-persistent-query-history-table-using-the-rest-api/m-p/93355#M2177 WWoman 2024-10-09T19:30:39Z https://community.databricks.com/t5/data-governance/creating-a-persistent-query-history-table-using-the-rest-api/m-p/95103#M2208 <P>Hi,</P> <P>Can you check if you have access to this?</P> <P><A href="https://github.com/dbsys21/lakehouse-tacklebox/tree/main/40-observability/dbsql-query-history-sync" target="_blank">https://github.com/dbsys21/lakehouse-tacklebox/tree/main/40-observability/dbsql-query-history-sync</A></P> <P>Ideally your organization should enable the system tables and provide the necessary access, so each team doesn't have to reinvent the wheel.</P> Sun, 20 Oct 2024 22:34:10 GMT https://community.databricks.com/t5/data-governance/creating-a-persistent-query-history-table-using-the-rest-api/m-p/95103#M2208 MoJaMa 2024-10-20T22:34:10Z