Synchronize MaxCompute data

This topic describes how to use HoloStudio to synchronize MaxCompute data to Hologres.

Background information

The Data Analytics module of HoloStudio provides the One-click MaxCompute data synchronization submodule. In this submodule, you can synchronize MaxCompute data and query the synchronized data in a visualized manner. This provides better performance than creating foreign tables for data queries.

You can also use SQL statements to synchronize MaxCompute data. For more information, see Use SQL statements to import MaxCompute to Hologres.

1. Create a data sync node.
   1. Go to the Hologres console.
   2. In the top navigation bar of the console, move the pointer over the icon and select the region where your Hologres instance resides.
   3. In the left-side navigation pane, click Instances. On the Hologres Instances page, click Go to DataWorks - HoloStudio.
   4. On the HoloStudio page, click the icon in the left-side navigation pane.
   5. On the Data Analytics page, move the pointer over the icon.
   6. Click One-click MaxCompute data synchronization.
   7. In the Create Node dialog box, set Node Name, Location, and Database.
   8. Click Commit.
2. On the editing page of the created node, set the parameters as required.

   Parameter	Description
   External table source	External table already exists: specifies to use an existing foreign table mapping the MaxCompute table. New external table: specifies to create a foreign table mapping the MaxCompute table. If no existing foreign table that maps the MaxCompute table is available, select New external table.
   External table table name	The name of the existing foreign table. This parameter is available only when you set External table source to External table already exists. The foreign table must map the MaxCompute table from which data is to be synchronized.
   Target Library	The name of the Hologres database to which the MaxCompute data is to be synchronized.
   Target schema	The name of the schema in the specified Hologres database. If you have not created a schema, select the default public schema. If you have created a custom schema, you can select the created schema.
   Destination Table Name	The name of the table to which the MaxCompute data is to be synchronized.
   Target table description	The description of the table to which the MaxCompute data is to be synchronized.
   Synchronization field	The fields to be synchronized from the specified MaxCompute table. You can select some or all fields in the MaxCompute table.
   Partition configuration	The partition fields to be synchronized. The One-click MaxCompute data synchronization submodule supports a maximum of one level of partitions. To synchronize a table that contains multiple levels of partitions, execute SQL statements in the SQL console. For more information, see SQL Console.
   Index configuration	The index to be built for the table to which the MaxCompute data is to be synchronized. For more information, see Set table properties.
   SQL Script	The SQL statements that are executed when the data sync node is run.

3. On the editing page of the created node, click the icon to save the configuration.
4. On the editing page of the created node, click the icon to synchronize data from the specified MaxCompute table.
5. On the PG management page, view the synchronized data. For more information, see Manage foreign tables or SQL Console.