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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
antoniofarias
Frequent Visitor

How to list tables of Lakehouse using spark

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()

 

 

 

1 ACCEPTED SOLUTION
v-nikhilan-msft
Community Support
Community Support

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

View solution in original post

3 REPLIES 3
v-nikhilan-msft
Community Support
Community Support

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

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

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

Helpful resources

Announcements
FabricCarousel_June2024

Fabric Monthly Update - June 2024

Check out the June 2024 Fabric update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.