All Products
Search
Document Center

Data Management:DLTable

Last Updated:Nov 07, 2025
ParameterTypeDescriptionExample
object

The information about the table.

ViewOriginalTextstring

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

""
Ownerstring

The name of the table owner.

zhangsan
TableTypestring

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

EXTERNAL_TABLE
Parametersobject

The key-value pair.

{ "EXTERNAL": "TRUE", "delta.minReaderVersion": "1"}
Descriptionstring

The description of the application table.

1410769
CreatorIdlong

The ID of the user who created the table.

88653
CreateTimeinteger

The time when the data table was created.

1731586286
StorageDescriptorDLStorageDescriptor

The description of data storage, including the storage characteristics and format of the table.

LastAccessTimeinteger

The time when the table was last accessed.

1608707407
Retentioninteger

The retention period of the table.

300
Namestring

The name of the table.

100g_customer
OwnerTypestring

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

USER
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.

default
CatalogNamestring

The name of the catalog to which the table belongs.

hive
PartitionKeysarray

The column attributes of the table.

PartitionKeyDLColumn

Column

ModifierIdlong

The ID of the user who last modified the table.

1410769
Locationstring

The storage path of the table.

oss://xxx