403 Forbidden when reading the tables of the Lakehouse with sql and spark.sql

[SivaReddy2468]

Hello,
I'm trying to read the delta tables from the Lakehouse, i'm getting the 403 forbidden error. 

Same happening when i try to read with sql

Note: Enabled the schema for the Lakehouse

[Anonymous · Accepted solution]

Hi @SivaReddy2468 

Currently there is a known issue when querying data from lakehouses which have enabled the schema. Please refer to the thread An error occurred while calling o321.sql. - Microsoft Fabric Community

As a workaround, try adding the following code to the top of notebook as the first cell. 

%%pyspark 
!echo "spark.trident.pbiApiVersion=v1">>/home/trusted-service-user/.trident-context

If the workaround doesn't work, you may need to create a new lakehouse without enabling the schema. Sorry for the inconvenience it may cause. The engineers are working on the fix now. We appreciate your patience. I will keep you updated once there is any progress. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos! 

[SivaReddy2468]

Hello @Anonymous 

Thanks for the replying. After applying the suggestions and trying to read the data, I encountered the following results

1. Spark SQL:
   1. Reading from the dbo schema worked fine
      
   2. Reading from the other schema seems not working
      
2. SQL
   1. Reading from the dbo schema worked fine
      
   2. Reading from the other schema seems not working