Initialize the metadata warehouse with StarRocks - Dataphin

The metadata warehouse unifies business and compute engine metadata in Dataphin. Initialize it by selecting StarRocks as the compute engine and configuring the connection parameters.

Limits

Only accounts with the metadata warehouse tenant super administrator or system administrator role can perform the initialization.

Important

Keep the credentials for the metadata warehouse tenant super administrator and system administrator roles secure. Exercise caution when you log on to the system with the metadata warehouse tenant super administrator account.

Procedure

On the Dataphin home page, choose Management Center > System Settings from the top menu bar.
In the left navigation pane, choose System O&M > Metadata Warehouse Settings. On the Metadata Warehouse Settings page, click Start.
In the Select Initialization Engine Type step, select StarRocks.

Important
If the metadata warehouse is already initialized, the previously used engine is selected by default. Switching to an incompatible engine makes the administration feature unavailable.
Click Next.

On the Parameter Settings page, configure the StarRocks engine parameters.

Parameter	Description
JDBC URL	The JDBC URL of the StarRocks cluster. Format: `jdbc:mysql://host1:port1,host2:port2`. Enter the `database` and `query parameters` in the second input box. Note The host is the FE IP address. The port is the FE query port (default: 9030).
Load URL	The data import URL. Specify the FE IP address and HTTP port. Format: `fe_ip:http_port;fe_ip:http_port`. Note Separate multiple entries with semicolons (;).
Username and Password	The username and password of the StarRocks cluster.
Meta Project	The logical project for metadata production and processing. Set to `dataphin_meta`. Do not change this value during re-initialization, or initialization fails.

Click Test Connection. After the test succeeds, click Next.
On the initialization page, click Start.

Note
Initialization takes about 15 minutes.
After a success message appears, click Finish.

What to do next

After initialization, configure the compute engine for your Dataphin instance. With StarRocks as the metadata warehouse engine, the business tenant engine supports any type except MaxCompute. For more information, see Compute Settings.