Microsoft.Azure.WebJobs.Extensions.Kusto

Kusto bindings for Azure Functions - Preview

Table of Contents

• Kusto bindings for Azure Functions - Preview
  • Table of Contents
  • Introduction
  • Input Bindings
  • Output Bindings
  • Trademarks

Introduction

This repository contains the Kusto bindings for Azure Functions extension code as well as a quick start tutorial and samples illustrating how to use the binding in different ways. The types of bindings supported are:

Input Binding

Takes a KQL query or KQL function to run (with optional parameters) and returns the output to the function. The input binding takes the following attributes

• Database: The database against which the query has to be executed

• KqlCommand: The KqlQuery that has to be executed. Can be a KQL query or a KQL Function call

• KqlParameters: Parameters that act as predicate variables for the KqlCommand. For example "@name={name},@Id={id}" where the parameters {name} and {id} will be substituted at runtime with actual values acting as predicates

• Connection: The name of the variable that holds the connection string, resolved through environment variables or through function app settings. Defaults to lookup on the variable KustoConnectionString, at runtime this variable will be looked up against the environment. Documentation on connection string can be found at Kusto connection strings e.g.: "KustoConnectionString": "Data Source=https://cluster.kusto.windows.net;Database=Database;Fed=True;AppClientId=AppId;AppKey=AppKey;Authority Id=TenantId Note that the application id should atleast have viewer privileges on the table(s)/function(s) being queried in the KqlCommand

Output Binding

Takes row(s) and inserts them into the Kusto table (i.e. If a row doesn't already exist, it is added. If it does, it is updated).

• Database: The database against which the query has to be executed

• TableName: The table to ingest the data into

• Connection: Refer Connection attribute above.Note that the application id should have ingest privileges on the table being ingested into

Samples

Samples for C# are available and available at the following. This can run with local functions framework. Set up and run samples are available at the following location

• .NET (C# in-process)

Known Issues

Trademarks

This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft’s Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party’s policies.