Permission error loading dataframe from azure unity catalog to GCS bucket

kiko_roy
Contributor

I am creating a data frame by reading a table's data residing in Azure backed unity catalog. I need to write the df or file to GCS bucket. I have configured the spark cluster config using the GCP service account json values.

on running : 

df1.write.format("parquet").save("gs://dev-XXXX-analyt-XXXXXXXX") getting error :
Insufficient privileges: User does not have permission SELECT on any file.. what could be the reason or resolution. Need help

Thanks @Retired_mod . The solution did work !!

ruloweb
New Contributor II

Hi, is there any terraform resource to apply this GRANT or this have to be done always manually?

Hi @ruloweb , apart from granting access manually on any File, one way that resolved the issue for me was to use a cluster with single user.