I'm new to Azure cloud and I'm trying to get query/usage statistics of 200 tables in Azure Synapse data warehouse. I want to retrieve following information:
- Which table was queried and how many times?
- Who queried it, and what was the status of it (Completed/Failed/Cancelled)
- Is it used by data factory, PowerBI or any other application like DBeaver?
Which sys table can provide this information? or is there an alternative way to find it out?