Lists all tables registered in the current compute node's session context.
SHOW SESSION TABLES [LIKE '<pattern>']## Overview Returns a result set listing all tables currently registered with the DataFusion SessionContext on the local compute node. This is a diagnostic command useful for troubleshooting table visibility, registration issues, and understanding what the query engine can access. Unlike SHOW TABLES (which queries the control plane catalog), SHOW SESSION TABLES reflects the actual in-memory state of the compute node's query engine. ## Behavior - Enumerates all catalogs, schemas, and tables registered in the DataFusion SessionContext. - Returns columns: catalog, schema, table_name. - When LIKE is specified, the pattern is applied to the table_name column using SQL wildcard matching (% and _), case-insensitively. - Results are sorted alphabetically by catalog, schema, and table name. - This command does not query the control plane. It reads directly from the local session state. - Tables that appear here include both catalog-registered tables and tables opened locally via OPEN DELTA TABLE. ## Compatibility SHOW SESSION TABLES is a DeltaForge extension for debugging the compute node's runtime state. There is no ANSI SQL equivalent.
-- List all tables in the current session
SHOW SESSION TABLES;-- Filter session tables by name pattern
SHOW SESSION TABLES LIKE '%events%';-- Find session tables starting with 'temp'
SHOW SESSION TABLES LIKE 'temp%';