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.

Returns partition information for a table.

Analyze Syntax

func.inspect_table_partition_info(<catalog>, <db>, <table>)

Analyze Examples

func.inspect_table_partition_info('default', 'mydb', 'my_table')

┌──────────────┐
│ (partitions)  │
└──────────────┘

SQL Syntax

INSPECT_TABLE_PARTITION_INFO(<catalog>, <db>, <table>)

SQL Examples

SELECT * FROM TABLE(INSPECT_TABLE_PARTITION_INFO('default', 'mydb', 'my_table'));

┌──────────────────┐
│ (partition info)  │
└──────────────────┘