Azure Data Explorer (Preview)

Azure Data Explorer a.k.a Kusto is a log analytics cloud platform optimized for ad-hoc big data queries. Read more about it here: http://aka.ms/kdocs

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure China regions
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
Contact
Name Microsoft
URL Microsoft LogicApps Support
Microsoft Power Automate Support
Microsoft Power Apps Support
Connector Metadata
Publisher Microsoft

Known Issues and Limitations

Calculating work units

Throttling Limits

Name Calls Renewal Period
API calls per connection20060 seconds
Work units per day9000086400 seconds

Actions

Run control command and visualize results

Returns the Kusto control command result as a chart of your choice.

Run control show command and list results

Runs the show control command and returns the result as a set of rows which can be iterated over in the following connectors.

Run query and list results

Runs the query and returns the result as a set of rows which can be iterated over in the following connectors.

Run query and visualize results

Returns the Kusto query result as a chart of your choice.

Run control command and visualize results

Returns the Kusto control command result as a chart of your choice.

Parameters

Name Key Required Type Description
Cluster URL
cluster True string

Specify the cluster url e.g. https://..kusto.windows.net

Database Name
db True string

Specify the database name

Control Command
csl True string

Specify the control command you would like to run

Chart Type
chartType True string

Specify the resulting chart type

Returns

Run control show command and list results

Runs the show control command and returns the result as a set of rows which can be iterated over in the following connectors.

Parameters

Name Key Required Type Description
Cluster URL
cluster True string

Specify the cluster url e.g. https://..kusto.windows.net

Database Name
db True string

Specify the database name

Control Command
csl True string

Specify the show control command you would like to run

Returns

The outputs of this operation are dynamic.

Run query and list results

Runs the query and returns the result as a set of rows which can be iterated over in the following connectors.

Parameters

Name Key Required Type Description
Cluster URL
cluster True string

Specify the cluster url e.g. https://..kusto.windows.net

Database Name
db True string

Specify the database name

Query
csl True string

Specify the query you would like to run

Returns

The outputs of this operation are dynamic.

Run query and visualize results

Returns the Kusto query result as a chart of your choice.

Parameters

Name Key Required Type Description
Cluster URL
cluster True string

Specify the cluster url e.g. https://..kusto.windows.net

Database Name
db True string

Specify the database name

Query
csl True string

Specify the query you would like to run

Chart Type
chartType True string

Specify the resulting chart type

Returns

Definitions

VisualizeResults

Name Path Type Description
Body
body byte

The body of the result in base64 encoding.

BodyHtml
bodyHtml HTML

The body of the result in html encoding.

Attachment Content
attachmentContent byte

The content of the attachment.

Attachment Name
attachmentName string

The name of the attachment file.

Links to Kusto Explorer
kustoDeepLink string

Links to run the query in Kusto tools, for instance in KustoExplorer.