topic Unity Catalogue and SAS data using spark-sas7dbat in Data Engineering https://community.databricks.com/t5/data-engineering/unity-catalogue-and-sas-data-using-spark-sas7dbat/m-p/80612#M36088 <P>Information in this post&nbsp;<A href="https://www.databricks.com/blog/2022/03/16/how-to-speed-up-data-flow-between-databricks-and-sas.html" target="_blank">Speed Up Data Flow: Databricks and SAS | Databricks Blog</A>&nbsp;led me to using spark-sas7dbat package to read SAS files and save to delta for downstream processes with great results. I was able to load very large files quickly that weren't working with pandas or other methods I'd tried.<BR /><BR />Recently made the move to using Unity Catalogue, currently using a cluster with DBR 13.3. I am not an admin, but I have ALL PRIVILEGES. When I try to use the spark-sas7dbat package,&nbsp; I am now getting the error: "<SPAN>User does not have permission SELECT on any file</SPAN><SPAN>&nbsp;</SPAN>error message." which doesn't make sense to me in the context of UC permissions model. I'm a bit lost for next steps, any ideas on how to address are welcome</P> Thu, 25 Jul 2024 17:28:07 GMT MKE 2024-07-25T17:28:07Z Unity Catalogue and SAS data using spark-sas7dbat https://community.databricks.com/t5/data-engineering/unity-catalogue-and-sas-data-using-spark-sas7dbat/m-p/80612#M36088 <P>Information in this post&nbsp;<A href="https://www.databricks.com/blog/2022/03/16/how-to-speed-up-data-flow-between-databricks-and-sas.html" target="_blank">Speed Up Data Flow: Databricks and SAS | Databricks Blog</A>&nbsp;led me to using spark-sas7dbat package to read SAS files and save to delta for downstream processes with great results. I was able to load very large files quickly that weren't working with pandas or other methods I'd tried.<BR /><BR />Recently made the move to using Unity Catalogue, currently using a cluster with DBR 13.3. I am not an admin, but I have ALL PRIVILEGES. When I try to use the spark-sas7dbat package,&nbsp; I am now getting the error: "<SPAN>User does not have permission SELECT on any file</SPAN><SPAN>&nbsp;</SPAN>error message." which doesn't make sense to me in the context of UC permissions model. I'm a bit lost for next steps, any ideas on how to address are welcome</P> Thu, 25 Jul 2024 17:28:07 GMT https://community.databricks.com/t5/data-engineering/unity-catalogue-and-sas-data-using-spark-sas7dbat/m-p/80612#M36088 MKE 2024-07-25T17:28:07Z