- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, please consider accept as solution to help other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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';
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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';
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, please consider accept as solution to help other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, I have a lakehouse with schema preview features but I am getting path that already exists:
Please see the below image:
Can someone please assist on this?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
02-04-2025 10:44 PM | |||
07-31-2024 03:08 AM | |||
06-11-2024 05:02 AM | |||
02-28-2025 04:43 AM | |||
10-08-2024 05:57 AM |
User | Count |
---|---|
8 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
10 | |
9 | |
7 | |
7 | |
5 |