question

RohitBoddu-8474 avatar image
0 Votes"
RohitBoddu-8474 asked SamaraSoucy-MSFT answered

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

Hi,

Through log analytics workspace i am able to get session information - session in which truncate operation is performed .. n*now 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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SamaraSoucy-MSFT avatar image
0 Votes"
SamaraSoucy-MSFT answered

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



untitled.png (133.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.