This topic describes how to manage Object tables in Data Lake Formation (DLF).
Create a table
Log on to the DLF console.
In the left navigation menu, select Catalogs. Click your catalog name to open the catalog details page.
In the Database section, click your database name to enter the database.
Click Create Table.
Configure the following parameters and click OK.
Parameter
Description
Table Format
Select Object Table.
Table Name
Enter a table name. It must be unique within the database.
Table Description
Enter a description.
Create a table using SQL
If you have registered your DLF catalog in other systems like EMR Serverless Spark or Realtime Compute for Apache Flink, you can create databases and tables directly on those platforms using SQL. The metadata will be written to DLF. For more information, see Engine integration.
Flink SQL
CREATE TABLE object_table WITH ( 'type'='object-table' );Spark SQL
CREATE TABLE object_table OPTIONS ( 'type'='object-table' )
View a table
In the Database section, click your database name.
In the Tables list, click your object table name to view its columns.
On the Table Details tab, view the object table's basic information and columns.
Select the Permissions tab, click Grant Permissions to grant table permissions to users or roles. For more information, see Data authorization management.
Access a table via PVFS
Paimon provides a file system interface to access data within DLF tables. You can read data from an Object table using a virtual path like pvfs://catalog_name/database_name/table_name/file. For more information, see PVFS.
Delete a table
Deleted table data is retained for 1 day to prevent accidental deletion. Data is permanently deleted afterward.
In the Database section, click your database name.
On the Tables tab, click Delete in the Actions column of your target table.
In the dialog box, click OK to confirm deletion.