cancel
Showing results for 
Search instead for 
Did you mean: 
Machine Learning
Dive into the world of machine learning on the Databricks platform. Explore discussions on algorithms, model training, deployment, and more. Connect with ML enthusiasts and experts.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to change the feature store delta table default path on DBFS?

Saeid_H
Contributor

Hi everyone,

Would it be possible to change the default storage path of deature store, during creation and/or after creation? If you could also provide the python script to that I would appreciate. The current default path is:

"dbfs/user/hive/warehouse/<feature database name>/<feature table name>”

With many thanks in advance! 🙂

5 REPLIES 5

Saeid_H
Contributor

I found the solution, but there is still one question remained unanswered, which is, how to change the directory after creating FS. To change the default path, all is needed to set the path argument in

fs = feature_store.FeatureStoreClient()
fs.create_table(name= '', primary_keys = [], .., path = "user given path")
                             

Anonymous
Not applicable

The config you're looking for is "spark.sql.warehouse.dir"

Here is the documentation

@Saeid Hedayati​ is correct that you can set the path when creating the feature store. It's an optional parameter listed here.

Once the table is created, you can't change the path because it's got all the files in it. You can potentially clone the table but migration would require moving all the files.

Saeid_H
Contributor

@Joseph Kambourakis​  thank you for your response.

Anonymous
Not applicable

No problem. Glad I could help!

Anonymous
Not applicable

Hi @Saeid Hedayati​ 

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you. 

Cheers!

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!