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

[Saeid_H]

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! 🙂

[Saeid_H]

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]

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]

@Joseph Kambourakis​  thank you for your response.

[Anonymous]

No problem. Glad I could help!

[Anonymous]

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!