Saving table to a different lakehouse

[alirng]

Hi All,

We have setup 3 lakehouses within our fabric instance as we are employing a medallion architecture of bronze, silver and gold. The lakehouses are names respectively. The bronze lakehouse contains all raw uncleaned data the silver one will contain cleaned and report ready data and gold will contain aggregated data.

I have written a pyspark notebook that loads in a list of tables and cleans them I would then like to save these tables in the silver lake, currently attempting to do this by using the write command yields in the following error 

{"error":{"code":"Unauthorized","message":"Authentication Failed with Bearer token is not present in the request","requestId":null,"time":null,"detail":null}}

I can confirm that the lakehouse is added to the notebook instance, I just can seem to save to it with this being the path "silver_lake/Tables/tablename"

Am I going about this the wrong way? 

[Anonymous]

Hello @alirng ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

[Anonymous]

Hello @alirng ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread .

[Anonymous]

Hi @alirng  - Thanks for using Fabric Community,

As I understand while you were implementing a medallion architecture in your fabric, you landed up with an issue when saving these tables in the silver lakehouse.

Inorder to save your file in a lakehouse apart from the default lakehouse you need to use ABFS path and if you are saving it as a table try using lakehouse_name.table_name

Please find the screenshot below:


Also can you please share some screenshots of your issue and code you are using to save the file, so I can guide you better.

Hope this is helpful. Please feel free incase of any queries.