Reply
Chandana_V
Frequent Visitor

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

Hi,

 

I created a Delta table using the underlying files of an external table. I want to specify a different path for the underlying files so they aren't stored in the same location as the external table's underlying files. Is there a way to set a new path for the Delta table while keeping the external table files separate? 

 

Thank You

2 ACCEPTED SOLUTIONS
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

akashparthe
Regular Visitor

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';

View solution in original post

3 REPLIES 3
akashparthe
Regular Visitor

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';

v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi, I have a lakehouse with schema preview features but I am getting path that already exists:

Please see the below image:

mmaxood_0-1737636510092.png

 

Can someone please assist on this?

 

avatar user

Helpful resources

Announcements
MarchFBCvideo - carousel

Fabric Monthly Update - March 2025

Check out the March 2025 Fabric update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)