Known issue - SQL analytics endpoint tables lose statistics

After you successfully sync your tables in your SQL analytics endpoint, the statistics get dropped.

Status: Open

Product Experience: Data Warehouse

Symptoms

Statistics created on the SQL analytics endpoint tables aren't available after a successful sync between the lakehouse and the SQL analytics endpoint.

Solutions and workarounds

The behavior is currently expected for the tables after a schema change. You need to recreate the statistics or allow the auto statistics to run when necessary.

Next steps