All Products
Search

This Product

    Hologres:Create a foreign table in HoloWeb

    Document Center

    Hologres:Create a foreign table in HoloWeb

    Last Updated:Mar 26, 2026

    HoloWeb provides a graphical interface for creating, editing, renaming, deleting, and previewing foreign tables — without writing SQL. Foreign tables map MaxCompute data into Hologres schemas, enabling query acceleration directly from the Hologres console.

    Prerequisites

    Before you begin, make sure that you have:

    Create a foreign table

    Creating a foreign table involves three stages: choosing an acceleration method, configuring the source and destination parameters, and submitting the table definition.

    Choose an acceleration method

    Hologres supports three acceleration methods. Select the one that matches how much of your MaxCompute project you want to map.

    Method When to use
    Entire Project Map all tables in a MaxCompute project into a Hologres schema at once.
    Selected Tables Map a subset of tables from a MaxCompute project. Supports fuzzy search; displays up to 200 tables.
    Single Table Map one specific MaxCompute table into Hologres.

    Open the creation page

    1. Log on to the Hologres Management Console.

    2. In the navigation pane on the left of the top menu bar, select the target region.

    3. Click Go to HoloWeb.

    4. In the top navigation bar, click Metadata Management > MaxCompute Query Acceleration, then click Create Foreign Table. Alternatively, on the Metadata Management page, find the target database in the Logged On Instances list, click the database, right-click the target schema, and select Create MaxCompute External Table.

    Configure parameters

    The available parameters depend on the acceleration method you selected.

    Entire Project

    Parameter Required Description
    Acceleration Method Required Select Entire Project.
    Project Name Required The name of the MaxCompute project.
    Schema Name Optional The schema name in MaxCompute. Applicable only when schemas are enabled for the project. Configure all schema names for which you have permissions. For details, see Schema operations.
    Holo Schema Required The destination schema in Hologres. Select public or a custom schema.
    Processing Rule for Table Name Conflicts Required How to handle tables with the same name in the target schema: Ignore and continue to create other tables, Update and modify the table with the same name, or Report an error and stop creation.
    Processing Rule for Unsupported Data Types Required How to handle fields with unsupported data types: Report an error and fail the import, or Ignore and Skip Table of Unsupported Fields.

    Selected Tables

    Includes all parameters in the Entire Project table, plus:

    Parameter Required Description
    Search Optional Fuzzy search by table name. A maximum of 200 tables can be displayed.

    Single Table

    Parameter Required Description
    Acceleration Method Required Select Single Table.
    Project Name Required The name of the MaxCompute project.
    Schema Name Optional The schema name in MaxCompute. Applicable only when schemas are enabled for the project.
    Table Name (source) Required The table in the MaxCompute schema to map. Supports fuzzy search by table prefix.
    Schema (destination) Required The destination schema in Hologres. Select public or a custom schema.
    Table Name (destination) Required The name of the foreign table in Hologres.
    Destination Table Description Optional A description of the foreign table.
    When you create a foreign table from a MaxCompute table, field and column comments from the source table are synced to Hologres automatically.

    Submit and verify

    1. Click Submit.

    2. In the left navigation pane, refresh the schema to confirm the new foreign table appears under the corresponding schema.

    3. (Optional) Click Query Table on the foreign table page to open the SQL query window and run PostgreSQL queries against the table.

    Edit a foreign table

    1. In the left navigation pane, click Logged-in Instances and expand the target instance.

    2. Click the target Database to list all databases in that instance.

    3. Under the target schema, click Foreign Tables to list all foreign tables.

    4. Right-click the target foreign table and select Open Table.

    5. In the upper-right corner of the table tab, click Edit Table.

    6. Modify the Fields or Partitions of the source table mapping as needed.

      Edit a foreign table

    7. Click Submit.

    Rename a foreign table

    1. In the left navigation pane, click Logged-in Instances and navigate to the target foreign table.

    2. Under the target instance, click the target Database.

    3. Under the target schema, click Foreign Tables.

    4. Right-click the target foreign table and select Rename.

    5. Click OK.

    Delete a foreign table

    1. In the left navigation pane, click Logged-in Instances and navigate to the target foreign table.

    2. Under the target instance, click the target Database.

    3. Under the target schema, click Foreign Tables.

    4. Right-click the target foreign table and select Delete Table.

    5. Click OK.

    Preview data

    1. In the left navigation pane, on the Logged On Instances page, navigate to the target foreign table.

    2. Under the target instance, click the target Database.

    3. Under the target schema, click Foreign Tables.

    4. Double-click the target foreign table, then click Data Preview on the table tab.

    What's next

    To create and manage foreign tables using SQL instead of the HoloWeb UI, see: