Thanks for the question and using MS Q&A platform.
As per the Azure Synapse Analytics documentation, the Stored Procedure activity only supports Azure SQL Database, Azure Synapse Analytics, and SQL Server Database. Therefore, you cannot directly reference an "Azure Database for PostgreSQL" linked service from within a 'Stored Procedure' block of a pipeline.
As a workaround, you can check out the below threads which addressing similar issue:
- Execute PostgreSql stored procedure in azure data factory
- Cannot run stored procedures for postgreSQL in azure
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.