儀表板工作Dashboard tasks

重要

這項功能處於公開預覽狀態This feature is in Public Preview. 請連絡 Azure Databricks 代表以要求存取權。Contact your Azure Databricks representative to request access.

建立儀表板Create a dashboard

  1. 按一下Click the 儀表板圖示 圖示 (位於提要欄位中)。icon in the sidebar.

  2. 按一下 [ + 新增儀表板]。Click + New Dashboard.

  3. 輸入儀表板的名稱。Enter a name for the dashboard.

  4. 將內容新增至儀表板:Add content to the dashboard:

    • 按一下 [ 新增 Textbox ] 以新增評論。Click Add Textbox to add commentary.
      1. 輸入文字。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>).
    • 按一下 [ 新增 Widget ] 以新增查詢視覺效果。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

  5. 按一下 [ 新增至儀表板]。Click Add to Dashboard.

    將小工具新增至儀表板Add widget to dashboard

  6. 拖放儀表板上的內容區塊。Drag and drop content blocks on the dashboard.

  7. 按一下 [完成編輯]。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. 按一下 [ 新增 Textbox ] 或 [ 加入 Widget]。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 Delete] 圖示或將滑鼠停留在 物件上方,按一下  小工具右上角的垂直省略號垂直省略號, 然後選取 [ 從儀表板移除]。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 periodically refresh a dashboard, select the Refresh drop-down and select a period:

重新整理期間Refresh period

注意

只要已登入的使用者在其瀏覽器中開啟儀表板,您的重新整理排程才會生效。Your refresh schedule is only in effect as long as a logged-in user has the dashboard open in their browser. 為了保證您的查詢會定期執行 (這對警示) 來說很重要,您應該改為使用 排程的查詢To guarantee that your queries are executed regularly (which is important for alerts), you should use a scheduled query instead.

發佈儀表板Publish a dashboard

若要共用儀表板,請按一下儀表板編輯器右上方的 [ 發行 ] 按鈕。To share a dashboard, click the Publish button on the upper right of the dashboard editor. 具有適當許可權的任何組織登入成員都可以在發佈之後看到您的儀表板。Any logged-in member of your organization with adequate permission can see your dashboard once it has been published.

解除發佈儀表板Unpublish a dashboard

若要取消共用儀表板,請按一下  查詢編輯器右上方的垂直省略號垂直省略號, 然後選取 [ 取消 發行]。To unshare a dashboard, click the vertical ellipsis Vertical Ellipsis at the top-right of the query editor and select Unpublish.

解除發佈儀表板Unpublish dashboard

封存儀表板Archive a dashboard

您無法在 SQL 分析中刪除儀表板,但可以將它們封存。You can’t delete dashboards in SQL Analytics but you can archive them. 若要封存儀表板,請按一下  查詢編輯器右上方的垂直省略號垂直省略號, 然後選取 [ 封存]。To archive a dashboard, click the vertical ellipsis Vertical Ellipsis at the top-right of the query editor and select Archive.

解除發佈儀表板Unpublish dashboard

開啟查詢Open a query

若要在 [查詢編輯器] 中開啟小工具中顯示的查詢,請按一下  小工具右上角的垂直省略號垂直省略號, 然後選取 [ View 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.