External data and managed storage data in DLC can be managed through the Data Management Page by executing standard SQL statements and APIs. Through the Console Data Management Page, you can create, edit data catalogs, and create, query, delete databases and tables.
Creating a data catalog
Note:
The platform will automatically create a DataLakeCatalog for you for data management on the lake.
When you have external data sources and wish to perform federated analysis, you can follow the process below to create a data catalog for external data sources.
1. Log in to DLC console, select the service region. The account used to log in must have the permission to create a catalog. For enabling sub-account permissions, refer to Sub-account Permission Management.
3. Enter the data source creation visual interface. After filling in the connection information, complete the network configuration to connect the engine with the external data source.
4. After filling in the data source information, click Confirm to complete the creation of the data source.
5. In the Data Catalog List, view connection information, status, creator, and other information.
Edit Data Catalog
1. Click Data Catalog List > Operations > Edit to modify the Data Catalog's description information, network configuration information, username, password, and running cluster, etc.
2. After modifications, click Create to reconstruct the Data Catalog.
New database
1. Log in to DLC Console, select the service region. The account used to log in must have database creation permissions.
2. Enter Data Management, click on the directory name under the Data Catalog to view the databases within that directory.
3. Click Create Data Catalog to enter the Database Creation Visual Interface.
4. After filling in the relevant database information and saving, the database creation is complete. When creating a database, you can enable data optimization for the entire database.
Database Name: Globally unique, supports English case-sensitive letters, numbers, "_", cannot start with a number, up to 128 characters.
Description: Supports both Chinese and English, up to 2,048 characters.
A root account can create up to 100 databases.
View Database
1. Log in to DLC Console, select the service region. The account used to log in must have database query permissions.
2. Enter Data Management > Database, select the data directory, click Database Name to access the database details, manage the database's tables. For a detailed operation guide, refer to Data Table Management.
Dropping a Database
1. Log in to DLC Console, select the service region. The account used to log in must have database deletion permissions.
2. Enter Data Management, click Delete. After confirming a second time, the database can be deleted.
Yes
No
Was this page helpful?