The Dataphin metadata warehouse centrally manages internal business metadata and compute engine metadata. It resides in a Dataphin project within the metadata warehouse tenant (OPS tenant) and consists of periodic data integration nodes, SQL script nodes, and Shell nodes. You can initialize the metadata warehouse with SelectDB or Doris as the compute engine.
Limits
Only accounts with the metadata warehouse tenant super administrator or system administrator role can initialize the system.
Keep the account and password of the metadata warehouse tenant super administrator or system administrator secure. Additionally, when the metadata warehouse tenant super administrator account logs on to the system, operate with caution.
Procedure
-
In the top menu bar of the Dataphin homepage, choose Management Hub > System Settings.
-
In the navigation pane on the left, choose System O&M > Metadata Warehouse Settings.
-
On the Metadata Warehouse Settings configuration wizard page, click Start.
-
In the step to select the initialization engine type, select SelectDB or Doris as the engine type.
ImportantIf the metadata warehouse has already been initialized, the previously successful metadata warehouse is selected by default.
-
Click Next.
-
On the Parameter Checking page, configure the SelectDB or Doris compute engine parameters.
Parameter
Description
Version
-
SelectDB cluster: You can select Cloud Core V3.0.x (based On Apache Doris V2.1.x) or Cloud Core V4.0.x (based On Apache Doris V3.0.x).
-
Doris cluster: You can select Apache Doris v2.1.x or Apache Doris v3.0.x.
JDBC URL
The JDBC connection address of the target database. Example:
jdbc:mysql://host:port/dbname.Username, Password
The username and password of the target database. Ensure the user has the required database permissions.
FE Node URL
The HTTP endpoint of the FE node, in the format
{FE IP}:{HTTP Port}. The default HTTP port is 8030. You can specify multiple FE nodes separated by commas (,).Metadata Production Project
The logical project space for metadata production and processing. We recommend that you set this to
dataphin_meta. Do not change the name during reinitialization, otherwise the initialization will fail. -
-
Click Test Connection. After the connection test passes, click Next.
-
On the initialization page, click Start.
NoteSystem initialization takes approximately 15 minutes.
-
After the page indicates successful execution, click Complete to finish the configuration.
What to do next
After you initialize the metadata warehouse, you must configure the compute engine for the Dataphin instance. When the metadata warehouse engine is set to SelectDB or Doris, you can set the compute engine for the business tenant to any type except MaxCompute. For more information, see Compute settings.