Updated on 2022-12-07 GMT+08:00

Overview

DLI database and table management provide the following functions:

Difference Between DLI Tables and OBS Tables

  • Data stored in DLI tables is applicable to delay-sensitive services, such as interactive queries.
  • Data stored in OBS tables is applicable to delay-insensitive services, such as historical data statistics and analysis.

Databases and Tables Page

The Databases and Tables page displays all created databases. You can view the database information, such as the owner and the number of tables.

Table 1 Database and table management parameters

Parameter

Description

Database Name

  • The database name can contain only digits, letters, and underscores (_), but cannot contain only digits or start with an underscore (_).
  • The database name is case insensitive and cannot be left unspecified.
  • It cannot exceed 128 characters.

Username

Database owner.

Tables

Number of tables in the database.

Description

Description of the database specified during database creation. If no description is provided, -- is displayed.

Enterprise Project

Enterprise project to which the database belongs. An enterprise project facilitates project-level management and grouping of cloud resources and users.

For details about how to set enterprise projects, see .

Operation

  • Permissions: View the permission information and perform user authorization, permission settings, and user permission revocation.
  • Tables: View the tables in the corresponding database. For details, see Table Management Page.
  • Create Table: This permission allows you to create a table in the corresponding database.
  • Drop Database: This permission allows you to delete the selected database.
  • Modify Database. This permission allows you to change the owner of the database. The username must exist under the same account.
  • Modify Enterprise Project: Add the enterprise project.

Table Management Page

From the Data Management page, click the database name or Tables in the Operation column to switch to the Table Management page.

The displayed page lists all tables created in the current database. You can view the table type, data storage location, and other information. Tables are listed in chronological order by default, with the most recently created tables displayed at the top.

Table 2 Table management parameters

Parameter

Description

Table Name

  • The table name can contain only digits, letters, and underscores (_), but cannot contain only digits or start with an underscore (_).
  • The table name is case insensitive and cannot be left unspecified.
  • The table name can contain the dollar sign ($). An example value is $test.
  • It cannot exceed 128 characters.

Table Type

Table type. Available options are as follows:

  • Managed: Indicates that data is stored in a DLI table.
  • External: Indicates that data is stored in an OBS table.
  • View: Indicates the view type. You can only create views using SQL statements.
    NOTE:

    The table or view information contained in the view cannot be modified. If the table or view information is modified, the query may fail.

Owner

User who creates the table.

Storage Location

DLI, OBS, View, CloudTable, and CSS data location

Size

Size of the data in the table. The value is displayed only for tables of the Managed type. For tables of other types, -- is displayed.

Data Source Path

  • If Data Location is OBS, the corresponding OBS path is displayed.
  • If Data Location is DLI and View, -- is displayed.
  • When the data storage location is a datasource connection service such as CloudTable and CSS, the corresponding URL is displayed.

Created

Time when the table is created.

Last Accessed

Last time when an operation was performed on the table.

Operation

  • Manage Permissions: This operation allows you to view the permission information and perform user authorization, permission settings, and user permission revocation.
  • More:
    • Delete: Delete a table from the corresponding database.
    • Modify Owner: Change the owner of a table The username must exist under the same account.
    • Import: Import data stored in an OBS bucket to a DLI or OBS table.
    • Export: Export data from a DLI table to an OBS bucket.
    • Properties: View data in Metadata and Preview tabs.