This topic describes the basic database operations in Data Lake Formation (DLF).
When a DLF catalog is registered in platforms like EMR Serverless Spark or Realtime Compute for Apache Flink, you can create databases and tables via SQL. Metadata is written directly to DLF. For more information, see Engine integration.
Create a database
Log on to the DLF console.
In the left navigation menu, select Catalogs, and click your catalog name.
Click Create Database.
On the Create Database page, configure the database and click OK.
Configuration item
Description
Name
Enter a database name. It must be unique within the catalog.
Description
Enter a description.
Each catalog includes a default database that cannot be deleted.
View a database
In the Database section, click your database name.
Select the Details tab to view the basic information about the database.
This information includes the database name, description, creator, owner, creation time, and last modification time.
Select the Permissions tab to grant database permissions to DLF users or roles. For more information, see Data authorization management.
Modify a database description
In the Database section, click Modify in the Actions column of your database.
On the Edit Database page, modify the description and click Update.
Delete a database
Deleted database data is retained for one day to prevent accidental loss, after which it is permanently deleted.
In the Database section, click Delete in the Actions column of the target database.
In the dialog box, click OK to confirm the deletion.