Custom Path for Delta Table's Files Created from External Table underlying Files

Hi Chandana_V,

For the default lakehouse table level, it not allow you to create sub folders. I'd like to suggest you store these on the file level or change to use the lakehouse which enable the preview schema features.
Regards,

Xiaoxin Sheng

You can specify a different path for the underlying files of a Delta table
This way, the Delta table’s files will be separate from the external table’s files.
CREATE TABLE delta_table
USING DELTA
LOCATION 'path/to/new/delta/table';