How can we find out the name of user who has truncated table in synapse

Question

Hi,

Through log analytics workspace i am able to get session information - session in which truncate operation is performed .. nnow i want to know the user who started this sessio

please provide me with query to run for above req in log analytics.

Thanks,
Mahi

Answer 1

The Monitor tab -> SQL Requests in the Synapse workspace will show the submitter information for specific queries. The session ID isn't displayed on the view by default, but you can use it as a filter or show it as one of the columns.