How to list tables of Lakehouse using spark

[antoniofarias]

Hi, is there anyway to list the tables from lakehouse using ABFS path or URL of lakehouse tables? I know how to do inside the fabric, with "SHOW TABLES" or the mssparkutils with fs.ls, but I need to do this outside the fabric.

Like the function:

spark.catalog.listTables()

[Anonymous · Accepted solution]

Hi @antoniofarias 
Thanks for using Fabric Community.
You can refer to this thread:
python - Get the list of tables from fabric workspace using abfss path - Stack Overflow
If the above link doesn't help, please let me know where you want to use the code to get the list of tables. Or provide me the repro steps.

You can also use Rest API to get the lakehouse tables: Lakehouse management API - Microsoft Fabric | Microsoft Learn

Thanks

[Anonymous]

Hi @antoniofarias 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks

[Anonymous]

Hi @antoniofarias 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks