Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Fix issue with spark "show tables" command when lakehouse has schemas

 

The show tables spark function should be lakehouse aware.  If it is without a schema, then search the root of the catalog.  If it has the schemas option enabled, then default to the "dbo" schema.  Otherwise, allow a "schema name" to be passed as an option.

 

A work around for now is the mssparkutils.fs.ls("Tables/Schema").  Then filter by any folder names only, these are the table directories.

 

 
 

Screenshot 2026-04-02 131602.png

 

Here is a screen shot for a schema less Fabric Lakehouse that works as expected.

 

JohnMiner3_2-1775159871106.png

 

Please fix this bug!

 

Status: New