Forum Discussion

ismail_ozturk's avatar
ismail_ozturk
Helper I
9 months ago
Solved

Lakehouse Grant Read Permission Problem

Hello everyone, I have tried a lot of things but I could not find a way to grant someone to read specific table (metadata and data) in lakehouse by using Spark without giving read permission to him/...
lakehouse
ismail_ozturk's avatar
ismail_ozturk
Helper I
9 months ago

Hello DaleT ,

I tried the path as you said and also the full path but nothing changed, I got the same error. 

 

DaleT's avatar
DaleT
Resolver II
9 months ago

After some tests, I got the exactly same error message. The cause could be the third to last limitation of schemas in this list: https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-schemas#public-preview-limitations . 

There could be two solutions though they aren't perfect. 

1. Stop using schema. 

2. Use Pyspark instead like following, the address is an ABFS address.

df = spark.read.load("abfss://[email protected]/0558838e7/Tables/dbo/sales")
display(df)

 

  • ismail_ozturk's avatar
    ismail_ozturk
    Helper I
    9 months ago

    Hello DaleT ,

    You are completely right. I have tested this same scenario without using onelake schema and it worked. I wont use this option. Thank you so much

    Best regards