cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Enable predictive optimization for my account

Sadam97
New Contributor III

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

  1. Access the accounts console.

  2. Navigate to Settings, then Feature enablement.

  3. Select Enabled next to Predictive optimization.

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

7 REPLIES 7

Walter_C
Databricks Employee
Databricks Employee

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

Sadam97
New Contributor III

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.

Walter_C
Databricks Employee
Databricks Employee

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?

Sadam97
New Contributor III

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

Sadam97_0-1734361546250.png

 

Walter_C
Databricks Employee
Databricks Employee

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;

Sadam97
New Contributor III

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.

Walter_C
Databricks Employee
Databricks Employee

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.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group