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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayFBCUpdateCarousel

Fabric Monthly Update - May 2024

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