Known issue - SQL analytics endpoint tables lose permissions
After you successfully sync your tables in your SQL analytics endpoint, the permissions get dropped.
Status: Open
Product Experience: Data Warehouse
Symptoms
Permissions applied to the SQL analytics endpoint tables aren't available after a successful sync between the lakehouse and the SQL analytics endpoint.
Solutions and workarounds
The behavior is currently expected for the tables after a schema change. You need to reapply the permissions after a successful sync to the SQL analytics endpoint.