@Ashish Singh​ :

In Databricks, it is not recommended to create multiple tables on the same location in the same database and schema. The Unified Analytics Warehouse (UAW) used by Databricks enforces a one-to-one mapping between tables and directories in the underlying file system. If you try to create multiple tables with the same location in the same database and schema, you will receive a "LOCATION_OVERLAP" error message because it conflicts with this one-to-one mapping.

However, it is possible to create multiple tables on the same location in different databases or schemas in Databricks. In this case, each table is treated as a separate object in the UAW and has its own unique metadata associated with it.

If you need to store multiple tables with the same data in Databricks, you may consider creating views on top of the original table, rather than creating additional tables on the same location. Views can provide an efficient and flexible way to manipulate data without duplicating the underlying data.