Azure Synapse Error :This query cannot be executed because we can't get enough capacity for optimal performance in time. This can be an intermittent issue. Please retry later.

amit karmakar 0 Reputation points
2024-06-28T13:39:30.8133333+00:00

Strangely since morning Synapse SQL Serverless on one environment is not able to query external data in a storage account. This was running fine till now

[This query cannot be executed because we can't get enough capacity for optimal performance in time. This can be an intermittent issue. Please retry later.]

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,622 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. BhargavaGunnam-MSFT 28,616 Reputation points Microsoft Employee
    2024-06-28T21:10:21.5133333+00:00

    Hello amit karmakar

    The product team deployed the fix, and the issue has been mitigated. You should not see these errors anymore.

    In case you still encounter any issues, please let me know.

    If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.

    0 comments