cancel
Showing results for 
Search instead for 
Did you mean: 

How to create a raw data (with filter_by) to pull query history from now to 5 mins ago

Chinu
New Contributor III

Hi Team,

Is it possible I can use "query_start_time_range" filter from the api call to get the query data only from now to 5 mins ago?

Im using telegraf to call query history api but it looks like Im reaching the max return and I can't find how to use the pagination from telegraf.

My idea is running telegraf every 5 min and get the query history for the last 5 mins.

Thanks for the help.

Chinu Lee

1 ACCEPTED SOLUTION

Accepted Solutions

User16869509900
Valued Contributor

Have you checked this https://docs.databricks.com/api-explorer/workspace/queryhistory/list you can list the queries based on time range as well. So you can try passing the fields in the filter_by parameter. Then pass the value as (current time - 5 min)

View solution in original post

1 REPLY 1

User16869509900
Valued Contributor

Have you checked this https://docs.databricks.com/api-explorer/workspace/queryhistory/list you can list the queries based on time range as well. So you can try passing the fields in the filter_by parameter. Then pass the value as (current time - 5 min)

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.