This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid 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
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.
Here is a screen shot for a schema less Fabric Lakehouse that works as expected.
Please fix this bug!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.