Python Notebook read Delta Table using default lakehouse

[MangoMagic]

In python notebook is there a way to read delta table from default lakehouse which is already mounted instead of using absolute path with workspace?

Would prefer to use relative paths, the code snippets for writing to lakehouse table have this option but when reading from table the code snippet seems to only have option full path 😕 

[Vinodh247]

Yes, you can read Delta tables in Microsoft Fabric Notebooks using relative paths, similar to how you write them. The key is to reference the mounted Lakehouse path, typically under /lakehouse/default (for the default Lakehouse).

To Read a Delta Table from the Default Lakehouse (Mounted):

If the Lakehouse is already mounted in the notebook (as it usually is) you can use a relative path like

 from deltalake import DeltaTable # Relative path to the delta table inside the default lakehouse relative_table_path = "/lakehouse/default/Files/tables/my_table" # Read delta table dt = DeltaTable(relative_table_path) df = dt.to_pyarrow_dataset().to_table().to_pandas() display(df) 

Do not use the full Fabric workspace URL (abfss://...) unless required for advanced use cases or cross-Lakehouse access. For Tables instead of Files, use /lakehouse/default/Tables/my_table if that is where your Delta tables are written.

[MangoMagic]

Thanks, for this delta table why does it need to have several intermediate functions to load into a dataframe:

dt.to_pyarrow_dataset().to_table().to_pandas() 

Is there a better way to read delta table into a data frame to manipulate in Python notebook?

What is "to_pyarrow_dataset"?