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 following parameters and click OK.
Parameter
Description
Name
Enter a database name. The name 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.
-
On the Details tab, view the database's basic information.
Field Description Name The database name. Description The description entered when the database was created. Creator The Alibaba Cloud account that created the database. Owner The current owner of the database. Creation time The date and time when the database was created. Last modification time The date and time when the database was last updated. -
On the Permissions tab, 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.