Creating Database in Databricks
The choice between creating a database with or without location specifying a location depends on your specific requirement. If you want simplicity and are comfortable with Databricks default location. You can create a database without specifying a location. If you need more control over the storage location, especially in cloud environments, you can choose the specify a location when creating the database.