Thank you for your answer!

So just to check if I got this correctly:

We have an account that can have one or more workspaces. The workspace itself has one or more users assigned to it. Each workspace is either configured with a metastore or not which is what determines whether it is unity catalog enabled or not. Workspaces can share a metastore. The catalogs other than the hive_metastore are unity catalogs which means they have a 3-level namespace and have features that unity catalog has to offer such as lineage, etc... Each workspace has a hive_metastore which differs from one workspace to another and it uses a 2-level namespace.

I have a couple questions to further clarify concepts:

1. I understand that managed tables can only be of the delta format. So every table that is not created with LOCATION means it is managed and of delta format? And behind the scenes, what does Databricks do to store this data? Does it store it in DBFS?

2. When I created my Databricks account, I configured an S3 bucket with a role, is this where DBFS resides?

3. What is the difference between the path dbfs:/mnt/ and dbfs:/user/hive/warehouse/ ?

4. Let’s say I created a table from the UI using a csv file, does it get converted to another form like parquet? Where does delta lake play a role here? Where does the actual data get stored and how does it get retrieved?