Share queries from Azure Data Explorer web UI

This article describes the process of sharing queries from the Azure Data Explorer web UI. By the end of this article, you'll know how to share a query link, share the query results, or even pin it to a dashboard.

To learn how to run queries, see Quickstart: Query data in the Azure Data Explorer web UI.

Prerequisites

  • A Microsoft account or an Azure Active Directory user identity. An Azure subscription isn't required.
  • Access to an Azure Data Explorer cluster and database. You may use the publicly available help cluster or create a cluster and database.

Share options

The following table outlines the many options for how to share a query.

Action Description
Pin to dashboard Display the query in an Azure Data Explorer dashboard.
Link to clipboard Copy a link that can be used to run the query.
Link, query to clipboard Copy a link that can be used to run the query and the text of the query.
Link, query, results to clipboard Copy a link that can be used to run the query, the text of the query, and the results of the query.
Download Download a KQL file of the query.
Export to CSV Download a CSV of the query results.

Pin to dashboard

To pin a query to a dashboard for continuous monitoring, follow these steps:

  1. In the query window, select the query that you want to pin.

  2. Select Pin to dashboard.

    Screenshot of the pin to dashboard button.

  3. In the Pin to dashboard pane:

    1. Provide a Tile name.
    2. Select Use existing or Create new.
    3. Provide the Dashboard name.
    4. Select the View dashboard after creation checkbox (if it's a new dashboard).
    5. Select Pin.

Note

Pin to dashboard only pins the selected query. To create the dashboard data source and translate render commands to a visual in the dashboard, the relevant database must be selected in the database list.

To copy a link to share with others, follow these steps:

  1. In the query window, select the query that you want to share.

  2. Under Copy, select Link to clipboard.

    Screenshot of the link to clipboard button.

  3. Paste the link into a new browser window to run the query.

Note

The user must have access to the cluster to run the query.

To copy a link to share with others and the text of the query, follow these steps:

  1. In the query window, select the query that you want to share.

  2. Under Copy, select Link, query to clipboard.

    Screenshot of the link, query to clipboard button.

  3. Paste to share. The output lists the link followed by the query text.

To copy a link to share with others, the text of the query, and the results of the query, follow these steps:

  1. In the query window, select the query that you want to share.

  2. Under Copy, select Link, query, results to clipboard.

    Screenshot of the link, query, results to clipboard button.

  3. Paste to share. The output lists the link, query text, and query results.

Download

To download a KQL file of the query, follow these steps:

  1. In the query window, select the query that you want to download.

  2. Select Export > Download.

    Screenshot of the download button.

Export to CSV

To export the query results to a CSV file, follow these steps:

  1. In the query window, select the query that you want to export.

  2. Select Export > Export to CSV.

    Screenshot of the export to CSV button.