All Products
Search
Document Center

Data Management:DLTablebaseInfo

Last Updated:Nov 07, 2025
ParameterTypeDescriptionExample
object

The basic information about the table.

Ownerstring

The owner of the table.

test
ViewOriginalTextstring

The original text of the view if the table type is view.

""
TableTypestring

The type of the table. Valid values: MANAGED_TABLE, EXTERNAL_TABLE, VIRTUAL_VIEW, INDEX_TABLE, and MATERIALIZED_VIEW.

EXTERNAL_TABLE
Parametersobject

Additional parameters for the table.

"EXTERNAL": "TRUE"
Descriptionstring

The comment of the table.

"table"
CreatorIdlong

The ID of the user who created the table.

141****
CreateTimeinteger

The time when the table was created.

1731586286
LastAccessTimeinteger

The time when the table was last accessed.

1608707407
Retentioninteger

The retention period of the table. Unit: days.

30000
Namestring

The name of the table.

100g_customer
OwnerTypestring

The type of the table owner. Valid values: USER, ROLE, and GROUP.

ROLE
ViewExpandedTextstring

The expanded text of the view if the table type is view.

""
DbIdlong

The ID of the database in which the table is stored.

19
DbNamestring

The name of the database in which the table is stored.

100g_customer
CatalogNamestring

The catalog to which the table belongs.

hive
PartitionKeysarray

The column attributes of the table.

ColumnDLColumn

The attributes of the column.

ModifierIdlong

The time when the table was modified.

1410769
Locationstring

The storage path of the table.

oss://xxx