Data Lake Formation:Manage Lance tables

Create a table

1. Log on to the DLF console.

2. In the left navigation menu, select Catalogs, and click your catalog name.

3. In the Database section, click your database name.

4. Click Create Table.

5. Configure the table as shown in the following table and click OK.

   Parameter	Description
   Table Format	Select Lance Table.
   Table Name	Enter a table name. It must be unique within the database.
   Table Description	Enter a description.
   Columns	Define the columns of the table.
   User-defined Table Properties	Define custom properties as needed. During table creation, these properties overwrite default DLF table properties.

CREATE TABLE lance_table (
    a INT,
    b STRING
) OPTIONS (
    'type'='lance-table'
)

View a table

1. In the Database section, click your database name.

2. On the Tables tab, click your table name.

3. On the Table Details tab, view the table's basic information and columns.

4. On the Permissions tab, grant table permissions to DLF users or roles. For more information, see Data authorization management.

Access a table via PVFS

DLF allows you to access Lance tables via PVFS using a virtual path, such as pvfs://catalog_name/database_name/table_name/file. For more information, see PVFS.

Delete a table

1. In the Database section, click your database name.

2. On the Tables tab, click Delete in the Actions column of your target table.

3. In the dialog box, click OK to confirm deletion.