https://community.databricks.com/t5/get-started-discussions/can-api-for-query-history-api-2-0-sql-history-queries-return/m-p/65698#M7068 <P>I am using this api but it is returning the data for only last 30 days. Can this api return data which is older than 30 days?</P> Sat, 06 Apr 2024 13:01:09 GMT RahulChaubey 2024-04-06T13:01:09Z https://community.databricks.com/t5/get-started-discussions/can-api-for-query-history-api-2-0-sql-history-queries-return/m-p/65698#M7068 <P>I am using this api but it is returning the data for only last 30 days. Can this api return data which is older than 30 days?</P> Sat, 06 Apr 2024 13:01:09 GMT https://community.databricks.com/t5/get-started-discussions/can-api-for-query-history-api-2-0-sql-history-queries-return/m-p/65698#M7068 RahulChaubey 2024-04-06T13:01:09Z https://community.databricks.com/t5/get-started-discussions/can-api-for-query-history-api-2-0-sql-history-queries-return/m-p/66350#M7070 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/102764">@RahulChaubey</a>,</P> <P>The query history system table was announced during the Q1 roadmap webinar (see <A href="https://vimeo.com/913913393" target="_self">the recording</A>, 32:25). There is a chance that it will provide data with a horizon beyond 30 days.</P> <P>Meanwhile, you can <A href="https://docs.databricks.com/en/administration-guide/system-tables/index.html#enable-system-table-schemas" target="_self">enable system tables</A> - I hope <A href="https://docs.databricks.com/en/administration-guide/system-tables/index.html#which-system-tables-are-available" target="_self">some already available tables</A> could be helpful for you.</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 16 Apr 2024 13:48:34 GMT https://community.databricks.com/t5/get-started-discussions/can-api-for-query-history-api-2-0-sql-history-queries-return/m-p/66350#M7070 artsheiko 2024-04-16T13:48:34Z