Not able to fetch serverless sql db into azure synpase pipeline for copy data pool

Ashish Asthana 40 Reputation points
2024-06-13T13:08:30.7333333+00:00

Hello Community,

I have created one serverless pool db in Synapse and am trying to connect this serverless sql db as a destination to get table from azure sql db.

User's image

In the drop down , I am just getting my dedicated sql pool (dspcodemsynps) not serverless_pool_db_codem.. see below image..however I can see serverless sql db on SSMS as well.

Any reason, why I am not getting serverless sql db in drop down here-

User's image

User's image

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,670 questions
{count} votes

Accepted answer
  1. Vinodh247 13,226 Reputation points
    2024-06-13T13:42:26.0633333+00:00

    Hi Ashish Asthana,

    Thanks for reaching out to Microsoft Q&A.

    If you don't see the databases that are created in serverless SQL pool, check to see if your serverless SQL pool started. If serverless SQL pool is deactivated, the databases won't show. Execute any query, for example, SELECT 1, on serverless SQL pool to activate it and make the databases appear.

    https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand?tabs=x80070002#serverless-databases-arent-shown-in-synapse-studio

    Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Ashish Asthana 40 Reputation points
    2024-06-17T12:43:14.7766667+00:00

    Vinodh247-1375, This is fixed by your suggested way..Thanks a lot..

    0 comments No comments