My serverless sql pool status is showing N/A in azure syanpse workspace. I am unable to run the query

Darshan 0 Reputation points
2023-08-31T03:47:43.86+00:00

My serverless sql pool status was online and was running the query initially but after few days it started showing N/A and cant run the query. I have cleared the cache and cookies but still the same.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,921 questions
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,492 Reputation points Microsoft Employee
    2023-08-31T23:36:54.69+00:00

    @Darshan Welcome to Microsoft Q&A forum and thanks for reaching out here.

    I would highly encourage you to go through this troubleshooting guide and see if it helps to resolve your issue. This issue usually occurs when your network prevents communication to the Azure Synapse Analytics back-end.

    Ref MS Doc: Troubleshoot serverless SQL pool in Azure Synapse Analytics

    User's image

    User's image

    Hope this info helps. In case if the provided troubleshooting guide didn't help to resolve the issue, it may need deeper investigation. Please let us know how it goes.

    Thank you


    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.