Fabric Notebook with a default lakhouse (Silver) and another lakehouse mounted (Gold)

[DebbieE]

I am creating a dataframe with data from silver lakehouse so this is the default one. dev_silver_lk

But I want to create a dimension Delta Parquet file in the gold lakehouse dev_gold_lk

I have also mounted this Data lake to the notebook (They both are in public preview as I have Schemas ticked)

And I just cant seem to do it? 

Surely this should be possible? 

I suspect it might be because my Lakehouse has Preview schemas? I tried this and it didnt work in Pyspark Notebook

gold_lh = "dev_timesheet_gold_lh"

target_path = gold_lh + "/Tables/dimCustomer"

from delta.tables import DeltaTable

dfBlockersKey_reordered.write.format("delta").mode("overwrite").save(target_path)

But I just get Py4JJavaError: An error occurred while calling o17332.save. : Operation failed: "Bad Request", 400, HEAD,

[Liam_McCauley]

You could try saveAsTable:

dfBlockersKey_reordered.write \
    .format("delta") \
    .mode("overwrite") \
    .saveAsTable("dev_timesheet_gold_lh.dimCustomer")