Redaguoti

Bendrinti naudojant


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 a Microsoft Entra user identity. An Azure subscription isn't required.
  • An Azure Data Explorer cluster and database. 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.
Open in Excel Open a live query in an Excel workbook that can be refreshed directly from Excel.
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.

Open in Excel

To access live results of your query in an Excel workbook, follow these steps:

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

  2. Select Export > Open in Excel.

    Screenshot of option to open in excel.

  3. Open and share the downloaded Excel workbook, which is connected to Azure Data Explorer and can be refreshed. You can refresh your Excel workbook with new data from Azure Data Explorer, and all related Excel artifacts, like charts and pivot tables, will be updated based on the new data.

Note

Depending on your Excel settings, you may need to enable editing and grant permission to access external data connections for the file to update.

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.