This topic describes how to use the one-click table schema synchronization feature of DataStudio to create multiple foreign tables at a time in Hologres.

Prerequisites

  • DataWorks is activated. A DataWorks workspace is created. For more information, see Create a workspace.
  • A Hologres instance is purchased and bound to a DataWorks workspace.

Background information

Hologres is integrated with MaxCompute at the underlying layer. You can create foreign tables to accelerate queries of MaxCompute data. For more information, see Create a foreign table in Hologres to accelerate queries of MaxCompute data.

DataStudio provides the One-click MaxCompute table structure synchronization feature. You can use this feature to create multiple foreign tables at a time in Hologres in a visualized manner.

Procedure

  1. Create a One-click MaxCompute table structure synchronization node.
    1. Log on to the DataWorks console.
    2. In the left-side navigation pane, click Workspaces.
    3. In the top navigation bar, select the region in which the workspace resides. Find the workspace and click Data Analytics.
    4. In the left-side navigation pane of the DataStudio page, click the DataStudio icon.
    5. On the DataStudio page, move the pointer over the Create icon icon in the top toolbar and choose Hologres > One-click MaxCompute table structure synchronization.
    6. In the Create Node dialog box, set the Node Name and Location parameters and click Commit.
  2. On the node configuration tab, set the parameters as required.
    Set parameters
    Parameter Description
    Target connection The name of your Hologres instance.
    Target Library The name of the database in the Hologres instance.
    Schema The name of the schema to which the Hologres tables belong. The default value is public. If you have created a schema, you can select the created schema.
    Type The type of foreign tables. You can create only foreign tables sourced from MaxCompute.
    Server List The name of the server to be used. After a Hologres instance is created, a server named odps_server is automatically created and can be used. For more information, see postgres_fdw.
    Source Project The name of the MaxCompute project for which you want to create foreign tables.
    Select tables The tables for which you want to create foreign tables. You can select Entire Project or Selected Tables based on your requirements.
    Processing Rule for Table Name Conflicts The rule to process the duplication of table names. Valid values:
    • Ignore, continue to create the rest tables
    • Update, modify the same name tables
    • Alert, do not duplicately create
    Unsupported data type The rule to process unsupported data types. Valid values:
    • Alert, import failure
    • Ignore, skip unsupported columns
  3. On the node configuration tab, click the Save icon icon to save the configurations.
  4. On the node configuration tab, click the Run icon icon to run the node to create multiple foreign tables at a time.
  5. View the created foreign tables.
    1. In the left-side navigation pane, click the PostgreSQL management icon to go to the PostgreSQL management page.
    2. Double-click the foreign table that you want to view to go to the editing page of the table.