Kusto.WebExplorerKusto.WebExplorer

Kusto.WebExplorer 是一个 Web 应用程序,可用于向 Kusto 服务发送查询和控制命令。Kusto.WebExplorer is a web application that can be used to send queries and control commands to a Kusto service. 应用程序托管在 https://dataexplorer.azure.cn/The application is hosted at https://dataexplorer.azure.cn/.

Kusto.WebExplorer 也可以由其他 Web 门户在 HTML IFRAME 中托管。Kusto.WebExplorer can also be hosted by other web portals in an HTML IFRAME. (例如,此操作由 Azure 门户完成。)请参阅 Monaco IDE,详细了解如何托管它以及它使用的 Monaco 编辑器。(For example, this is done by the Azure portal.) See Monaco IDE for details on how to host it and the Monaco editor it uses.

连接到多个群集Connect to multiple clusters

现在可以连接多个群集并在数据库和群集之间切换。You can now connect multiple clusters and switch between databases and clusters. 该工具旨在轻松识别你所连接的群集和数据库。The tool is designed to easily identify the cluster and database to which you are connected.

动画 GIF。在 Azure 数据资源管理器中单击“添加群集”并在对话框中输入群集名称时,群集将显示在左窗格中。Animated GIF. When Add Cluster is clicked in Azure Data Explorer and a cluster name is entered in a dialog box, the cluster appears in the left pane.

重新调用结果Recall results

通常在分析期间,我们运行多个查询,并且可能需要重新访问前一个查询的结果。Often during analysis, we run multiple queries and may have to revisit the results of the previous queries. 可以使用此功能重新调用结果,而不必重新运行查询。You can use this feature to recall your results without having to rerun the query. 数据通过本地客户端缓存提供。The data is served from local client-side cache.

动画 GIF。运行两个 Azure 数据资源管理器查询后,鼠标移动到第一个查询并单击“重新调用”。初始结果将再次出现。Animated GIF. After two Azure Data Explorer queries run, the mouse moves to the first query and Recall is clicked. The initial results appear again.

增强的结果网格控制Enhanced results grid control

表格网格使你能够选择多个行、列和单元格。The table grid allows you to select multiple rows, columns, and cells. 通过选择多个单元格(例如 Excel)来计算聚合并透视数据。Compute aggregates by selecting multiple cells (like Excel) and pivot the data.

动画 GIF。在 Azure 数据资源管理器中打开透视模式并将列拖到透视表目标区域后,将显示汇总数据。Animated GIF. After Pivot Mode is turned on in Azure Data Explorer and columns are dragged to pivot table target areas, the summarized data appears.

Intellisense 和格式设置Intellisense & Formatting

可以使用美观的打印格式,方法是使用“Shift+Alt+F”快捷键、代码折叠(大纲)和 IntelliSense。You can use pretty-print format by using the "Shift + Alt + F" shortcut key, code folding (outlining), and IntelliSense.

显示 Azure 数据资源管理器查询的动态 GIF。展开查询后,它会更改格式,显示在一行中,列名称为粉红色。Animated GIF showing an Azure Data Explorer query. After the query is expanded, it changes format, appearing on one line, with pink column names.

深层链接Deep linking

可以只复制深层链接或深层链接和查询。You can copy just the deep link or deep link and the query. 还可以使用以下模板设置 URL 格式,使其包括群集、数据库和查询:You can also format the URL to include the cluster, database, and query by using the following template:

https://dataexplorer.azure.cn/ [clusters/ Cluster [/databases/ Database [? Options]]] https://dataexplorer.azure.cn/ [clusters/ Cluster [/databases/ Database [? Options ]]]

可以指定以下选项:The following options may be specified:

  • workspace=empty:指示创建新的空工作区(无需重新调用以前的群集、选项卡和查询)。workspace=empty: Indicates to create a new empty workspace (no recall of previous clusters, tabs, and queries will be done).

动画 GIF。此时将打开 Azure 数据资源管理器共享菜单。可以看到剪贴板项的查询链接,以及到剪贴板项的文本和链接。Animated GIF. The Azure Data Explorer Share menu opens. The Query link to clipboard item becomes visible, as does the Text and link to clipboard item.

如何提供反馈How to provide feedback

可以通过该工具提交反馈。You can submit your feedback via the tool. 显示 Azure 数据资源管理器的动态 GIF。单击“反馈”图标时,“向我们发送反馈”对话框随机打开。Animated GIF showing Azure Data Explorer. When the Feedback icon is clicked, the Send us feedback dialog box opens.