System Functions

This section provides reference information for the system-related functions in PlaidCloud Lakehouse.


CLUSTERING_INFORMATION

Learn how to use the CLUSTERING_INFORMATION system function in PlaidCloud Lakehouse. Returns clustering information of a table. Includes syntax and examples.

FUSE_BLOCK

Learn how to use the FUSE_BLOCK system function in PlaidCloud Lakehouse. Returns the block information of the latest or specified snapshot of a table.

FUSE_COLUMN

Learn how to use the FUSE_COLUMN system function in PlaidCloud Lakehouse. Returns the column information of the latest or specified snapshot of a table.

FUSE_ENCODING

Learn how to use the FUSE_ENCODING system function in PlaidCloud Lakehouse. Returns the encoding types applied to a specific column within a table.

FUSE_SEGMENT

Learn how to use the FUSE_SEGMENT system function in PlaidCloud Lakehouse. Returns the segment information of a specified table snapshot. Includes syntax...

FUSE_SNAPSHOT

Learn how to use the FUSE_SNAPSHOT system function in PlaidCloud Lakehouse. Returns the snapshot information of a table. Includes syntax and examples.

FUSE_STATISTIC

Learn how to use the FUSE_STATISTIC system function in PlaidCloud Lakehouse. Returns the estimated number of distinct values of each column in a table.

FUSE_TIME_TRAVEL_SIZE

Learn how to use the FUSE_TIME_TRAVEL_SIZE system function in PlaidCloud Lakehouse. Calculates the storage size of historical data (for Time Travel) for tables.