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

Rohit Boddu 461 Reputation points
2021-05-06T12:57:21.567+00:00

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

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,141 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Samara Soucy - MSFT 5,046 Reputation points
    2021-05-08T19:17:18.713+00:00

    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.

    94993-untitled.png

    0 comments No comments