topic How to list tables of Lakehouse using spark in Pipelines

How to list tables of Lakehouse using spark

antoniofarias — Thu, 16 May 2024 18:58:56 GMT

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

Re: How to list tables of Lakehouse using spark

Anonymous — Fri, 17 May 2024 05:45:47 GMT

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

Re: How to list tables of Lakehouse using spark

Anonymous — Mon, 20 May 2024 15:54:32 GMT

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

Re: How to list tables of Lakehouse using spark

Anonymous — Tue, 21 May 2024 16:42:58 GMT

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