Azure Synapse Analytics | Pipeline | Linked Service to "Azure Database for PostgreSQL" not available in 'Stored Procedure'

Lorenzo Perino 20 Reputation points
2024-05-21T10:06:49.0933333+00:00

Hi everyone,

I am trying to create a simple pipeline in Azure Synapse Analytics which should write some files' metadata fields into a Database.

To do so, I first created a linked service to a postresql database instance hosted on Azure:

Linked Service to Azure Database for PostreSQL

I am now trying to reference the linked service above from a 'Stored Procedure' block within my Pipeline, but unfortunately it does not appear as available:

Stored Procedure cannot reference an Azure Database for PostreSQL linked service

I guess the reason for this is that "Azure Database for PosgreSQL" in not among the resources list that can be referenced from a "Stored Procedure" block.

In fact, if I try to create a new linked service from the dialogue box above, "Azure Database for PostresSQL" is not listed as a possible choice.

Is there an alternative way to reference an "Azure Database for PostresSQL" Linked Service from within a 'Stored Procedure' block of a pipeline?

I am new to Azure Synapse Analytics, any help is highly appreciated :)

Cheers!

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,566 questions
Azure Database for PostgreSQL
0 comments No comments
{count} votes

Accepted answer
  1. Smaran Thoomu 11,695 Reputation points Microsoft Vendor
    2024-05-21T10:39:29.81+00:00

    Hi @Lorenzo Perino

    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:

    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful