Fetching queries submitted for review via Genie

Subhodeep
New Contributor

‎10-25-2024 06:02 AM

Hi All,

I wanted to know if there is a way to export the list of queries submitted for review via Genie using an API call?

I know there is an API to fetch the query run history but what i need to fetch the list of reviews via Genie.
I would be great if anyone knows anything about it .

thanks,

Subhodeep

0 Kudos

szymon_dybczak
Esteemed Contributor III

‎10-25-2024 07:44 AM

Hi @Subhodeep ,

Unfortunately, currently there is no REST API endpoint. The last information was that the REST API is currently being developed.

So for now you can get review history via UI:

- Work with an AI/BI Genie space - Azure Databricks | Microsoft Learn

0 Kudos

SathyaSDE
Contributor

‎10-27-2024 12:51 AM - edited ‎10-27-2024 12:53 AM

Hi Subhodeep, this new system table "system.access.assistant_events" is closer to what you are looking for ? But it looks like with this new system table introduced, seems like we can expect more around this sooner (in future release).

SathyaSDE_0-1730015229385.png

More information about this system table here, you may need to enable the system schema using API to query it - https://docs.databricks.com/en/admin/system-tables/assistant.html

SathyaSDE_1-1730015434887.png

 

0 Kudos