External data and managed storage data in Data Lake Compute (DLC) can be managed in the data management page, and can also be managed by executing standard SQL statements or through the API. Through the console Data Management page, you can create and edit data catalogs, as well as create, query, and delete database tables.
Creating a Data Catalog
Note:
The platform will automatically create a DataLakeCatalog for managing lake data by default.
If you have external data sources that you want to include for Land Bond analysis, you can follow the steps below to create a data catalog for external data sources.
1. Log in to the DLC console and select the service region. Ensure that the logged-in account has the permission to create catalogs. For enabling permissions of sub-accounts, see Sub-account Permission Management.
3. Enter the visual interface for creating data sources.
Fill in the connection information, complete the network configuration, and establish network connectivity between the engine and the external data source.
4. After entering the data source information, click OK to complete the creation of the data source.
5. In the data catalog list, you can view connection information, status, creator, and other details.
Editing a Data Catalog
1. In the Data Catalog List, click the Edit button on the far right of the corresponding data catalog row to modify the description, network configurations, username, password, advanced settings, and other information of the data catalog.
2. After modifications, click Confirm to create the data catalog again.
Rolling Back Data Catalog Configurations
To ensure security and operational flexibility, DLC supports rolling back the custom configurations of the data catalog. Users can quickly restore to the previous version of the data catalog by rolling back its configurations.
Creating a Database
1. Log in to the DLC Console and select the service region. Ensure that the logged-in account has the permission to create databases.
2. Enter Data Management and click the catalog name under the data catalog to view the databases within that directory.
3. Click Create database to enter the visual interface for creating a database.
4. Fill in the relevant database information and save it to create the database. During database creation, you can enable Data Governance for the entire database.
Database name: Must be globally unique, supports uppercase and lowercase English letters, digits, and underscores (_), cannot start with a digit, and can be up to 128 characters long.
Description Information: Supports both Chinese and English, up to 2048 characters.
A root account can create up to 100 databases.
Viewing a Database
1. Log in to the DLC Console and select the service region. Ensure that the logged-in account has the permission to query databases.
2. Navigate to Data Management > Database, select the data catalog, and click the Database Name to enter the database details. Here, you can manage the data tables within the database. For detailed operation guides, see Data Table Management.
Deleting a Database
1. Log in to the DLC Console and select the service region. Ensure that the logged-in account has the permission to delete databases.
2. Enter Data Management and click Delete. After a second confirmation, the database will be deleted.
