Azure Data Studio Cannot get to the programmability group for Azure SQL Serverless

Jorge L Dominguez 46 Reputation points
2024-06-02T23:01:19.78+00:00

I'm having trouble accessing the programmability group for Azure SQL Serverless in Azure Data Studio. For example, when I create a stored procedure in the Serverless pool, I cannot see it or access it. Additionally, the sp_helptext procedure is not supported in Serverless. The only way I can access the programmability group of the Azure Synapse SQL Serverless pool is by opening SSMS.

Is this a feature that you are planning to implement, or is it an oversight?

Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
106 questions
{count} votes

2 answers

Sort by: Most helpful
  1. ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee
    2024-06-03T08:29:26.8066667+00:00

    Hi Jorge L Dominguez •,

    Welcome to Microsoft Q&A forum.

    As I understand, you could not access Programmability Group in Azure Data Studio to access Stored Procedures of Azure SQL Database Serverless.

    I have created test DB Serverless and tried to access in Azure Data Studio as shown below and could find details of the test SP created there as shown below:

    User's image

    User's image

    Let us know what issue you are experiencing in doing the same, please share configuration details of the Database and error screenshot for better understanding.

    Thanks.

    0 comments No comments

  2. ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee
    2024-06-04T03:42:29.9333333+00:00

    Hi Jorge L Dominguez •,

    I have checked internally of the question is about Azure Synapse SQL Serverless pool:

    “There are no planned improvements to Azure Data Studio for Azure Synapse at this time"

    Thanks

    0 comments No comments