DataWorks provides HoloStudio for you to connect to Hologres to perform interactive analytics. This topic describes how to bind a Hologres instance to an existing DataWorks workspace to query data from MaxCompute foreign tables in HoloStudio.

Prerequisites

  • An Alibaba Cloud account is registered.
  • Real-name verification is completed.
  • MaxCompute is activated. For more information, see Activate MaxCompute.
  • DataWorks is activated and a DataWorks workspace is created. For more information, see Create a workspace.

Purchase a Hologres instance

Note If you have purchased a Hologres instance, skip this step and directly bind the Hologres instance to an existing workspace in DataWorks.
  1. Go to the Alibaba Cloud official website, click Log In in the upper-right corner, and then enter your account name and password.
  2. Move the pointer over Products in the top navigation bar and choose Analytics > Data Computing > Hologres (Interactive Analytics) to go to the product landing page of Hologres.
  3. Click Buy Now.
  4. On the buy page of Hologres, click the Subscription tab. On the Subscription tab, select a region and a computing resource specification, enter an instance name, and then click Buy Now.

Create a database in the Hologres console

After you purchase a Hologres instance, a database named postgres is created by default.

This database is allocated with a few resources and only used for management purposes. You can create a database based on your business requirements.

  1. Log on to the Hologres console and click Instances in the left-side navigation pane. On the Hologres Instances page, click the name of the target Hologres instance to go to the details page.
  2. Click Databases. On the page that appears, click Create Database. In the Create Database dialog box, set Database Name, select Enable or Disable for SPM, and then click OK.

Bind a Hologres instance to a DataWorks workspace

  1. Log on to the DataWorks console by using your Alibaba Cloud account.
  2. On the Workspaces page, click the name of the target workspace. On the page that appears, click DataStudio to enter DataStudio.
    Notice To bind a Hologres instance to a DataWorks workspace, make sure that they reside in the same region.
  3. Click Workspace Manage in the upper-right corner to go to the configuration page of the workspace.
  4. In the Computing Engine information section, click Hologres.
  5. On the Hologres tab, click Binding HologresDB. In the Binding HologresDB dialog box, set parameters as described in the following table.
    Parameter Description
    Instance display name The display name of the computing engine instance.
    Access identity Specifies whether to use an Alibaba Cloud account or an authorized Resource Access Management (RAM) user to access the Hologres instance.
    Hologres instance name The Hologres instance to be bound to the DataWorks workspace. Select a purchased instance from the drop-down list.
    Note Make sure that the Hologres instance resides in the same region as the current DataWorks workspace.
    Database name The name of the database to be bound to the workspace.
    Test connectivity Check whether the database can be bound to the workspace.
  6. Click Confirm to bind the selected Hologres instance to the current DataWorks workspace.
  7. In DataStudio, click data in the upper-left corner and choose All Products > HoloStudio to go to HoloStudio.
  8. In HoloStudio, Click the PG Management icon in the left-side navigation pane. On the page that appears, click the Refresh icon to display the Hologres database bound to the workspace.
  9. Use the Hologres database to query data from MaxCompute foreign tables in HoloStudio. For more information, see Create a foreign table to accelerate queries of MaxCompute data.