Can api for query history /api/2.0/sql/history/queries return data which is older than 30 days?

[RahulChaubey]

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?

[Kaniz]

Hi @RahulChaubey, 

• Databricks API: The /api/2.0/sql/history/queries endpoint you mentioned might have limitations in returning historical data beyond the last 30 days. Unfortunately, based on the available information, it seems that this API does not directly support ...¹.

[artsheiko]

Hi @RahulChaubey,

The query history system table was announced during the Q1 roadmap webinar (see the recording, 32:25). There is a chance that it will provide data with a horizon beyond 30 days.

Meanwhile, you can enable system tables - I hope some already available tables could be helpful for you.