Managing Databases

Prerequisites

• A LakeFormation instance has been created and is running properly.
• A catalog has been created.
• You have created an OBS parallel file system for storing databases by referring to Creating a Metadata Storage Path.

Managing Databases

1. Log in to the LakeFormation console.
2. In the upper left corner, click and choose Analytics > LakeFormation to access the LakeFormation console.
3. Select the LakeFormation instance to be operated from the drop-down list on the left and choose Metadata > Database in the navigation pane.
4. Select the name of the desired catalog from the Catalog drop-down list box in the upper right corner. You can view the databases contained in this catalog.
5. Click Create.

   

   1. In the Basic Information area, set the related parameters.

      Table 1 Parameters for creating a database

      Parameter	Description
      Database Name	Enter a database name. The value should contain 1 to 128 characters. Only letters, numbers, and underscores (_) are allowed.
      Catalog	Select the name of the catalog to which the database to be created belongs.
      Select Location	Select a location where the database information is stored in the OBS parallel file system. Click , select a location, and click OK. The selected location must start with obs:// and must contain one storage object. For example, select obs://lakeformation-test/catalog1/database1. If no suitable parallel file system is available, click go to OBS and create one. The path must be different from the storage path of its catalog (the one specified by Select Location on the catalog creation page). If a database storage path is added for the catalog to which the database belongs, set this parameter to the subpath of the database storage path or that of the path specified by Select Location during catalog creation.
      Description	Description of the created database. The content length must be between 0 and 4000 bytes (3 bytes per Chinese character).

   2. (Optional) Click Add under Data Table Storage Locations. On the Add Table Storage Location page, click to manually select a table storage path as required. Multiple paths can be added.
      

      • Selecting data table storage path is an optional operation.
      • The data table storage path can be set to the catalog path and its subpaths, or database storage location path and its subpaths.
      • If a data table storage path is added, the tables in this database must be the subpath of the data table storage path or that of the selected database location path.
   3. (Optional) Click Add under Function Storage Locations. On the Add Function Storage Location page, click to manually select a function storage path as required. Multiple paths can be added.
      

      • Selecting function storage path is an optional operation.
      • The function storage path can be set to the catalog path and its subpaths, or database storage location path and its subpaths.
      • If a function storage path is added, the functions in this database must be the subpath of the function storage path or that of the selected database location path.
   4. Click Submit.

6. After the database is created, you can view the database name/ID, catalog, owner, and storage location on the Database page.

   Click Modify in the Operation column to modify the configurations of a database.

   Click Table in the Operation column to view the tables in a database.

   Click More to authorize or delete a database or view its permissions.

7. If you need to delete a database, choose More > Delete, confirm the operation impact, determine whether to delete other data as prompted, and click OK.
   • Delete tables in the database: If the current database contains undeleted data tables or functions, you must select this option. Otherwise, an error will occur. Deleted data cannot be restored. Exercise caution when performing this operation.
   • (Optional) Delete data stored in OBS: The deleted data is stored in the recycle bin and can be restored before it expires.
   

   If files are also deleted when metadata is deleted, the metadata is moved to the recycle bin (OBS path lake-formation-trash-dir/table_id) of the corresponding OBS bucket.