Azure PowerShell Synapse modules command not working or giving errors for Synapse default Serverless SQL Pool

Question

Azure PowerShell Synapse modules command not working or giving errors for Synapse default Serverless SQL Pool

Siddharth Joshi 231

Hi, In my Synapse workspace only Serverless SQL POOL we have and I want to do some operation by using PowerShell module like Get-AzSynapseSqlDatabase & Get-AzSynapseSqlPool but both commands are not working either its not giving any output or giving some errors like "Internal server errors" or "Not found" FYI my synapse workspace is in managed private endpoints so I'm not sure because of this restriction I'm unable to use these commands ? Errors: User's image

User's image

PRADEEPCHEEKATLA 91,866 Reputation points

2023-04-17T06:34:33.2566667+00:00

Siddharth Joshi - We received your feedback that the answer provided on the thread was not helpful.
Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback.

I have provided a detailed answer which has clear steps for which you are looking for.If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!

Regards,

PRADEEPCHEEKATLA-MSFT
PRADEEPCHEEKATLA 91,866 Reputation points

2023-04-24T04:39:50.3633333+00:00

Siddharth Joshi - Just checking in to see if the below answer helped. 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. And also, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Answer accepted by question author

0 additional answers

Your answer

PRADEEPCHEEKATLA 91,866 Reputation points

2023-04-17T06:34:33.2566667+00:00

Siddharth Joshi - We received your feedback that the answer provided on the thread was not helpful.
Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback.

I have provided a detailed answer which has clear steps for which you are looking for.If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!

Regards,

PRADEEPCHEEKATLA-MSFT
PRADEEPCHEEKATLA 91,866 Reputation points

2023-04-24T04:39:50.3633333+00:00

Siddharth Joshi - Just checking in to see if the below answer helped. 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. And also, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Answer 1

PRADEEPCHEEKATLA 91,866

Siddharth Joshi - Thanks for the question and using MS Q&A platform.

Get-AzSynapseSqlPool - This command gets all SQL pools under a workspace.

As per the repro I was able to get the SQL pools available under my workspace.

Here is the snapshot of Azure Portal:

User's image

Here is the snapshot of PowerShell: User's image

Note: Get-AzSynapseSqlDatabase - This feature is in a limited preview, initially accessible only to certain subscriptions. Which means this command is not available for all the subscriptions.

As per the repro, I'm getting the same error message as shown above.

User's image

Hope this helps. Do let us know if you any further queries.

Siddharth Joshi 231 Reputation points

2023-04-12T18:19:34.6566667+00:00

Hello @PRADEEPCHEEKATLA It is clear from snapshots that Get-AzSynapseSqlPool will not provide details of Serverless SQL Pool which I want in my case. And Get-AzSynapseSqlDatabase will only limited with certain subscriptions and not sure it will provide info of Serverless SQL DB because in our case it is giving "Internal Server Error". Please let me know Is there any solution from which I can get Serverless SQL Pool or Serverless SQL DB info.
PRADEEPCHEEKATLA 91,866 Reputation points

2023-04-13T02:37:39.9133333+00:00

Siddharth Joshi - Just to clear couple of things here.

There is no command which is available to get Serverless SQL Pool which you are looking for.
Note: The reason why there is no command because there will be only one Built-in serverless SQL pool for a Synapse workspace.

Regarding the Get-AzSynapseSqlDatabase feature is in a limited preview, initially accessible only to certain subscriptions.
Hope this helps. Do let us know if you any further queries.
Siddharth Joshi 231 Reputation points

2023-04-14T05:42:38.3833333+00:00

Thanks @PRADEEPCHEEKATLA for clarification.
PRADEEPCHEEKATLA 91,866 Reputation points

2023-04-19T04:48:03.95+00:00

Siddharth Joshi - Following up to see if the above answer was helpful. 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.

Share via

Azure PowerShell Synapse modules command not working or giving errors for Synapse default Serverless SQL Pool

0 additional answers

Your answer