I would like to automate the deployment of a standard Azure logic app that does the following…
-
Starts with a reoccurrence trigger (this i know how to do)
-
Using a “sql connector” (think I should use a built-in connector as the logic app is using vnet integration) connect to an Azure sql database and execute a simple “sql select” query.
-
The query will be executed using the ‘user assigned managed identity’ of the logic app which will be created as login in the database with “db_datareader” perms.
I am looking for a example or tutorial on how to Terraform the above. I have looked but found examples of using smtp and storage accounts…