Successfully compile sp_whoisactive in Azure Synapse (azure sql data warehouse)

[gorkam23]

I've gone through and updated the SP with the Synapse DMVs, but I keep on getting this error:

Msg 103010, Level 16, State 1, Line 12
Parse error at line: 528, column: 36: Incorrect syntax near 'r'.

I've attached my work in progress because I couldn't open a pull request.

Thank you

sp_whoisactive_ASynp_inprogress.zip

[erikdarlingdata]

Hi there! Thanks for the file, but I don't think anyone actively working on this has Azure Synapse available to test things on. If you get this working, drop us a line. But for now I'm going to close this out.