Generally available: Azure Data Explorer Inline script deployment with ARM Template

It is now easier than ever to build an entire Azure Data Explorer environment with a single tool: ARM template.

From a single ARM Template we can now deploy schema entities (e.g. tables, functions, policies) without the usage of an external storage account.

This enables end-to-end deployment of Azure Data Explorer solutions to build new environment from scratch or update existing ones incrementally (e.g. CI/CD).

{ "type": "Microsoft.Kusto/Clusters/Databases/Scripts", "apiVersion": "2022-02-01", "name": "myScript", "properties": { "scriptContent": ".create table Simple(Id:int)\n\n.create table Simple2(Name:string)" }}

Using Bicep ARM Template makes it easy to maintain KQL scripts in separate files:

resource perfTestDbs 'Microsoft.Kusto/clusters/databases/scripts@2022-02-01' = { name: 'myScript' properties: { scriptContent: loadTextContent('script.kql') }}

Learn about it in the Online documentation and Blog post.