java.lang.SecurityException: Could not verify permissions for DeleteFromTable ERROR IN EXTERNAL SYNAPSE TABLE

carlosst01 — Thu, 25 May 2023 18:15:51 GMT

Hi guys, I am trying to delete an external table in Databricks that is connected to a Synapse table (via the com.databricks.spark.sqldw connector) but got the error shown below:

Apart from that, when I try to execute an DELETE and INSERT actions (like an upsert) in the postActions option, it seems like the table in Synapse gets corrupted as it does not show any information. The SQL code is the shown below:

When this code runs, it keeps running the "DELETE statement" of the postActions (in Synapse) until it gets timeOuted as shown below:

The twist here is that it worked for many months and recently started to fail like this way. Additionally, governance says permissions in the user from Synapse and IAM are all correctly assigned, what do you think is the problem ?

topic java.lang.SecurityException: Could not verify permissions for DeleteFromTable ERROR IN EXTERNAL SYNAPSE TABLE in Data Engineering

java.lang.SecurityException: Could not verify permissions for DeleteFromTable ERROR IN EXTERNAL SYNAPSE TABLE