Thanks @MoJaMa!

Originally, I attempted the grant using a SQL Warehouse and it failed. However, I ran again in a notebook using serverless compute and it succeeded. This does appear to resolve the original issue.

On a side note, the original error was when creating a view over files using an abfss path. However, I modified it to use the Volumes path and the error still persisted. I would have thought this would have removed the need for the ANY FILES permission (since a UC object). I'll do more testing on that.

As for the "SparkConnectGrpcException: 403 Forbidden: 403: Invalid access token." error, any insight into why this is happening? As far as I can tell, the principal has all the original grants that it originally had, but it can no longer run a spark.sql command within the serverless compute (while this works fine in other environments).