What causes SYNAPSE_SQL_0010?

Table was loaded or significantly modified without running UPDATE STATISTICS. Auto-update statistics is disabled on the pool. New columns added to a table without creating statistics on them

How do I fix SYNAPSE_SQL_0010?

Step 1: Update statistics on the relevant tables: `UPDATE STATISTICS ;`. Step 2: Enable auto-update statistics: `ALTER DATABASE SET AUTO_UPDATE_STATISTICS ON;`. Step 3: Create statistics on join and filter columns: `CREATE STATISTICS stat_col ON ( );`. Step 4: Schedule regular statistics updates as part of the post-load pipeline step.

Medium severityschema

Power BI Refresh Error:
SYNAPSE_SQL_0010

What does this error mean?

The query optimizer is using outdated or missing statistics, leading to poor query plans and slow performance.

Common causes

1Table was loaded or significantly modified without running UPDATE STATISTICS
2Auto-update statistics is disabled on the pool
3New columns added to a table without creating statistics on them

How to fix it

1Step 1: Update statistics on the relevant tables: `UPDATE STATISTICS <table>;`
2Step 2: Enable auto-update statistics: `ALTER DATABASE <db> SET AUTO_UPDATE_STATISTICS ON;`
3Step 3: Create statistics on join and filter columns: `CREATE STATISTICS stat_col ON <table>(<col>);`
4Step 4: Schedule regular statistics updates as part of the post-load pipeline step.

Frequently asked questions

How do I monitor for Statistics Not Available / Outdated 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