systems table predictive_optimization_operations_history stays empty

[suqadi]

Hi,

For our lakehouse with Unity catalog enabled, we enabled predictive optimization feature for several catalogs to clean up storage with Vacuum. When we describe the catalogs, we can see that predictive optimization is enabled. The system table for predictive optimization is also enabled. Other settings have been left on default so the history being stored is still 7 days.

However, it has already been almost a week, but the systems table 'system.storage.predictive_optimization_operations_history' still stays empty.

So we have no clue if the predictive optimization works in the first place.

How long can it take before predictive optimization is run and is it possible to run predictive optimization manually?

Hopefully someone can help us with this. Thanks!

[Walter_C]

Hello as per docs data could take 24 hours to be retrieved, can you confirm if the below requirement are met?

Your region must support predictive optimization (see Databricks clouds and regions).