When configuring a database, you need to take care of multiple components and make sure they are properly set-up.
This includes creating tables, mapping rules, data connection or modifying existing ones.
We’ve recently released a new capability that allows using Kusto query language scripts to achieve all of that easily in one operation (in addition to using data plane control commands or the Azure Portal).
You can use such scripts to create a table, mapping rule and a data connection, to automate the flow of resource creation and data ingestion.
You can use scripts either by uploading the KQL command to an Azure storage account or by using it inline.
One point to consider is, we recommend using the ‘.create-or-alter’ commands rather the ‘.create’ commands to make your scripts reusable and idempotent.
For more details on how to use scripts to configure databases, and an ARM template example, read this - https://docs.microsoft.com/en-us/azure/data-explorer/database-script
You’re welcome to add more proposals and ideas and vote for them here - https://aka.ms/adx.ideas
Azure Data Explorer team
