Fetching queries submitted for review via Genie

[Subhodeep]

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

[szymon_dybczak]

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

[SathyaSDE]

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).

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