Azure Synapse SQL on-demand query logs

Question

I have a question about getting the detailed query usage logs from Azure Synapse on-demand.

With

SELECT * FROM sys.dm_external_data_processed

I can get the daily/weekly usage. It’s good.

But I need to get a result like this:

in a "exportable" way (TSQL or something to query and get usage details for export needs).

I've tried to google it. But with no luck.

Answer 1

Ok, I found it.

On each serverless DB this query gives the details:

SELECT TOP 1000 * FROM sys.dm_exec_requests_history order by start_time desc