get saved query by name using rest API or databricks SDK

mahfooziiitian
Databricks Partner

‎08-09-2024 08:21 AM

Hi All,

I want to get the saved query by name using rest API or databricks SDK. So It do not find any direct end point or method which can give us the saved query by name.

I have one solution as given below:

  1. get the list all queries
  2. filter the my queries from list of queries

But databricks is saying that if you are calling list all queries end point (List queries ) multiple then it might ban temporarily.

Can you suggest us how can I get the query without using list all queries end point?

mahfooz.iiitian
0 Kudos

szymon_dybczak
Esteemed Contributor III

‎08-10-2024 09:50 AM - edited ‎08-10-2024 09:53 AM

Hi @mahfooziiitian ,

  1. The answer is no, currently you can get saved query only by id. If your are afraid of exceeding concurrent calls, then design a process that as a first step will use list queries endpoint to extract endpoint IDs and names and save that information to a Delta Table. Then you can lookup endpoint names, IDs in that table and use it to download specific query in later steps of the process. That's how you can avoid exceeding API limits
0 Kudos

mahfooziiitian
Databricks Partner
In response to szymon_dybczak

‎08-11-2024 05:18 AM

I have tried this solution but problem with this solution is that new query details will not be available until we are preloading the data again. I am thinking of using pagination by using attributes page_token,next_page_token,page_size and loop through it until we find the query. This might not exceed concurrent API Limit. I need to just verify it with databricks team.

mahfooz.iiitian
0 Kudos

szymon_dybczak
Esteemed Contributor III
In response to mahfooziiitian

‎08-12-2024 06:59 AM

Cool that you found workaround that works for you.

0 Kudos