Thanks you Pat,

When running this query im getting the below exception:

rror in SQL statement: SparkException: Trying to perform permission action on Hive Metastore /ANY_FILE but Table Access Control is not enabled on this cluster.

I verified and my workspace settings are with enable table access control is enabled.