topic Re: What is a recommended directory for creating a database with a specified path? in Data Engineering

What is a recommended directory for creating a database with a specified path?

Dilorom — Sun, 19 Feb 2023 22:51:50 GMT

I was going through Data Engineering with Databricks training, and in DE 3.3L - Databases, Tables & Views Lab section, it says "Defining database directories for groups of users can greatly reduce the chances of accidental data exfiltration." I agree with it, and want to specify a path for my database, but not sure what directory is ideal to provide as a path. Under DBFS, what directory would be the best to create my database? Any best practices or recommendations around this?

Re: What is a recommended directory for creating a database with a specified path?

Rishabh-Pandey — Wed, 22 Feb 2023 10:08:08 GMT

great explanation @Kaniz Fatma

Re: What is a recommended directory for creating a database with a specified path?

youssefmrini — Fri, 24 Feb 2023 13:42:51 GMT

With Unity Catalo, if it's managed location you can define the location of where to store the catalog or the Database or the table. ( Needs to be a Delta table ofc)

Re: What is a recommended directory for creating a database with a specified path?

Anonymous — Sat, 22 Apr 2023 04:47:04 GMT

Hi @Dilorom A

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!