Meta Functions

This section provides reference information for the meta functions in PlaidCloud Lakehouse.


GET_QUERY_DUMP

Learn how to use the GET_QUERY_DUMP meta function in PlaidCloud Lakehouse. Returns a query dump for diagnostic purposes - see syntax, examples, and output.

INSPECT_ALL_PIPES

Learn how to use the INSPECT_ALL_PIPES meta function in PlaidCloud Lakehouse. Returns information about all pipe objects - see syntax, examples, and output.

INSPECT_HIVE_PART_INFO

Learn how to use the INSPECT_HIVE_PART_INFO meta function in PlaidCloud Lakehouse. Returns Hive partition information for an external table.

INSPECT_MEMORY

Learn how to use the INSPECT_MEMORY meta function in PlaidCloud Lakehouse. Returns memory usage information for the current node - with syntax and examples.

INSPECT_MEMORY_DETAIL

Learn how to use the INSPECT_MEMORY_DETAIL meta function in PlaidCloud Lakehouse. Returns detailed memory usage information - with syntax and examples.

INSPECT_MV_META

Learn how to use the INSPECT_MV_META meta function in PlaidCloud Lakehouse. Returns metadata about a materialized view - see syntax, examples, and output.

INSPECT_MV_PLAN

Learn how to use the INSPECT_MV_PLAN meta function in PlaidCloud Lakehouse. Returns the logical plan of a materialized view - with syntax and examples.

INSPECT_MV_REFRESH_INFO

Learn how to use the INSPECT_MV_REFRESH_INFO meta function in PlaidCloud Lakehouse. Returns refresh information for a materialized view.

INSPECT_MV_RELATIONSHIPS

Learn how to use the INSPECT_MV_RELATIONSHIPS meta function in PlaidCloud Lakehouse. Returns dependency relationships for a materialized view.

INSPECT_RELATED_MV

Learn how to use the INSPECT_RELATED_MV meta function in PlaidCloud Lakehouse. Returns materialized views related to a table - with syntax and examples.

INSPECT_TABLE_PARTITION_INFO

Learn how to use the INSPECT_TABLE_PARTITION_INFO meta function in PlaidCloud Lakehouse. Returns partition information for a table - with syntax and examples.

INSPECT_TASK_RUNS

Learn how to use the INSPECT_TASK_RUNS meta function in PlaidCloud Lakehouse. Returns execution history of a task - see syntax, examples, and output.

LOOKUP_STRING

Learn how to use the LOOKUP_STRING meta function in PlaidCloud Lakehouse. Looks up a string in a dictionary and returns the corresponding ID.