Azure CLI Kusto Query Not Possible Making Deployments Messy

Question

Automated workflow for setting up a functioning Azure Data Explorer could use some refactoring or I could use some tips.

While you can create a ADE / kusto instance via Azure CLI , unless i'm missing something, you can't run queries which prevents one from setting up necessary tables and mapping functions in order to use the same Az CLI to setup database connections. Automated workflow is then something like:

1. Run az kusto commands to create & deploy cluster
2. Use some complicated-to-integrate tool to run queries to setup tables and mapping functions via REST API
3. Run az kusto commands to setup connections using the tables & mappings created in step 2

If Az Kusto command set could run queries, this would greatly simplify the complexity of setting up a Kusto cluster. I'm eyeing Az list at https://learn.microsoft.com/en-us/cli/azure/kusto?view=azure-cli-latest , it appears as if there is the sparsely documented "create script" option that might work but there isn't really enough docs to use it nor does it clearly indicate if it can run the script rather than just create the script. Anyone have an idea CLI method to deploy and setup a kusto cluster?

Answer 1

Hello @Nate Zimmer ,

Thanks for the question and using MS Q&A platform.

Have you tested ADO pipeline task named 'Azure Data Explorer Command (Internal)'?

We are using that to modify our kusto cluster like so:

Otherwise look for "Kusto CLI" in the document - Create an Azure Data Explorer cluster and database by using Azure CLI. That cli allows to send commands and queries to engine.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators