LonaOsmani
New Contributor III

Hi @lmu ,

To use dedicated compute to write to a table with row level security:
- Serverless must be enabled in your workspace (because the dedicated compute passes the query to serverless to perform the data filtering)
- The dedicated compute must be on Databricks Runtime 16.3 or above

(https://learn.microsoft.com/en-us/azure/databricks/compute/single-user-fgac#support-for-write-operat... )


I think the error message you are encountering, PATH_BASED_ACCESS_NOT_SUPPORTED_FOR_TABLES_WITH_ROW_COLUMN_ACCESS_POLICIES, comes from this statement 'CREATE TABLE...'. The solution would be to first check if the table exists using system tables.