Forum Discussion
Error when writing data into schema enabled lakehouse using notebooks
- Anonymous1 year ago
Resolution: The issue is caused by the use of internal APIs. In some cases, the internal APIs are returning a 403 when routed to a datacenter where the user is not present. The fix is to move to the public APIs. The code is already in there, but we need to provide the switch from the workload code.
%%pyspark
!echo "spark.trident.pbiApiVersion=v1">>/home/trusted-service-user/.trident-context
The fix would be deployed within 3 to 4 weeks in all production regions.
I can reproduce your errors. Looks like a bug to me, as Microsoft described in Fabric documentation it should be possible to create new tables using saveAsTable (Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn). Consider reporting it as a bug to Microsoft.
Also, keep in mind that lakehouse schemas are currently in public preview having tons of limitations (Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn).
HTH,
Pawel