topic Re: How to change the feature store delta table default path on DBFS? in Machine Learning

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

Saeid_H — Wed, 08 Feb 2023 10:37:08 GMT

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

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

Saeid_H — Fri, 10 Feb 2023 07:53:33 GMT

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

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

Anonymous — Fri, 10 Feb 2023 18:15:10 GMT

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.

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

Saeid_H — Fri, 17 Feb 2023 15:29:18 GMT

@Joseph Kambourakis thank you for your response.

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

Anonymous — Fri, 17 Feb 2023 15:54:01 GMT

No problem. Glad I could help!

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

Anonymous — Sat, 08 Apr 2023 07:40:47 GMT

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!