I encountered an issue while using Azure Synapse’s Lookup Activity to call a stored procedure that deletes records from a table. Despite the activity completing almost instantaneously, no records were deleted. Initially, I suspected that the problem might be related to permissions. However, the stored procedure sometimes works when triggered manually, but not always.

I verified that the PostgreSQL grants are correctly configured, and when I manually execute the stored procedure with the following command, it successfully deletes the records:

SQL

CALL deleteSPrecords();SELECT 1 AS output;

Has anyone else faced a similar issue or have insights on why this inconsistency might occur