topic Fetching queries submitted for review via Genie in Data Engineering

Fetching queries submitted for review via Genie

Subhodeep — Fri, 25 Oct 2024 13:02:54 GMT

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

Re: Fetching queries submitted for review via Genie

szymon_dybczak — Fri, 25 Oct 2024 14:44:29 GMT

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

Re: Fetching queries submitted for review via Genie

SathyaSDE — Sun, 27 Oct 2024 07:53:22 GMT

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