The storage overview is generated by a batch job (T+1). It collects physical storage data for all objects, including the full data of all versions. This overview helps you understand your storage resource usage and identify areas for optimization. This topic describes how to view the storage overview for data catalogs, databases, and data tables.
Notes about storage usage
Storage size shown in the partition list:
This size includes only the valid data files referenced by the partition in the latest snapshot. These are active files that are currently queryable and have not been purged.
Storage size shown in the storage overview:
Data from unexpired historical snapshots
Orphan files
File fragments from OSS multipart uploads
Therefore, the total size in the storage overview is usually greater than or equal to the sum of the sizes of all partitions in the partition list. The difference reflects the storage overhead from inactive data that has not been purged, such as historical versions and residual files.
Catalog
Log on to the DLF console.
In the left navigation menu, click Catalogs, and click the name of your catalog.
Select the Storage Overview tab to view the storage data for the current catalog. The data includes:
Database
In the left navigation menu, click Catalogs, and click the name of your catalog.
In the Databases section, click your database name.
Select the Storage Overview tab to view the storage usage for the current database.
Table
In the left navigation menu, click Catalogs, and click the name of your catalog.
In the Databases section, click your database name.
Click a table name.
Select the Storage Overview tab to view the physical storage data for the current table.