What causes SYNAPSE_SQL_0001?

The dedicated SQL pool was paused (manually or by auto-pause schedule) to save cost. The pool is in the middle of resuming and not yet ready to accept connections. A scaling operation is in progress. Planned or unplanned Azure maintenance

How do I fix SYNAPSE_SQL_0001?

Step 1: Check the pool status in the Azure portal: Synapse workspace > Dedicated SQL pools.. Step 2: Resume the pool if paused: click 'Resume' in the portal or use PowerShell: `Resume-AzSynapseSqlPool`.. Step 3: Wait 2–5 minutes for the pool to fully resume before retrying the connection.. Step 4: Configure auto-resume in linked services so ADF pipelines trigger resume automatically.. Step 5: Set up MetricSign alerts to detect pool downtime and notify on-call engineers.

Critical severityconnectivity

Power BI Refresh Error:
SYNAPSE_SQL_0001

What does this error mean?

The Synapse dedicated SQL pool is paused, being resumed, or temporarily unavailable.

Common causes

1The dedicated SQL pool was paused (manually or by auto-pause schedule) to save cost
2The pool is in the middle of resuming and not yet ready to accept connections
3A scaling operation is in progress
4Planned or unplanned Azure maintenance

How to fix it

1Step 1: Check the pool status in the Azure portal: Synapse workspace > Dedicated SQL pools.
2Step 2: Resume the pool if paused: click 'Resume' in the portal or use PowerShell: `Resume-AzSynapseSqlPool`.
3Step 3: Wait 2–5 minutes for the pool to fully resume before retrying the connection.
4Step 4: Configure auto-resume in linked services so ADF pipelines trigger resume automatically.
5Step 5: Set up MetricSign alerts to detect pool downtime and notify on-call engineers.

Frequently asked questions

How do I monitor for Dedicated SQL Pool Unavailable in my pipelines?

Connect Azure Data Factory to MetricSign — failed pipeline runs trigger incident alerts with the root cause, so your team is notified before users notice report failures.

Official documentation: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/troubleshoot-synapse-studio