Access JSON file in Lakehouse from Microsoft Notebook with other Lakehouse-Default

Question

I have a Microsoft Notebook based on my SILVER-Lakehouse. There I want to access a JSON-File from my BRONZE-Lakehouse.

Doing so with absolute path works:

 # Import all files from bronze folder of lakehouse via absolute path
 df = spark.read.json("abfss://[email protected]/Bronze.Lakehouse/Files/raw/")

But I'd prefer to have like a relative path:

# Would be nice to like relativley address the Bronze-Lakehouse, but that doesn't seem to work
#df = spark.read.json("/Bronze.Lakehouse/Files/raw/")

Answer 1

The easiest way is to just create a shortcut to the target folder in your local SILVER-Lakehouse.