仪表板任务Dashboard tasks

重要

此功能目前以公共预览版提供。This feature is in Public Preview. 请联系 Azure Databricks 代表,以申请访问权限。Contact your Azure Databricks representative to request access.

创建仪表板Create a dashboard

  1. 执行下列操作之一:Do one of the following:

    • 单击侧栏中的 创建图标 图标并选择“仪表板”。Click the Create Icon icon in the sidebar and select Dashboard.
    • 单击侧栏中的 仪表板图标 图标并单击“+ 新建仪表板”按钮。Click the Dashboards Icon icon in the sidebar and click the + New Dashboard button.
  2. 输入仪表板的名称。Enter a name for the dashboard.

  3. 将内容添加到仪表板:Add content to the dashboard:

    • 单击“添加文本框”以添加注释。Click Add Textbox to add commentary.

      输入文字。Enter text. 可使用 Markdown 为文本框制定样式。You can style the text boxes using Markdown. 若要在仪表板的文本框中包含静态图像,请使用 Markdown 图像语法:![alt-text](<image-url>)To include static images within text boxes on your dashboards, use Markdown image syntax:![alt-text](<image-url>).

    • 单击“添加小组件”,添加查询可视化效果。Click Add Widget to add a query visualization.

      1. 选择查询。Select a query. 搜索现有查询或从预先填充的列表中选取最近的查询。Search existing queries or pick a recent one from the pre-populated list.

      2. 在“选择可视化效果”下拉列表中,选择可视化效果类型。In the Choose Visualization drop-down, select the visualization type.

        添加到仪表板Add to dashboard

  4. 单击“添加到仪表板”。Click Add to Dashboard.

    将小组件添加到仪表板Add widget to dashboard

  5. 拖放仪表板上的内容块。Drag and drop content blocks on the dashboard.

  6. 单击“完成编辑”。Click Done Editing.

    完成仪表板Complete dashboard

删除仪表板中的内容Remove content from a dashboard

  1. 单击小组件右上方的垂直省略号 垂直省略号,然后选择“从仪表板中删除”。Click the vertical ellipsis Vertical Ellipsis at the top-right of the widget and select Remove from Dashboard.
  2. 单击 “删除”Click Delete.

编辑仪表板Edit a dashboard

若要打开仪表板进行编辑,请打开仪表板右上方的垂直省略号 垂直省略号,然后选择“编辑”。To open the dashboard for editing, open the vertical ellipsis Vertical Ellipsis at the top-right of the dashboard and select Edit.

编辑仪表板Edit dashboard

编辑时,可添加和删除内容并应用筛选器。While editing you can add and remove content and apply filters.

将内容添加到仪表板Add content to a dashboard

  1. 打开仪表板进行编辑Open the dashboard for editing.
  2. 单击“添加文本框”或“添加小组件” 。Click Add Textbox or Add Widget.
  3. 单击“添加到仪表板”。Click Add to Dashboard.
  4. 单击“完成编辑”。Click Done Editing.

还可将可视化效果添加到查询编辑器中的仪表板You can also add a visualization to a dashboard in the query editor.

删除仪表板中的内容Remove content from a dashboard

  1. 单击 SQL 删除图标 或将鼠标悬停在对象上,单击小组件右上方的垂直省略号 垂直省略号,然后选择“从仪表板中删除”。Click the SQL Delete Icon or hover over the object, click the vertical ellipsis Vertical Ellipsis at the top-right of the widget and select Remove from Dashboard.
  2. 单击 “删除”Click Delete.

仪表板筛选器Dashboard filters

当查询具有筛选器时,还必须在仪表板级别应用筛选器。When queries have filters you must also apply filters at the dashboard level. 选择“使用仪表板级别筛选器”复选框以将筛选器应用到所有查询。Select the Use Dashboard Level Filters checkbox to apply the filter to all queries.

刷新仪表板Refresh a dashboard

由于仪表板从缓存中提取数据,而只要运行查询,就会更新缓存,因此仪表板的加载速度会很快。Dashboards should load quickly because they fetch their data from a cache that renews whenever a query runs. 但是,如果你最近没有运行查询,则仪表板可能已过时。But if you haven’t run the queries recently, your dashboard might be stale. 如果最近运行了某些查询而未运行其他查询,仪表板甚至可以将旧数据与新数据混合在一起。It could even mix old data with new if some queries ran more recently than others.

手动刷新仪表板Manually refresh a dashboard

若要强制刷新,请单击仪表板右上方的“刷新”按钮。To force a refresh, click the Refresh button on the top right of the dashboard. 此操作将运行所有仪表板查询并更新其可视化效果。This runs all the dashboard queries and updates its visualizations.

自动刷新仪表板 Automatically refresh a dashboard

若要自动刷新仪表板,请执行以下操作:To automatically refresh a dashboard:

  1. 单击仪表板右上方的“计划”按钮。Click the Schedule button at the top right of the dashboard.
  2. 在“刷新间隔”下拉列表中,选择一个时段。In the Refresh Every drop-down, select a period.
  3. 在“SQL 终结点”下拉列表中,(可选)选择要用于所有查询的 SQL 终结点。In the SQL Endpoint drop-down, optionally select a SQL endpoint to use for all the queries. 如果没有选择终结点,则查询将在上次使用的 SQL 终结点上执行。If you don’t select an endpoint, the queries execute on the last used SQL endpoint.

将仪表板移至回收站Move a dashboard to Trash

若要将仪表板移至回收站,请单击仪表板右上方的垂直省略号 垂直省略号,然后选择“移至回收站”。To move a dashboard to Trash, click the vertical ellipsis Vertical Ellipsis at the top-right of the dashboard and select Move to Trash. 单击“移至回收站”进行确认。Confirm by clicking Move to Trash.

从回收站还原仪表板Restore a dashboard from Trash

  1. 在“所有仪表板”列表中,单击In the All Dashboards list, click 回收站按钮..
  2. 单击仪表板。Click a dashboard.
  3. 单击仪表板右上方的垂直省略号 垂直省略号,然后选择“还原”。Click the vertical ellipsis Vertical Ellipsis at the top-right of the dashboard and select Restore.

永久删除仪表板Permanently delete a dashboard

  1. 在“所有仪表板”列表中,单击In the All Dashboards list, click 回收站按钮..
  2. 单击仪表板。Click a dashboard.
  3. 单击仪表板右上方的垂直省略号 垂直省略号,然后选择“删除”。Click the vertical ellipsis Vertical Ellipsis at the top-right of the dashboard and select Delete.

打开查询Open a query

若要打开查询编辑器的小组件中显示的查询,请单击小组件右上方的垂直省略号 垂直省略号,然后选择“查看查询”。To open the query displayed in a widget in the query editor, click the vertical ellipsis Vertical Ellipsis at the top-right of the widget and select View Query.

配置仪表板权限Configure dashboard permissions

若要配置可以管理和运行仪表板的人员,请参阅仪表板访问控制To configure who can manage and run dashboards, see Dashboard access control.