I am trying to find any solutions or reference where I can run the bunch of KQL files which has the unit test via automated script? What is the best way to automate the KQL unit test? Currently am running it manually these unit test cases but want to convert it to automation. I can create a microservice in spring boot or quarkus but how to read this in the java and automate it? Not just with java any other way to automate this?
There is a Java library provided by Microsoft for this called azure-kusto-java.
It is available on Maven Central as two separate packages.
One for queries: https://mvnrepository.com/artifact/com.microsoft.azure.kusto/kusto-data
And one for ingestion: https://mvnrepository.com/artifact/com.microsoft.azure.kusto/kusto-ingest
Additionally, I just wrapped up work on a Quarkus extension to simplify the process, however I need to get it approved for release into the wild.