systems table predictive_optimization_operations_history stays empty

suqadi — Thu, 25 Jul 2024 09:49:40 GMT

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!

Re: systems table predictive_optimization_operations_history stays empty

Walter_C — Mon, 29 Jul 2024 21:03:03 GMT

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).

topic systems table predictive_optimization_operations_history stays empty in Data Engineering

systems table predictive_optimization_operations_history stays empty

Re: systems table predictive_optimization_operations_history stays empty