Hologres:Hologres AI Assistant

Supported regions

AI Assistant is currently available in the following regions: China (Hangzhou), China (Beijing), China (Shanghai), China (Shenzhen), China (Zhangjiakou), China (Ulanqab), China (Chengdu), China (Hong Kong), Singapore, Malaysia (Kuala Lumpur), Indonesia (Jakarta), and Japan (Tokyo).

Feature list

AI Assistant currently supports the following features:

Step 1: Purchase model resources

To purchase Hologres AI Assistant, perform the following steps:

1. Log on to the Hologres console. In the left-side navigation pane, click AI Assistant and AI Node.

2. Click the AI Assistant tab. If AI Assistant has not been purchased in the current region, the page displays the following message: "Hologres AI Assistant has not yet been purchased in the current region."

3. Click Buy Now. The AI Assistant purchase page opens in a new browser tab.

   Note

   AI Assistant is a region-level service. Make sure that you select the region that matches your Hologres instances. After the purchase, AI Assistant becomes available to all Hologres instances in that region.

4. On the purchase page, select a subscription duration and complete the payment.

5. If this is your first time activating AI Assistant, follow the on-screen prompts to activate DataWorks and authorize the AliyunServiceRoleForDataWorks service-linked role. No additional charges apply.

6. After the purchase is complete, return to the Hologres console and refresh the page. The AI Assistant tab displays your AI Assistant instance information.

If your AI Assistant subscription has expired and the instance status is Stopped, click Renew to go to the renewal page and extend your subscription.

Step 2: View the AI Assistant instance

After the purchase is complete, log on to the Hologres console. In the left-side navigation pane, click AI Assistant and AI Node, and then click the AI Assistant tab to verify that AI Assistant is activated.

AI Assistant is a region-level service. After you purchase AI Assistant in a specific region, you need to manually associate the Hologres instances that require AI Assistant diagnostic capabilities in the Associated Instances area. For more information, see Associate instances.

Permission requirement: the AliyunHologresFullAccess policy is required to manage AI Assistant instance association.

The AI Assistant tab displays different content depending on the purchase status:

• Not purchased: The page displays a message indicating that Hologres AI Assistant has not been purchased in the current region. Click Buy Now to go to the purchase page. If AI Assistant has been suspended, click Renew to go to the renewal page.

• Purchased: The page displays the following information about your AI Assistant instance:

  Field	Description
  AI Assistant ID	The unique identifier of the AI Assistant instance.
  AI Assistant Status	The current running status: Normal or Stopped. Click Release next to the status to unsubscribe and release the AI Assistant instance.
  Days Remaining	The number of days until the subscription expires. Click Renew to go to the renewal page and extend the subscription period.
  Auto-Renewal	Whether auto-renewal is enabled. Click Enable Auto-Renewal or Disable Auto-renewal to toggle this setting. The link redirects you to the renewal management page.
  Region	The region where AI Assistant is deployed. This must match the region of your Hologres instances.
  Start Time	The time when the AI Assistant instance was activated.
  End Time	The time when the current subscription expires.

Monitor token usage

Below the basic information section, the Usage Consumption area displays your AI Assistant token usage statistics. The Last Calculation Time is shown in the upper-right corner along with a refresh button.

You can switch between two views:

• Summary: Displays three cards showing token consumption over different time ranges:

  Card	Description
  Yesterday's Usage	The total number of tokens consumed on the previous day.
  Weekly Usage	The total number of tokens consumed in the last 7 days.
  Last Month's Usage	The total number of tokens consumed in the last 30 days.

• Details: Displays a table of individual request records. You can filter records by selecting Request ID or User ID from the drop-down list and entering a search value. The table contains the following columns:

  Column	Sortable
  Request ID	No
  User ID	No
  Start Time	Yes
  End Time	Yes
  Input Token	Yes
  Output Token	Yes
  Total Tokens	Yes

  The table supports pagination with 10, 20, or 50 records per page.

Associate instances

After purchasing AI Assistant, you need to associate Hologres instances with the AI Assistant to enable diagnostic capabilities for those instances.

Permission requirement: the AliyunHologresFullAccess policy is required to manage instance association.

To associate an instance, perform the following steps:

1. Log on to the Hologres console. In the left-side navigation pane, click AI Assistant and AI Node, and then click the AI Assistant tab.

2. In the Associated Instances area, click + Add Instance.

3. In the Associate Instance dialog box, select the Hologres instance that you want to associate from the Select Instance drop-down list. The drop-down list shows all available instances in the current region.

4. Click Confirm to complete the association.

After the association is complete, the instance appears in the Associated Instances table, which displays the Instance ID, Instance Name, Region, and Instance Status. You can click Disassociate in the Actions column to remove the association.

Step 3: Use AI Assistant

You can open the AI Assistant chat panel from any page in the Hologres console by using either of the following methods:

• Click the Hologres AI Assistant link in the upper part of the page.

• Click the floating icon button in the lower-right corner of the page.

The chat panel opens as a side panel on the right side of the page. You can drag the panel edge to adjust its width, or switch to fullscreen mode for a larger workspace. When you open AI Assistant for the first time, it displays five feature module cards. Click a module card to get started:

In addition to using the feature modules, you can also type questions directly in the input box for free-form conversations with AI Assistant. You can also use AI Assistant through HoloWeb.

Each feature has its own permission requirements. For more information, see AI Assistant permissions. You must grant the required permissions in RAM before you can use diagnostic features. Otherwise, the diagnostic request fails.

Diagnostic reports

When a diagnostic report is generated on demand, the system shows the full report along with the report history in the Diagnostic Reports panel. Each user can view only the reports they have generated.

Execution history

On the AI Assistant chat page, click the Search History button in the upper-right corner to view the corresponding conversation history, which is retained for 7 days by default. Each user can view only their own execution history.

Permission for associating an instance

The AliyunHologresFullAccess policy is required to perform Associate Instance.

Permissions for diagnostic capabilities

CPU diagnostics, memory diagnostics, and slow SQL diagnostics rely on monitoring data, the instance's slow SQL log, and metadata tables such as Table Info. The following permissions are required:

• HoloRAM permission: AliyunHologresReadOnlyAccess or AliyunHologresFullAccess. The following is a minimal-permission example:

  {
    "Version": "1",
    "Statement": [
      {
        "Effect": "Allow",
        "Action": [
          "hologram:GetInstance",
          "hologram:GetExecuteStatementEnabled",
          "hologram:EnableExecuteStatement",
          "hologram:ListDatabases",
          "hologram:ListWarehouses",
          "hologram:ExecuteStatement"
        ],
        "Resource": "*"
      },
      {
        "Effect": "Allow",
        "Action": [
          "cms:DescribeMetricList"
        ],
        "Resource": "*"
      }
    ]
  }

• Hologres instance permission: AI Assistant supports only Alibaba Cloud account and RAM user authentication for instance access; Basic accounts are not supported. The account must have connection permission and slow SQL log access, where Prerequisites or Superuser privileges are sufficient to view all slow SQL and Table Info records in the instance.

• CloudMonitor RAM permission: AliyunCloudMonitorFullAccess (full access to CloudMonitor) or AliyunCloudMonitorReadOnlyAccess (read-only access to CloudMonitor).

If any of the above permissions is missing, the corresponding feature is unavailable.

Chat history

Each user can view only their own chat history and cannot see the history of other accounts.

Operations reports

Each user can view only the operations reports they have generated and cannot see those of other accounts.