topic Re: Enable predictive optimization for my account in Data Engineering

Enable predictive optimization for my account

Sadam97 — Mon, 16 Dec 2024 09:03:02 GMT

I want to enable predictive optimization for my account for but i can not see the option as mentioned in documentation

Access the accounts console.
Navigate to Settings, then Feature enablement.
Select Enabled next to Predictive optimization.

I am metastore owner and account admin, my cloud region is eu-west3.

Re: Enable predictive optimization for my account

Walter_C — Mon, 16 Dec 2024 11:37:50 GMT

Is your account Premium tier enabled? Also when your account was created?

Re: Enable predictive optimization for my account

Sadam97 — Mon, 16 Dec 2024 11:42:12 GMT

Account was created in July 2024 and premium tier is enabled as i am using unity catalog. I get the error the below error when tried to enable predictive optimization on schema.

ErrorClass=INVALID_PARAMETER_VALUE.PREDICTIVE_OPTIMIZATION_DISABLED_CONSTRAINT] Cannot set predictive optimization field because predictive optimization is disabled on the metastore.

Re: Enable predictive optimization for my account

Walter_C — Mon, 16 Dec 2024 11:55:15 GMT

So just to confirm the field shows in the Account Console, but it shows as disabled, if you change it to enabled it fails and get back to disable mode?

Re: Enable predictive optimization for my account

Sadam97 — Mon, 16 Dec 2024 15:06:16 GMT

The error above is when i try to do it by command. On account console -> setting -> feature enablement , I can not see option such as Predictive optimization. Check attached SS

Re: Enable predictive optimization for my account

Walter_C — Mon, 16 Dec 2024 16:46:44 GMT

Can you share with me the workspace id? Also what happens if you run on a catalog

ALTER CATALOG [catalog_name] {ENABLE | DISABLE} PREDICTIVE OPTIMIZATION;

Re: Enable predictive optimization for my account

Sadam97 — Tue, 17 Dec 2024 10:09:48 GMT

My workspace id is, 3976272202403488 .It gives this error,

UnityCatalogServiceException: [RequestId=693c0119-f759-953e-b7a8-7ed2271b7849 ErrorClass=INVALID_PARAMETER_VALUE.PREDICTIVE_OPTIMIZATION_DISABLED_CONSTRAINT] Cannot set predictive optimization field because predictive optimization is disabled on the metastore.

Re: Enable predictive optimization for my account

Walter_C — Tue, 17 Dec 2024 12:02:04 GMT

Got it, after reviewing your workspace I can notice that it is GCP workspace located in europe-west3, as of now Predictive Optimization is not supported on GCP side, there are few regions that are set to be enabled by end of Q4 but unfortunately the region you are located is not part of this list as this region still not have all the requirements available at the cloud level to support it.