Now that you use Bicep or JSON template, you can include the script and have dependencies make sure the script is deployed when the database is ready and the data connection is deployed when the script has been executed, making sure the landing table used by the data connection exists in the database.
At the end, we have all the pieces of our pipeline deployed from one ARM template and our database can ingest data from our Event Hub!
The script deployment is the key component enabling this scenario. Today we can deploy up to 50 scripts per cluster (typically one script per database) ; that limitation will be lifted in a few months.
This capability will soon be available in Terraform as well!