skip to Main Content

in the Pipeline Expression builder I want to run one command to ingest data into different tables. How is that possible? Below would be two commands who would work on its own, but I want to combine them and run them in one command:

.set table_1 with (extend_schema=true) <|
let output_1 = function_1;
output_1
.set table_2 with (extend_schema=true) <|
let output_2 = function_2;
output_2

Output_1 would be assigned to table_1 and output_2 would be assigned to table_2

2

Answers


  1. There is an Azure DevOps extension provided by Microsoft: Azure Data Explorer – Pipeline Tools.

    This extension provides the pipelines tasks to integrate Azure DevOps Pipelines with Azure Data Explorer and run the Kusto queries.

    you can install this extension to your Azure DevOps organization, and then try the provided tasks in your pipeline.

    Also reference the docs "Azure DevOps Task for Azure Data Explorer".

    Login or Signup to reply.
  2. In KQL is an execute database script command. It executes a batch of management commands in the scope of a single database. Reference: https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/execute-database-script

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search