Use the data catalog feature in DataWorks to synchronize data from a single Hologres internal table to MaxCompute to help you efficiently store big data. After data synchronization, you can fully utilize the high-performance processing capabilities of MaxCompute.
Limits
Before you start, confirm that your scenario is supported:
| Limit | Details |
|---|---|
| Source database type | Only internal Hologres databases are supported. External Hologres databases cannot be synchronized. |
| Data type compatibility | MaxCompute and Hologres support different data types. Hologres data of specific types cannot be synchronized to MaxCompute. Check Data type mappings between MaxCompute and Hologres to confirm your columns are compatible before you proceed. |
| Hologres external tables in MaxCompute | If you use Hologres external tables in MaxCompute after synchronization, additional limits apply. See Hologres external tables. |
Prerequisites
Before you begin, ensure that you have:
A MaxCompute project. See Create a MaxCompute project.
A Hologres instance. See Purchase a Hologres instance.
Both the MaxCompute project and Hologres instance associated with your workspace as computing resources, and the computing resources have passed the network connectivity test. See Associate a computing resource with a workspace (Participate in Public Preview of Data Studio turned on).
Synchronize a Hologres table to MaxCompute
To create and configure a synchronization node, follow these steps:
Go to the Workspaces page in the DataWorks console. In the top navigation bar, select a desired region. Find the workspace and choose Shortcuts > Data Studio in the Actions column.
In the left-side navigation pane of the Data Studio page, click the
icon to go to the DATA CATALOG pane.In the Hologres directory, find the internal table you want to synchronize in the Table folder. Right-click the table name and select Data Synchronization to MaxCompute.
In the popover, select the path where you want to create the node and click OK.
In the next popover, enter a name for the node and press Enter to open the configuration tab.
On the configuration tab, configure the synchronization parameters. For parameter descriptions, see Node for synchronizing data to MaxCompute.
The system automatically fills in all parameters in the Settings for Source Table (Hologres) section based on the table you selected. No manual configuration is needed for that section.