Forum Discussion
ismail_ozturk
Helper I
Helper ILakehouse 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/...
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)
Thomaslleblanc
Super User
Super UserThere is a more complicated way to grant access to the underlying folder structure (Tables\dimCategory), but I think it is still in preview.
ismail_ozturkHelper I
Helper IYeah it is still in preview and does not work for now as fas as I tested.