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 ?
