Paul Andrew shows how you can use T-SQL to read an Azure Data Factory ARM template:
While documenting a customers data platform solution I decided it would be far easier if we could summarise the contents of a fairly complex Data Factory using its ARM Template. So, this is what I’ve done using T-SQL to parse the ARM Template JSON and output of series of tables containing details about the factory components.
That is quite the clever solution.