Kusto Tools

This extension adds an ability to execute a Kusto query as a Release gate or in an agentless phase of the deployment process.

Using Query Kusto gate or task, you can provide a query and ensure the number of output rows returned is acceptable.

How to add Query Kusto as a Gate

Release gates documentation

Once we go to Release Definition, by accessing pre/post approval setting we can enable Gates and add Query Kusto as a Gate

We can query Kusto using Inline query

We can query Kusto using File path

How to add an endpoint to be used by Query Kusto Gate or Task

Getting ApplicationId and ApplicationKey

How to add Query Kusto as a Task

Input parameters

• Service endpoint: Select a Kusto endpoint that should be used to connect to Kusto, to execute the query. Check section How to add an endpoint to be used by Query Kusto Gate or Task to add a Kusto endpoint.

• Database name: Kusto database name to run the query. example: vso or vsodev.

• Type: Query can be taken from a repository file path or inline.

  Parameters for Inline query

  • Inline query: You can write your Kusto query. More info on Kusto query language.

  Parameters for File path

  • Repository name: Repository name in which query file exists.

  • Branch name: Branch name in which query file exists. example, master.

  • Query file full path: Query (csl) file full path in the given branch. example, /MyKustoQueries/KustoQuery.csl.

• Maximum threshold: The maximum number of rows from the query result.

• Minimum threshold: The minimum number of rows from the query result.

How to adjust threshold

Max and min threshold are output rows expected from the Kusto query