There are many reasons why we want to automate Azure Data Explorer solution provisioning: ensuring parity between environments, having fast and low-risk deployments to our production environment, build environments on the fly (e.g. temporary performance test), etc. .
With a recent feature we introduced, it is now easier than ever to build an entire environment with a single tool: ARM template.
We can author a single ARM template to deploy:
Azure Data Explorer cluster
Schema entities on databases: tables, functions, policies, etc.
Data Connections: Event Hub, IoT Hub or Blob Storage connections
A key enabling feature is the ability to deploy KQL scripts. It is now possible to do this without a storage account to store the scripts by simply passing the scripts inline in the ARM templates.
This means we can now have our KQL script in a file and all the deployment described in one (or many) Bicep files and deploying it in a single deployment: no need to break the deployment into steps and run KQL scripts in between!